71: v_cp_enabled := FALSE ;
72: i := 0;
73: v_item_count := 0;
74:
75: retrieval_cursor := 'DELETE FROM gmp_item_wps '
76: || ' WHERE plant_code = :p_plant_code ';
77: EXECUTE IMMEDIATE retrieval_cursor USING p_plant_code;
78: COMMIT;
79:
126:
127: OPEN c_item_cursor FOR retrieval_cursor USING p_plant_code;
128:
129: insert_statement :=
130: 'INSERT INTO gmp_item_wps '
131: || '( '
132: || ' item_no, item_id, item_um, uom_code,'
133: || ' lot_control, item_desc1, '
134: || ' aps_item_id, organization_id, whse_code, '
180: CLOSE c_item_cursor;
181:
182: SELECT count(*)
183: INTO v_item_count
184: FROM gmp_item_wps;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Number of Items Loaded Successfully are '||v_item_count);
187:
188: EXCEPTION