APPS.PKG_GMP_BUCKET_DATA dependencies on PS_MATL_HDR

Line 47: FROM ps_matl_hdr

43: WHERE schedule_id = V_schedule
44: AND delete_mark = 0;
45: CURSOR Cur_check_hdr IS
46: SELECT matl_rep_id
47: FROM ps_matl_hdr
48: WHERE matl_rep_id = V_matl_rep_id;
49: CURSOR Cur_matl_rep_id IS
50: SELECT gem5_matl_rep_id_s.NEXTVAL
51: FROM dual;

Line 261: INSERT INTO ps_matl_hdr (matl_rep_id, item_id)

257: IF (Cur_check_hdr%NOTFOUND) THEN
258: OPEN Cur_matl_rep_id;
259: FETCH Cur_matl_rep_id INTO X_matl_rep_id;
260: CLOSE Cur_matl_rep_id;
261: INSERT INTO ps_matl_hdr (matl_rep_id, item_id)
262: VALUES (X_matl_rep_id, V_item_id);
263: ELSE
264: X_matl_rep_id := V_matl_rep_id;
265: END IF;

Line 543: FROM ps_matl_hdr

539: WHERE schedule_id = V_schedule
540: AND delete_mark = 0;
541: CURSOR Cur_check_hdr IS
542: SELECT matl_rep_id
543: FROM ps_matl_hdr
544: WHERE matl_rep_id = V_matl_rep_id;
545: CURSOR Cur_matl_rep_id IS
546: SELECT gem5_matl_rep_id_s.NEXTVAL
547: FROM dual;

Line 1158: INSERT INTO ps_matl_hdr (matl_rep_id, inventory_item_id)

1154: Bucketed Material Form and NOT Report. I think this part of code
1155: will require to be removed. */
1156: /* nsinghi MPSCONV End */
1157: /*
1158: INSERT INTO ps_matl_hdr (matl_rep_id, inventory_item_id)
1159: VALUES (X_matl_rep_id, V_item_id);
1160: */
1161: ELSE
1162: X_matl_rep_id := V_matl_rep_id;