[Home] [Help]
112: CURSOR get_dist_inst
113: IS
114: SELECT DISTINCT item_instance_id, serial_number, item_number,
115: inventory_item_id, location, status, owner, condition
116: FROM ahl_mr_instances_temp;
117: --get all item instances from the global temporary table
118: CURSOR get_all_inst
119: IS
120: SELECT mr_effectivity_id, item_instance_id, serial_number, item_number,
118: CURSOR get_all_inst
119: IS
120: SELECT mr_effectivity_id, item_instance_id, serial_number, item_number,
121: inventory_item_id, location, status, owner, condition
122: FROM ahl_mr_instances_temp;
123: --get distinct item instances from the global temporary table and sort them.
124: CURSOR get_dist_sort_inst
125: IS
126: SELECT DISTINCT item_instance_id, serial_number, item_number,
124: CURSOR get_dist_sort_inst
125: IS
126: SELECT DISTINCT item_instance_id, serial_number, item_number,
127: inventory_item_id, location, status, owner, condition
128: FROM ahl_mr_instances_temp
129: ORDER BY item_number, serial_number;
130: --get unit_name and uc_header_id for an item instance
131: /*
132: CURSOR get_uc_header(c_instance_id NUMBER) IS
694: END IF;
695: -- Check whether the mr_header_id exists --
696: AHL_DEBUG_PUB.debug(' Phase 1');
697:
698: DELETE FROM ahl_mr_instances_temp;
699: DELETE FROM ahl_applicable_instances;
700:
701: OPEN check_mr_exists(p_mr_header_id);
702: FETCH check_mr_exists INTO l_mr_header_id;
867: --DBMS_OUTPUT.put_line('PL/SQL table count= '||x_mr_item_inst_tbl.COUNT||' and last= '||x_mr_item_inst_tbl.LAST);
868: IF x_mr_item_inst_tbl.COUNT > 0 THEN
869: FOR i IN x_mr_item_inst_tbl.FIRST..x_mr_item_inst_tbl.LAST LOOP
870: IF x_mr_item_inst_tbl.EXISTS(i) THEN
871: INSERT INTO ahl_mr_instances_temp
872: (
873: MR_INSTANCE_TEMP_ID,
874: MR_EFFECTIVITY_ID,
875: ITEM_INSTANCE_ID,