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,
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
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;
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
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
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,
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
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;
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;
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:
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,
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
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;
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:
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');
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,
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
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;
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:
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: --
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: