DBA Data[Home] [Help]

APPS.POS_CHANGE_PROM_DATES dependencies on FND_GLOBAL

Line 597: last_updated_by = fnd_global.user_id,

593: authorization_status = 'IN PROCESS',
594: revision_num = revision_num + 1,
595: revised_date = sysdate,
596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = fnd_global.conc_request_id,
600: program_application_id = fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,

Line 598: last_update_login = fnd_global.login_id,

594: revision_num = revision_num + 1,
595: revised_date = sysdate,
596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = fnd_global.conc_request_id,
600: program_application_id = fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate

Line 599: request_id = fnd_global.conc_request_id,

595: revised_date = sysdate,
596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = fnd_global.conc_request_id,
600: program_application_id = fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where po_header_id = document_id;

Line 600: program_application_id = fnd_global.prog_appl_id,

596: last_update_date = sysdate,
597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = fnd_global.conc_request_id,
600: program_application_id = fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where po_header_id = document_id;
604: else

Line 601: program_id = fnd_global.conc_program_id,

597: last_updated_by = fnd_global.user_id,
598: last_update_login = fnd_global.login_id,
599: request_id = fnd_global.conc_request_id,
600: program_application_id = fnd_global.prog_appl_id,
601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where po_header_id = document_id;
604: else
605: update po_releases_all set

Line 610: last_updated_by = fnd_global.user_id,

606: authorization_status = 'IN PROCESS',
607: revision_num = revision_num + 1,
608: revised_date = sysdate,
609: last_update_date = sysdate,
610: last_updated_by = fnd_global.user_id,
611: last_update_login = fnd_global.login_id,
612: request_id = fnd_global.conc_request_id,
613: program_application_id = fnd_global.prog_appl_id,
614: program_id = fnd_global.conc_program_id,

Line 611: last_update_login = fnd_global.login_id,

607: revision_num = revision_num + 1,
608: revised_date = sysdate,
609: last_update_date = sysdate,
610: last_updated_by = fnd_global.user_id,
611: last_update_login = fnd_global.login_id,
612: request_id = fnd_global.conc_request_id,
613: program_application_id = fnd_global.prog_appl_id,
614: program_id = fnd_global.conc_program_id,
615: program_update_date = sysdate

Line 612: request_id = fnd_global.conc_request_id,

608: revised_date = sysdate,
609: last_update_date = sysdate,
610: last_updated_by = fnd_global.user_id,
611: last_update_login = fnd_global.login_id,
612: request_id = fnd_global.conc_request_id,
613: program_application_id = fnd_global.prog_appl_id,
614: program_id = fnd_global.conc_program_id,
615: program_update_date = sysdate
616: where po_release_id = document_id;

Line 613: program_application_id = fnd_global.prog_appl_id,

609: last_update_date = sysdate,
610: last_updated_by = fnd_global.user_id,
611: last_update_login = fnd_global.login_id,
612: request_id = fnd_global.conc_request_id,
613: program_application_id = fnd_global.prog_appl_id,
614: program_id = fnd_global.conc_program_id,
615: program_update_date = sysdate
616: where po_release_id = document_id;
617: end if;

Line 614: program_id = fnd_global.conc_program_id,

610: last_updated_by = fnd_global.user_id,
611: last_update_login = fnd_global.login_id,
612: request_id = fnd_global.conc_request_id,
613: program_application_id = fnd_global.prog_appl_id,
614: program_id = fnd_global.conc_program_id,
615: program_update_date = sysdate
616: where po_release_id = document_id;
617: end if;
618:

Line 1200: last_updated_by = fnd_global.user_id,

1196:
1197: UPDATE po_line_locations_all
1198: SET promised_date = x_new_date,
1199: last_update_date = sysdate,
1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,
1202: request_id = fnd_global.conc_request_id,
1203: program_application_id = fnd_global.prog_appl_id,
1204: program_id = fnd_global.conc_program_id,

Line 1201: last_update_login = fnd_global.login_id,

1197: UPDATE po_line_locations_all
1198: SET promised_date = x_new_date,
1199: last_update_date = sysdate,
1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,
1202: request_id = fnd_global.conc_request_id,
1203: program_application_id = fnd_global.prog_appl_id,
1204: program_id = fnd_global.conc_program_id,
1205: program_update_date = sysdate

Line 1202: request_id = fnd_global.conc_request_id,

1198: SET promised_date = x_new_date,
1199: last_update_date = sysdate,
1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,
1202: request_id = fnd_global.conc_request_id,
1203: program_application_id = fnd_global.prog_appl_id,
1204: program_id = fnd_global.conc_program_id,
1205: program_update_date = sysdate
1206: WHERE line_location_id = x_line_location_id;

Line 1203: program_application_id = fnd_global.prog_appl_id,

1199: last_update_date = sysdate,
1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,
1202: request_id = fnd_global.conc_request_id,
1203: program_application_id = fnd_global.prog_appl_id,
1204: program_id = fnd_global.conc_program_id,
1205: program_update_date = sysdate
1206: WHERE line_location_id = x_line_location_id;
1207:

Line 1204: program_id = fnd_global.conc_program_id,

1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,
1202: request_id = fnd_global.conc_request_id,
1203: program_application_id = fnd_global.prog_appl_id,
1204: program_id = fnd_global.conc_program_id,
1205: program_update_date = sysdate
1206: WHERE line_location_id = x_line_location_id;
1207:
1208: -- dbms_output.put_line ('DONE updating date');

Line 1271: last_updated_by = fnd_global.user_id,

1267: UPDATE po_line_locations_all
1268: SET promised_date = x_new_promised_date,
1269: need_by_date = x_new_needby_date,
1270: last_update_date = sysdate,
1271: last_updated_by = fnd_global.user_id,
1272: last_update_login = fnd_global.login_id,
1273: request_id = fnd_global.conc_request_id,
1274: program_application_id = fnd_global.prog_appl_id,
1275: program_id = fnd_global.conc_program_id,

Line 1272: last_update_login = fnd_global.login_id,

1268: SET promised_date = x_new_promised_date,
1269: need_by_date = x_new_needby_date,
1270: last_update_date = sysdate,
1271: last_updated_by = fnd_global.user_id,
1272: last_update_login = fnd_global.login_id,
1273: request_id = fnd_global.conc_request_id,
1274: program_application_id = fnd_global.prog_appl_id,
1275: program_id = fnd_global.conc_program_id,
1276: program_update_date = sysdate

Line 1273: request_id = fnd_global.conc_request_id,

1269: need_by_date = x_new_needby_date,
1270: last_update_date = sysdate,
1271: last_updated_by = fnd_global.user_id,
1272: last_update_login = fnd_global.login_id,
1273: request_id = fnd_global.conc_request_id,
1274: program_application_id = fnd_global.prog_appl_id,
1275: program_id = fnd_global.conc_program_id,
1276: program_update_date = sysdate
1277: WHERE line_location_id = x_line_location_id;

Line 1274: program_application_id = fnd_global.prog_appl_id,

1270: last_update_date = sysdate,
1271: last_updated_by = fnd_global.user_id,
1272: last_update_login = fnd_global.login_id,
1273: request_id = fnd_global.conc_request_id,
1274: program_application_id = fnd_global.prog_appl_id,
1275: program_id = fnd_global.conc_program_id,
1276: program_update_date = sysdate
1277: WHERE line_location_id = x_line_location_id;
1278:

Line 1275: program_id = fnd_global.conc_program_id,

1271: last_updated_by = fnd_global.user_id,
1272: last_update_login = fnd_global.login_id,
1273: request_id = fnd_global.conc_request_id,
1274: program_application_id = fnd_global.prog_appl_id,
1275: program_id = fnd_global.conc_program_id,
1276: program_update_date = sysdate
1277: WHERE line_location_id = x_line_location_id;
1278:
1279: --

Line 1501: FND_GLOBAL.APPS_INITIALIZE(x_user_id,x_resp_id,x_resp_appl_id);

1497: when others then
1498: x_resp_id := -1;
1499: END;
1500:
1501: FND_GLOBAL.APPS_INITIALIZE(x_user_id,x_resp_id,x_resp_appl_id);
1502:
1503: END initialize;
1504:
1505: