54 lines
993 B
Plaintext
54 lines
993 B
Plaintext
|
<EFBFBD><EFBFBD>Ң<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> table : endr_tmp_data_print
|
|||
|
|
|
|||
|
|
<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͧ<EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
PROCESS_ID ==> gen <20><>ͤ<EFBFBD><CDA4>駷<EFBFBD><E9A7B7><EFBFBD><EFBFBD>觾<EFBFBD><E8A7BE><EFBFBD><EFBFBD>
|
|||
|
|
TASK_ID ==> <20>ҹ<EFBFBD><D2B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD>͡
|
|||
|
|
USER_ID ==> user <20><><EFBFBD><EFBFBD><EFBFBD>觾<EFBFBD><E8A7BE><EFBFBD><EFBFBD>
|
|||
|
|
SERVER_ID ==> server printer <20><><EFBFBD><EFBFBD><EFBFBD>觾<EFBFBD><E8A7BE><EFBFBD><EFBFBD>
|
|||
|
|
|
|||
|
|
CREATE_BY
|
|||
|
|
CREATE_DATE
|
|||
|
|
UPDATE_BY
|
|||
|
|
UPDATE_DATE
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<EFBFBD>ʴ<EFBFBD> printer server
|
|||
|
|
|
|||
|
|
procedure sp_sch_printer(
|
|||
|
|
cRecordset out sys_refcursor,
|
|||
|
|
sUser_id in varchar2
|
|||
|
|
)
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
procedure sp_sch_team(
|
|||
|
|
cRecordset out sys_refcursor,
|
|||
|
|
sUser_id in varchar2
|
|||
|
|
);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
pkg_ws_login.sp_sch_data_print(crecordset => :crecordset,
|
|||
|
|
steam => :steam,
|
|||
|
|
spolicy => :spolicy,
|
|||
|
|
sclient => :sclient,
|
|||
|
|
stype => :stype);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
///////////////// search
|
|||
|
|
|
|||
|
|
|
|||
|
|
select t.processid ,t.enddate ,t.outcome ,t.approvers
|
|||
|
|
,t.textattribute1 ,t.textattribute2 ,t.textattribute3 ,t.numberattribute1
|
|||
|
|
from wftask t where t.taskid='62f54360-0065-45a8-8440-88888ed9c54d'
|
|||
|
|
|
|||
|
|
|
|||
|
|
|