[Home] [Help]
152: CURSOR get_dist_inst
153: IS
154: SELECT DISTINCT item_instance_id, serial_number, item_number,
155: inventory_item_id, location, status, owner, condition,unit_name,uc_header_id -- JKJain, NR Analysis and Forecasting
156: FROM ahl_mr_instances_temp;
157: --get all item instances from the global temporary table
158: CURSOR get_all_inst
159: IS
160: SELECT mr_effectivity_id, item_instance_id, serial_number, item_number,
158: CURSOR get_all_inst
159: IS
160: SELECT mr_effectivity_id, item_instance_id, serial_number, item_number,
161: inventory_item_id, location, status, owner, condition,unit_name,uc_header_id -- JKJain, NR Analysis and Forecasting
162: FROM ahl_mr_instances_temp;
163: --get distinct item instances from the global temporary table and sort them.
164: CURSOR get_dist_sort_inst
165: IS
166: SELECT DISTINCT item_instance_id, serial_number, item_number,
164: CURSOR get_dist_sort_inst
165: IS
166: SELECT DISTINCT item_instance_id, serial_number, item_number,
167: inventory_item_id, location, status, owner, condition,unit_name,uc_header_id -- JKJain, NR Analysis and Forecasting
168: FROM ahl_mr_instances_temp
169: ORDER BY item_number, serial_number;
170: --get unit_name and uc_header_id for an item instance
171: /*
172: CURSOR get_uc_header(c_instance_id NUMBER) IS
786: END IF;
787: -- Check whether the mr_header_id exists --
788: AHL_DEBUG_PUB.debug(' Phase 1');
789:
790: DELETE FROM ahl_mr_instances_temp;
791: DELETE FROM ahl_applicable_instances;
792:
793: OPEN check_mr_exists(p_mr_header_id);
794: FETCH check_mr_exists INTO l_mr_header_id;
1031: --DBMS_OUTPUT.put_line('PL/SQL table count= '||x_mr_item_inst_tbl.COUNT||' and last= '||x_mr_item_inst_tbl.LAST);
1032: IF x_mr_item_inst_tbl.COUNT > 0 THEN
1033: FOR i IN x_mr_item_inst_tbl.FIRST..x_mr_item_inst_tbl.LAST LOOP
1034: IF x_mr_item_inst_tbl.EXISTS(i) THEN
1035: INSERT INTO ahl_mr_instances_temp
1036: (
1037: MR_INSTANCE_TEMP_ID,
1038: MR_EFFECTIVITY_ID,
1039: ITEM_INSTANCE_ID,