751: wsh_new_del_interface_s.nextval,
752: 'N',
753: 'OP',
754: sysdate,
755: FND_GLOBAL.USER_ID,
756: sysdate,
757: FND_GLOBAL.USER_ID,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
753: 'OP',
754: sysdate,
755: FND_GLOBAL.USER_ID,
756: sysdate,
757: FND_GLOBAL.USER_ID,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
760: FND_GLOBAL.Conc_Program_Id,
761: sysdate,
754: sysdate,
755: FND_GLOBAL.USER_ID,
756: sysdate,
757: FND_GLOBAL.USER_ID,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
760: FND_GLOBAL.Conc_Program_Id,
761: sysdate,
762: FND_GLOBAL.Conc_Request_Id,
755: FND_GLOBAL.USER_ID,
756: sysdate,
757: FND_GLOBAL.USER_ID,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
760: FND_GLOBAL.Conc_Program_Id,
761: sysdate,
762: FND_GLOBAL.Conc_Request_Id,
763: 'I',
756: sysdate,
757: FND_GLOBAL.USER_ID,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
760: FND_GLOBAL.Conc_Program_Id,
761: sysdate,
762: FND_GLOBAL.Conc_Request_Id,
763: 'I',
764: p_shipment_request_info.organization_code,
758: FND_GLOBAL.LOGIN_ID,
759: FND_GLOBAL.PROG_APPL_ID,
760: FND_GLOBAL.Conc_Program_Id,
761: sysdate,
762: FND_GLOBAL.Conc_Request_Id,
763: 'I',
764: p_shipment_request_info.organization_code,
765: p_shipment_request_info.CARRIER_CODE,
766: p_shipment_request_info.SERVICE_LEVEL,
886: wsh_del_details_interface_s.nextval,
887: 'OE',
888: -1,
889: sysdate,
890: FND_GLOBAL.USER_ID,
891: sysdate,
892: FND_GLOBAL.USER_ID,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
888: -1,
889: sysdate,
890: FND_GLOBAL.USER_ID,
891: sysdate,
892: FND_GLOBAL.USER_ID,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
895: FND_GLOBAL.Conc_Program_Id,
896: sysdate,
889: sysdate,
890: FND_GLOBAL.USER_ID,
891: sysdate,
892: FND_GLOBAL.USER_ID,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
895: FND_GLOBAL.Conc_Program_Id,
896: sysdate,
897: FND_GLOBAL.Conc_Request_Id,
890: FND_GLOBAL.USER_ID,
891: sysdate,
892: FND_GLOBAL.USER_ID,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
895: FND_GLOBAL.Conc_Program_Id,
896: sysdate,
897: FND_GLOBAL.Conc_Request_Id,
898: 'N',
891: sysdate,
892: FND_GLOBAL.USER_ID,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
895: FND_GLOBAL.Conc_Program_Id,
896: sysdate,
897: FND_GLOBAL.Conc_Request_Id,
898: 'N',
899: p_shipment_request_info.shipment_details_tab(i).date_requested,
893: FND_GLOBAL.LOGIN_ID,
894: FND_GLOBAL.PROG_APPL_ID,
895: FND_GLOBAL.Conc_Program_Id,
896: sysdate,
897: FND_GLOBAL.Conc_Request_Id,
898: 'N',
899: p_shipment_request_info.shipment_details_tab(i).date_requested,
900: p_shipment_request_info.shipment_details_tab(i).date_scheduled,
901: p_shipment_request_info.shipment_details_tab(i).inventory_item_id,
948: VALUES(
949: wsh_del_assgn_interface_s.nextval,
950: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id,
951: sysdate,
952: FND_GLOBAL.USER_ID,
953: sysdate,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
950: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id,
951: sysdate,
952: FND_GLOBAL.USER_ID,
953: sysdate,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
957: FND_GLOBAL.Conc_Program_Id,
958: sysdate,
951: sysdate,
952: FND_GLOBAL.USER_ID,
953: sysdate,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
957: FND_GLOBAL.Conc_Program_Id,
958: sysdate,
959: FND_GLOBAL.Conc_Request_Id,
952: FND_GLOBAL.USER_ID,
953: sysdate,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
957: FND_GLOBAL.Conc_Program_Id,
958: sysdate,
959: FND_GLOBAL.Conc_Request_Id,
960: p_shipment_request_info.delivery_interface_id,
953: sysdate,
954: FND_GLOBAL.USER_ID,
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
957: FND_GLOBAL.Conc_Program_Id,
958: sysdate,
959: FND_GLOBAL.Conc_Request_Id,
960: p_shipment_request_info.delivery_interface_id,
961: '94X_STANDALONE'
955: FND_GLOBAL.LOGIN_ID,
956: FND_GLOBAL.PROG_APPL_ID,
957: FND_GLOBAL.Conc_Program_Id,
958: sysdate,
959: FND_GLOBAL.Conc_Request_Id,
960: p_shipment_request_info.delivery_interface_id,
961: '94X_STANDALONE'
962: );
963:
1055: wsh_del_details_interface_s.nextval,
1056: 'OE',
1057: -1,
1058: sysdate,
1059: FND_GLOBAL.USER_ID,
1060: sysdate,
1061: FND_GLOBAL.USER_ID,
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1057: -1,
1058: sysdate,
1059: FND_GLOBAL.USER_ID,
1060: sysdate,
1061: FND_GLOBAL.USER_ID,
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1064: FND_GLOBAL.Conc_Program_Id,
1065: sysdate,
1058: sysdate,
1059: FND_GLOBAL.USER_ID,
1060: sysdate,
1061: FND_GLOBAL.USER_ID,
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1064: FND_GLOBAL.Conc_Program_Id,
1065: sysdate,
1066: FND_GLOBAL.Conc_Request_Id,
1059: FND_GLOBAL.USER_ID,
1060: sysdate,
1061: FND_GLOBAL.USER_ID,
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1064: FND_GLOBAL.Conc_Program_Id,
1065: sysdate,
1066: FND_GLOBAL.Conc_Request_Id,
1067: 'N',
1060: sysdate,
1061: FND_GLOBAL.USER_ID,
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1064: FND_GLOBAL.Conc_Program_Id,
1065: sysdate,
1066: FND_GLOBAL.Conc_Request_Id,
1067: 'N',
1068: --Bug8784331
1062: FND_GLOBAL.LOGIN_ID,
1063: FND_GLOBAL.PROG_APPL_ID,
1064: FND_GLOBAL.Conc_Program_Id,
1065: sysdate,
1066: FND_GLOBAL.Conc_Request_Id,
1067: 'N',
1068: --Bug8784331
1069: l_date_requested(i),
1070: l_date_scheduled(i),
1127: VALUES(
1128: wsh_del_assgn_interface_s.nextval,
1129: l_del_det_int_tab(i), --Bug8784331
1130: sysdate,
1131: FND_GLOBAL.USER_ID,
1132: sysdate,
1133: FND_GLOBAL.USER_ID,
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1129: l_del_det_int_tab(i), --Bug8784331
1130: sysdate,
1131: FND_GLOBAL.USER_ID,
1132: sysdate,
1133: FND_GLOBAL.USER_ID,
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1136: FND_GLOBAL.Conc_Program_Id,
1137: sysdate,
1130: sysdate,
1131: FND_GLOBAL.USER_ID,
1132: sysdate,
1133: FND_GLOBAL.USER_ID,
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1136: FND_GLOBAL.Conc_Program_Id,
1137: sysdate,
1138: FND_GLOBAL.Conc_Request_Id,
1131: FND_GLOBAL.USER_ID,
1132: sysdate,
1133: FND_GLOBAL.USER_ID,
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1136: FND_GLOBAL.Conc_Program_Id,
1137: sysdate,
1138: FND_GLOBAL.Conc_Request_Id,
1139: p_shipment_request_info.delivery_interface_id,
1132: sysdate,
1133: FND_GLOBAL.USER_ID,
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1136: FND_GLOBAL.Conc_Program_Id,
1137: sysdate,
1138: FND_GLOBAL.Conc_Request_Id,
1139: p_shipment_request_info.delivery_interface_id,
1140: '94X_STANDALONE'
1134: FND_GLOBAL.LOGIN_ID,
1135: FND_GLOBAL.PROG_APPL_ID,
1136: FND_GLOBAL.Conc_Program_Id,
1137: sysdate,
1138: FND_GLOBAL.Conc_Request_Id,
1139: p_shipment_request_info.delivery_interface_id,
1140: '94X_STANDALONE'
1141: );
1142: l_ins_rows := sql%rowcount;
1181: p_shipment_request_info.delivery_interface_id,
1182: 'DLVY_INT',
1183: -1,
1184: sysdate,
1185: FND_GLOBAL.USER_ID,
1186: sysdate,
1187: FND_GLOBAL.USER_ID,
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1183: -1,
1184: sysdate,
1185: FND_GLOBAL.USER_ID,
1186: sysdate,
1187: FND_GLOBAL.USER_ID,
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1190: FND_GLOBAL.Conc_Program_Id,
1191: sysdate,
1184: sysdate,
1185: FND_GLOBAL.USER_ID,
1186: sysdate,
1187: FND_GLOBAL.USER_ID,
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1190: FND_GLOBAL.Conc_Program_Id,
1191: sysdate,
1192: FND_GLOBAL.Conc_Request_Id,
1185: FND_GLOBAL.USER_ID,
1186: sysdate,
1187: FND_GLOBAL.USER_ID,
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1190: FND_GLOBAL.Conc_Program_Id,
1191: sysdate,
1192: FND_GLOBAL.Conc_Request_Id,
1193: p_shipment_request_info.document_revision )
1186: sysdate,
1187: FND_GLOBAL.USER_ID,
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1190: FND_GLOBAL.Conc_Program_Id,
1191: sysdate,
1192: FND_GLOBAL.Conc_Request_Id,
1193: p_shipment_request_info.document_revision )
1194: RETURNING TRANSACTION_ID INTO p_shipment_request_info.transaction_id;
1188: FND_GLOBAL.LOGIN_ID,
1189: FND_GLOBAL.PROG_APPL_ID,
1190: FND_GLOBAL.Conc_Program_Id,
1191: sysdate,
1192: FND_GLOBAL.Conc_Request_Id,
1193: p_shipment_request_info.document_revision )
1194: RETURNING TRANSACTION_ID INTO p_shipment_request_info.transaction_id;
1195: END IF;
1196:
1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');
1773: END IF;
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1779: program_id = FND_GLOBAL.Conc_Program_Id,
1780: program_update_date = sysdate,
1773: END IF;
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1779: program_id = FND_GLOBAL.Conc_Program_Id,
1780: program_update_date = sysdate,
1781: request_id = FND_GLOBAL.Conc_Request_Id,
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1779: program_id = FND_GLOBAL.Conc_Program_Id,
1780: program_update_date = sysdate,
1781: request_id = FND_GLOBAL.Conc_Request_Id,
1782: organization_code = p_shipment_request_info.organization_code,
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1779: program_id = FND_GLOBAL.Conc_Program_Id,
1780: program_update_date = sysdate,
1781: request_id = FND_GLOBAL.Conc_Request_Id,
1782: organization_code = p_shipment_request_info.organization_code,
1783: carrier_code = p_shipment_request_info.carrier_code,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1779: program_id = FND_GLOBAL.Conc_Program_Id,
1780: program_update_date = sysdate,
1781: request_id = FND_GLOBAL.Conc_Request_Id,
1782: organization_code = p_shipment_request_info.organization_code,
1783: carrier_code = p_shipment_request_info.carrier_code,
1784: service_level = p_shipment_request_info.service_level,
1785: mode_of_transport = p_shipment_request_info.mode_of_transport,
1854: END IF;
1855: --
1856: UPDATE WSH_DEL_DETAILS_INTERFACE
1857: SET last_update_date = sysdate,
1858: last_updated_by = FND_GLOBAL.USER_ID,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1861: program_id = FND_GLOBAL.Conc_Program_Id,
1862: program_update_date = sysdate,
1855: --
1856: UPDATE WSH_DEL_DETAILS_INTERFACE
1857: SET last_update_date = sysdate,
1858: last_updated_by = FND_GLOBAL.USER_ID,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1861: program_id = FND_GLOBAL.Conc_Program_Id,
1862: program_update_date = sysdate,
1863: request_id = FND_GLOBAL.Conc_Request_Id,
1856: UPDATE WSH_DEL_DETAILS_INTERFACE
1857: SET last_update_date = sysdate,
1858: last_updated_by = FND_GLOBAL.USER_ID,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1861: program_id = FND_GLOBAL.Conc_Program_Id,
1862: program_update_date = sysdate,
1863: request_id = FND_GLOBAL.Conc_Request_Id,
1864: date_requested = l_update_sr_info.shipment_details_tab(i).date_requested,
1857: SET last_update_date = sysdate,
1858: last_updated_by = FND_GLOBAL.USER_ID,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1861: program_id = FND_GLOBAL.Conc_Program_Id,
1862: program_update_date = sysdate,
1863: request_id = FND_GLOBAL.Conc_Request_Id,
1864: date_requested = l_update_sr_info.shipment_details_tab(i).date_requested,
1865: date_scheduled = l_update_sr_info.shipment_details_tab(i).date_scheduled,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1861: program_id = FND_GLOBAL.Conc_Program_Id,
1862: program_update_date = sysdate,
1863: request_id = FND_GLOBAL.Conc_Request_Id,
1864: date_requested = l_update_sr_info.shipment_details_tab(i).date_requested,
1865: date_scheduled = l_update_sr_info.shipment_details_tab(i).date_scheduled,
1866: inventory_item_id = l_update_sr_info.shipment_details_tab(i).inventory_item_id,
1867: item_number = l_update_sr_info.shipment_details_tab(i).item_number,
1935: --Bug8784331
1936: FORALL i in 1..l_update_sr_info.shipment_details_tab.count
1937: UPDATE WSH_DEL_DETAILS_INTERFACE
1938: SET last_update_date = sysdate,
1939: last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1942: program_id = FND_GLOBAL.Conc_Program_Id,
1943: program_update_date = sysdate,
1936: FORALL i in 1..l_update_sr_info.shipment_details_tab.count
1937: UPDATE WSH_DEL_DETAILS_INTERFACE
1938: SET last_update_date = sysdate,
1939: last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1942: program_id = FND_GLOBAL.Conc_Program_Id,
1943: program_update_date = sysdate,
1944: request_id = FND_GLOBAL.Conc_Request_Id,
1937: UPDATE WSH_DEL_DETAILS_INTERFACE
1938: SET last_update_date = sysdate,
1939: last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1942: program_id = FND_GLOBAL.Conc_Program_Id,
1943: program_update_date = sysdate,
1944: request_id = FND_GLOBAL.Conc_Request_Id,
1945: --Bug8784331
1938: SET last_update_date = sysdate,
1939: last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1942: program_id = FND_GLOBAL.Conc_Program_Id,
1943: program_update_date = sysdate,
1944: request_id = FND_GLOBAL.Conc_Request_Id,
1945: --Bug8784331
1946: date_requested = l_date_requested(i),
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1942: program_id = FND_GLOBAL.Conc_Program_Id,
1943: program_update_date = sysdate,
1944: request_id = FND_GLOBAL.Conc_Request_Id,
1945: --Bug8784331
1946: date_requested = l_date_requested(i),
1947: date_scheduled = l_date_scheduled(i) ,
1948: inventory_item_id = l_inventory_item_id(i),