APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_WRITEBACK_TRANSACTION

Line 119: spl_stmt ZPB_WRITEBACK_TRANSACTION.QDR%type;

115: resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%type;
116: zpb_user FND_USER.USER_NAME%type;
117: stmt_ln NUMBER;
118: cmd_str VARCHAR2(32767);
119: spl_stmt ZPB_WRITEBACK_TRANSACTION.QDR%type;
120: str_ptr NUMBER;
121: ctr NUMBER;
122: tsk_seq NUMBER;
123: delim varchar2(1);

Line 170: INSERT INTO zpb_writeback_transaction

166: ctr := ctr + 1;
167: str_ptr := instrb(cmd_str, delim);
168: exit when str_ptr = 0 or str_ptr is null;
169: spl_stmt := substrb(cmd_str, 0, str_ptr - 1);
170: INSERT INTO zpb_writeback_transaction
171: (task_seq, exec_order, qdr,
172: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
173: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
174: VALUES (tsk_seq, ctr, spl_stmt,

Line 185: INSERT INTO zpb_writeback_transaction

181: end loop;
182:
183: -- handles the condition when no delimiter is at the end of cmd_str
184: if cmd_str is not null then
185: INSERT INTO zpb_writeback_transaction
186: (task_seq, exec_order, qdr,
187: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
188: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
189: VALUES (tsk_seq, ctr, cmd_str,

Line 246: from zpb_writeback_tasks a, zpb_writeback_transaction b

242:
243: cursor tasks is
244: select a.task_seq taskseq, a.user_id asuser,
245: a.resp_id asresp, b.qdr type, b.exec_order exorder
246: from zpb_writeback_tasks a, zpb_writeback_transaction b
247: where b.task_seq = a.task_seq
248: and a.task_seq = P_TASK_SEQ
249: order by b.exec_order ASC;
250:

Line 300: delete * from zpb_writeback_transaction;

296: delete * from zpb_status_sql;
297: delete * from zpb_status_sql_lines;
298: delete * from zpb_task_parameters;
299: delete * from zpb_writeback_tasks;
300: delete * from zpb_writeback_transaction;
301:
302: null;
303: --
304: -- TODO: Delete from WF tables

Line 380: from zpb_writeback_transaction

376: where task_seq = P_TASK_SEQ;
377:
378: cursor tokens is
379: select qdr token, exec_order exorder
380: from zpb_writeback_transaction
381: where task_seq = P_TASK_SEQ
382: order by exec_order ASC;
383:
384: BEGIN

Line 490: from zpb_writeback_tasks a, zpb_writeback_transaction b

486: cursor tasks is
487: select a.task_seq taskseq, a.business_Area_id,
488: a.user_id asuser,
489: a.resp_id asresp, b.qdr token, b.exec_order exorder
490: from zpb_writeback_tasks a, zpb_writeback_transaction b
491: where b.task_seq = a.task_seq
492: and a.task_seq = P_TASK_SEQ
493: order by b.exec_order ASC;
494:

Line 505: zpb_writeback_transaction b

501: a.resp_id asresp,
502: b.qdr token,
503: b.exec_order exorder
504: FROM zpb_writeback_tasks a,
505: zpb_writeback_transaction b
506: WHERE b.task_seq = a.task_seq
507: AND a.session_id = p_conc_request_id
508: AND a.task_type = 'DO'
509: ORDER BY b.exec_order ASC;

Line 872: from zpb_writeback_tasks a, zpb_writeback_transaction b

868: cursor tasks is
869: select a.task_type tasktype, a.business_area_id,
870: a.task_seq taskseq, a.user_id asuser,
871: a.resp_id asresp, b.qdr qdr, b.exec_order exorder
872: from zpb_writeback_tasks a, zpb_writeback_transaction b
873: where b.task_seq = a.task_seq
874: and a.task_seq = P_TASK_SEQ
875: order by b.exec_order ASC;
876:

Line 999: zpb_writeback_transaction b

995: IS
996: SELECT DISTINCT b.qdr,
997: a.business_area_id
998: FROM zpb_writeback_tasks a,
999: zpb_writeback_transaction b
1000: WHERE b.task_seq = a.task_seq
1001: AND a.task_seq = p_task_seq
1002: AND a.task_type = 'UM';
1003: