[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
203: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
204: fetch c_hz_loc into l_hz_location;
205:
206: IF l_hz_location IS NOT NULL THEN
207: l_location_type := 'HZ_LOCATIONS';
208: close c_hz_loc;
209: ELSE
210: close c_hz_loc;
211: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
564: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
565: l_new_dest_instance_rec.instance_usage_code := l_in_service;
566: l_new_dest_instance_rec.inv_locator_id := NULL;
567: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
568: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
569: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
570: l_new_dest_instance_rec.inv_organization_id := NULL;
571: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
572: l_new_dest_instance_rec.pa_project_id := NULL;
717: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
718: l_update_instance_rec.inv_locator_id := NULL;
719: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
720: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
721: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
722: l_update_instance_rec.pa_project_id := NULL;
723: l_update_instance_rec.pa_project_task_id := NULL;
724: l_update_instance_rec.instance_usage_code := l_in_service;
725: l_update_instance_rec.operational_status_code := 'IN_SERVICE';
925: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
926: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
927: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
928: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
929: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
930: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP'; --Added for bug 12536407
931: l_transaction_error_id NUMBER;
932: l_quantity NUMBER;
933: l_mfg_serial_flag VARCHAR2(1);
961: r_id c_id%rowtype;
962:
963: cursor c_hz_loc (pc_location_id IN NUMBER) is
964: SELECT 1
965: FROM hz_locations
966: WHERE location_id = pc_location_id;
967:
968: cursor c_hr_loc (pc_location_id IN NUMBER) is
969: SELECT 1
1091: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
1092: fetch c_hz_loc into l_hz_location;
1093:
1094: IF l_hz_location IS NOT NULL THEN
1095: l_location_type := 'HZ_LOCATIONS';
1096: close c_hz_loc;
1097: ELSE
1098: close c_hz_loc;
1099: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
2320: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2321: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2322: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2323: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2324: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
2325: l_transaction_error_id NUMBER;
2326: l_quantity NUMBER;
2327: l_mfg_serial_flag VARCHAR2(1);
2328: l_ins_number VARCHAR2(100);
2352: r_id c_id%rowtype;
2353:
2354: cursor c_hz_loc (pc_location_id IN NUMBER) is
2355: SELECT 1
2356: FROM hz_locations
2357: WHERE location_id = pc_location_id;
2358:
2359: cursor c_hr_loc (pc_location_id IN NUMBER) is
2360: SELECT 1
2463: open c_hz_loc (l_mtl_item_tbl(i).ship_to_location_id);
2464: fetch c_hz_loc into l_hz_location;
2465:
2466: IF l_hz_location IS NOT NULL THEN
2467: l_location_type := 'HZ_LOCATIONS';
2468: close c_hz_loc;
2469: ELSE
2470: close c_hz_loc;
2471: open c_hr_loc (l_mtl_item_tbl(i).ship_to_location_id);
2826: l_new_dest_instance_rec.instance_usage_code := l_in_service;
2827: l_new_dest_instance_rec.inv_locator_id := NULL;
2828: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2829: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2830: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2831: l_new_dest_instance_rec.inv_organization_id := NULL;
2832: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2833: l_new_dest_instance_rec.pa_project_id := NULL;
2834: l_new_dest_instance_rec.pa_project_task_id := NULL;
2974: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2975: l_update_instance_rec.inv_locator_id := NULL;
2976: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2977: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2978: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2979: l_update_instance_rec.pa_project_id := NULL;
2980: l_update_instance_rec.pa_project_task_id := NULL;
2981: l_update_instance_rec.instance_usage_code := l_in_service;
2982: l_update_instance_rec.operational_status_code := 'IN_SERVICE';