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.

[Home] [Help]

APPS.ZPB_AW_WRITE_BACK dependencies on FND_GLOBAL

Line 133: l_conc_request_id := fnd_global.conc_request_id;

129:
130: ZPB_ERROR_HANDLER.INITIALIZE;
131:
132: -- Added for Bug: 5475982
133: l_conc_request_id := fnd_global.conc_request_id;
134:
135: SELECT distinct(responsibility_name) into resp_name
136: FROM FND_RESPONSIBILITY_VL
137: WHERE responsibility_id = P_RESP_ID;

Line 158: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,

154: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
155: VALUES (P_TASK_TYPE, p_business_area_id, zpb_user,
156: P_SESSION_ID, tsk_seq,
157: PENDING, resp_name, P_START_TIME,
158: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
159: SYSDATE, fnd_global.LOGIN_ID);
160:
161: cmd_str := P_SPL;
162: stmt_ln := lengthb(cmd_str);

Line 159: SYSDATE, fnd_global.LOGIN_ID);

155: VALUES (P_TASK_TYPE, p_business_area_id, zpb_user,
156: P_SESSION_ID, tsk_seq,
157: PENDING, resp_name, P_START_TIME,
158: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
159: SYSDATE, fnd_global.LOGIN_ID);
160:
161: cmd_str := P_SPL;
162: stmt_ln := lengthb(cmd_str);
163: ctr := 0;

Line 175: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,

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,
175: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
176: SYSDATE, fnd_global.LOGIN_ID);
177:
178: cmd_str := substrb(cmd_str, (str_ptr - stmt_ln),
179: (stmt_ln - str_ptr));

Line 176: SYSDATE, fnd_global.LOGIN_ID);

172: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
173: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
174: VALUES (tsk_seq, ctr, spl_stmt,
175: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
176: SYSDATE, fnd_global.LOGIN_ID);
177:
178: cmd_str := substrb(cmd_str, (str_ptr - stmt_ln),
179: (stmt_ln - str_ptr));
180: stmt_ln := lengthb(cmd_str);

Line 190: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,

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,
190: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
191: SYSDATE, fnd_global.LOGIN_ID);
192: end if;
193:
194: -- Fix for Bug: 5475982

Line 191: SYSDATE, fnd_global.LOGIN_ID);

187: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
188: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
189: VALUES (tsk_seq, ctr, cmd_str,
190: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
191: SYSDATE, fnd_global.LOGIN_ID);
192: end if;
193:
194: -- Fix for Bug: 5475982
195: -- If this procedure is invoked from an interactive UI session or

Line 271: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
274:
275: if (each.type = 'FULL') then

Line 272: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
274:
275: if (each.type = 'FULL') then
276: /*

Line 327: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
330:
331: else

Line 328: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
330:
331: else
332: --log no tasks found

Line 393: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
396:
397: if (not l_initialized) then

Line 394: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
396:
397: if (not l_initialized) then
398: INITIALIZE (v_task.asuser,

Line 422: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
425:
426: end loop;

Line 423: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
425:
426: end loop;
427:

Line 535: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
538:
539: if (v_task.exorder = 1) then

Line 536: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
538:
539: if (v_task.exorder = 1) then
540: s_user_id := v_task.token;

Line 642: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
645:
646: if (v_task.exorder = 1) then

Line 643: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
645:
646: if (v_task.exorder = 1) then
647: s_user_id := v_task.token;

Line 702: last_updated_by = fnd_global.user_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,
704: last_update_login = fnd_global.login_id
705: WHERE session_id = p_conc_request_id;
706:

Line 704: last_update_login = fnd_global.login_id

700: SET status = COMPLETED,
701: completion_date = SYSDATE,
702: last_updated_by = fnd_global.user_id,
703: last_update_date = SYSDATE,
704: last_update_login = fnd_global.login_id
705: WHERE session_id = p_conc_request_id;
706:
707: ELSE
708:

Line 715: last_updated_by = fnd_global.user_id,

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,
717: last_update_login = fnd_global.login_id
718: WHERE task_seq = task;
719:

Line 717: last_update_login = fnd_global.login_id

713: SET status = COMPLETED,
714: completion_date = SYSDATE,
715: last_updated_by = fnd_global.user_id,
716: last_update_date = SYSDATE,
717: last_update_login = fnd_global.login_id
718: WHERE task_seq = task;
719:
720: END IF;
721:

Line 769: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)

765: where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
766: p_business_area || '/ZPBSystem/Private/Manager/%ReadAccess%' and
767: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
768: not in(
769: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
770: from ZPB_VALIDATION_TEMP_DATA VTDATA
771: where VTDATA.business_area_id = p_business_area);
772:
773: cursor all_writeaccess is

Line 780: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)

776: where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
777: p_business_area || '/ZPBSystem/Private/Manager/%WriteAccess%' and
778: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
779: not in(
780: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
781: from ZPB_VALIDATION_TEMP_DATA VTDATA
782: where VTDATA.business_area_id = p_business_area);
783:
784: cursor all_ownership is

Line 791: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)

787: where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
788: p_business_area || '/ZPBSystem/Private/Manager/%Ownership%' and
789: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
790: not in(
791: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
792: from ZPB_VALIDATION_TEMP_DATA VTDATA
793: where VTDATA.business_area_id = p_business_area);
794:
795: begin

Line 799: where USER_ID = FND_GLOBAL.USER_ID;

795: begin
796: select USER_NAME
797: into l_user_name
798: from FND_USER
799: where USER_ID = FND_GLOBAL.USER_ID;
800:
801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');
802:
803: INITIALIZE (l_user_name,

Line 900: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
903:
904: ZPB_AW.EXECUTE(each.qdr);

Line 901: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
903:
904: ZPB_AW.EXECUTE(each.qdr);
905:

Line 943: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

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;
946:
947: --remove records timed by ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS profile

Line 944: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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;
946:
947: --remove records timed by ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS profile
948: l_remove_old_records;