eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_WRITEBACK_TASKS

Line 60: -- L_REMOVE_OLD_RECORDS - Procedure that updates ZPB_WRITEBACK_TASKS after

56: 'PROC', p_qdr);
57: END l_log_user;
58:
59: ------------------------------------------------------------------------------
60: -- L_REMOVE_OLD_RECORDS - Procedure that updates ZPB_WRITEBACK_TASKS after
61: -- a CR has been run
62: --
63: ------------------------------------------------------------------------------
64: PROCEDURE l_remove_old_records

Line 84: from ZPB_WRITEBACK_TASKS

80: num_of_days := to_number(prof_num_of_days);
81: end if;
82:
83: select count(*) into rcd_ct
84: from ZPB_WRITEBACK_TASKS
85: where (status = COMPLETED or status = FAILED)
86: and completion_date <= (SYSDATE - num_of_days);
87:
88: if rcd_ct > 0 then

Line 93: delete from ZPB_WRITEBACK_TASKS

89: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_remove_old_records',
90: 'ZPB_WRITEMGR_CLEANUP',
91: 'DATE', (SYSDATE - (num_of_days - 1)));
92:
93: delete from ZPB_WRITEBACK_TASKS
94: where (status = COMPLETED or status = FAILED)
95: and completion_date <= (SYSDATE - num_of_days);
96: end if;
97: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','End program :');

Line 150: INSERT INTO zpb_writeback_tasks (task_type, business_area_id, user_id,

146: where req_task_type = P_TASK_TYPE;
147:
148: select zpb_writeback_seq.nextval into tsk_seq from dual;
149:
150: INSERT INTO zpb_writeback_tasks (task_type, business_area_id, user_id,
151: session_id, task_seq, status, resp_id,
152: submit_date,
153: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
154: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

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 269: update zpb_writeback_tasks set

265: l_log_user (last_task, each.asuser, each.asresp,
266: each.exorder, each.type);
267:
268: --set the status to failed
269: update zpb_writeback_tasks set
270: status = FAILED, completion_date = SYSDATE,
271: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
272: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
273: where task_seq = each.taskseq;

Line 299: delete * from zpb_writeback_tasks;

295: delete * from zpb_solve_output_levels;
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: --

Line 325: update zpb_writeback_tasks set

321: l_detach_aws (l_aws, true);
322: aw_attached := FALSE;
323:
324: --update the tasks table
325: update zpb_writeback_tasks set
326: status = COMPLETED, completion_date = SYSDATE,
327: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
328: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
329: where task_seq = last_task;

Line 375: from zpb_writeback_tasks

371:
372: cursor tasks is
373: select task_seq taskseq, business_Area_id,
374: user_id asuser, resp_id asresp
375: from zpb_writeback_tasks
376: where task_seq = P_TASK_SEQ;
377:
378: cursor tokens is
379: select qdr token, exec_order exorder

Line 391: update zpb_writeback_tasks set

387:
388: for v_task in tasks loop
389:
390: --set the initial status to failed
391: update zpb_writeback_tasks set
392: status = FAILED, completion_date = SYSDATE,
393: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
394: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
395: where task_seq = v_task.taskseq;

Line 420: update zpb_writeback_tasks set

416: -- zpb_aw.execute(l_spl);
417: -- end of bug 5007057
418:
419: --update the tasks table
420: update zpb_writeback_tasks set
421: status = COMPLETED, completion_date = SYSDATE,
422: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
423: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
424: where task_seq = v_task.taskseq;

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 504: FROM zpb_writeback_tasks a,

500: a.user_id asuser,
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'

Line 533: update zpb_writeback_tasks set

529:
530: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
531: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
532: --set the initial status to failed
533: update zpb_writeback_tasks set
534: status = FAILED, completion_date = SYSDATE,
535: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
536: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
537: where task_seq = task;

Line 640: update zpb_writeback_tasks set

636:
637: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
638: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
639: --set the initial status to failed
640: update zpb_writeback_tasks set
641: status = FAILED, completion_date = SYSDATE,
642: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
643: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
644: where task_seq = task;

Line 699: UPDATE zpb_writeback_tasks

695:
696: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
697: 'Updating writeback_tasks table with Status as COMPLETED for SessionID: '||p_conc_request_id );
698:
699: UPDATE zpb_writeback_tasks
700: SET status = COMPLETED,
701: completion_date = SYSDATE,
702: last_updated_by = fnd_global.user_id,
703: last_update_date = SYSDATE,

Line 712: UPDATE zpb_writeback_tasks

708:
709: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
710: 'Updating writeback_tasks table with Status as COMPLETED for Task Seq: '||task );
711:
712: UPDATE zpb_writeback_tasks
713: SET status = COMPLETED,
714: completion_date = SYSDATE,
715: last_updated_by = fnd_global.user_id,
716: last_update_date = SYSDATE,

Line 866: l_task_type zpb_writeback_tasks.task_type%TYPE;

862: x_has_read_acc number;
863: x_msg_data varchar2(4000);
864: l_api_version NUMBER := 1.0;
865: l_request_id NUMBER;
866: l_task_type zpb_writeback_tasks.task_type%TYPE;
867:
868: cursor tasks is
869: select a.task_type tasktype, a.business_area_id,
870: a.task_seq taskseq, a.user_id asuser,

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 898: update zpb_writeback_tasks set

894: l_log_user (last_task, each.asuser, each.asresp,
895: each.exorder, each.qdr);
896:
897: --set the status to failed
898: update zpb_writeback_tasks set
899: status = FAILED, completion_date = SYSDATE,
900: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
901: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
902: where task_seq = each.taskseq;

Line 941: update zpb_writeback_tasks set

937:
938: ZPB_AW.DETACH_ALL;
939:
940: --update the tasks table
941: update zpb_writeback_tasks set
942: status = COMPLETED, completion_date = SYSDATE,
943: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
944: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
945: where task_seq = last_task;

Line 998: FROM zpb_writeback_tasks a,

994: CURSOR users_csr
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';