[Home] [Help]
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
58: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
59: l_transaction_error_id NUMBER;
60: l_quantity NUMBER;
61: l_mfg_serial_flag VARCHAR2(1);
62: l_ins_number VARCHAR2(100);
86: r_id c_id%rowtype;
87:
88: cursor c_hz_loc (pc_location_id IN NUMBER) is
89: SELECT 1
90: FROM hz_locations
91: WHERE location_id = pc_location_id;
92:
93: cursor c_hr_loc (pc_location_id IN NUMBER) is
94: SELECT 1
202: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
203: fetch c_hz_loc into l_hz_location;
204:
205: IF l_hz_location IS NOT NULL THEN
206: l_location_type := 'HZ_LOCATIONS';
207: close c_hz_loc;
208: ELSE
209: close c_hz_loc;
210: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
563: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
564: l_new_dest_instance_rec.instance_usage_code := l_in_service;
565: l_new_dest_instance_rec.inv_locator_id := NULL;
566: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
567: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
568: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
569: l_new_dest_instance_rec.inv_organization_id := NULL;
570: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
571: l_new_dest_instance_rec.pa_project_id := NULL;
716: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
717: l_update_instance_rec.inv_locator_id := NULL;
718: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
719: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
720: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
721: l_update_instance_rec.pa_project_id := NULL;
722: l_update_instance_rec.pa_project_task_id := NULL;
723: l_update_instance_rec.instance_usage_code := l_in_service;
724: l_update_instance_rec.operational_status_code := 'IN_SERVICE';
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
928: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
929: l_transaction_error_id NUMBER;
930: l_quantity NUMBER;
931: l_mfg_serial_flag VARCHAR2(1);
932: l_ins_number VARCHAR2(100);
958: r_id c_id%rowtype;
959:
960: cursor c_hz_loc (pc_location_id IN NUMBER) is
961: SELECT 1
962: FROM hz_locations
963: WHERE location_id = pc_location_id;
964:
965: cursor c_hr_loc (pc_location_id IN NUMBER) is
966: SELECT 1
1087: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
1088: fetch c_hz_loc into l_hz_location;
1089:
1090: IF l_hz_location IS NOT NULL THEN
1091: l_location_type := 'HZ_LOCATIONS';
1092: close c_hz_loc;
1093: ELSE
1094: close c_hz_loc;
1095: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2249: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
2250: l_transaction_error_id NUMBER;
2251: l_quantity NUMBER;
2252: l_mfg_serial_flag VARCHAR2(1);
2253: l_ins_number VARCHAR2(100);
2277: r_id c_id%rowtype;
2278:
2279: cursor c_hz_loc (pc_location_id IN NUMBER) is
2280: SELECT 1
2281: FROM hz_locations
2282: WHERE location_id = pc_location_id;
2283:
2284: cursor c_hr_loc (pc_location_id IN NUMBER) is
2285: SELECT 1
2387: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
2388: fetch c_hz_loc into l_hz_location;
2389:
2390: IF l_hz_location IS NOT NULL THEN
2391: l_location_type := 'HZ_LOCATIONS';
2392: close c_hz_loc;
2393: ELSE
2394: close c_hz_loc;
2395: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
2749: l_new_dest_instance_rec.instance_usage_code := l_in_service;
2750: l_new_dest_instance_rec.inv_locator_id := NULL;
2751: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2752: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2753: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2754: l_new_dest_instance_rec.inv_organization_id := NULL;
2755: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2756: l_new_dest_instance_rec.pa_project_id := NULL;
2757: l_new_dest_instance_rec.pa_project_task_id := NULL;
2897: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2898: l_update_instance_rec.inv_locator_id := NULL;
2899: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2900: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2901: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2902: l_update_instance_rec.pa_project_id := NULL;
2903: l_update_instance_rec.pa_project_task_id := NULL;
2904: l_update_instance_rec.instance_usage_code := l_in_service;
2905: l_update_instance_rec.operational_status_code := 'IN_SERVICE';