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 263: INSERT INTO ps_matl_hdr (matl_rep_id, item_id)

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

Line 545: FROM ps_matl_hdr

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

Line 1164: INSERT INTO ps_matl_hdr (matl_rep_id, inventory_item_id)

1160: Bucketed Material Form and NOT Report. I think this part of code
1161: will require to be removed. */
1162: /* nsinghi MPSCONV End */
1163: /*
1164: INSERT INTO ps_matl_hdr (matl_rep_id, inventory_item_id)
1165: VALUES (X_matl_rep_id, V_item_id);
1166: */
1167: ELSE
1168: X_matl_rep_id := V_matl_rep_id;