APPS.PKG_GMP_BUCKET_DATA dependencies on PS_MATL_DTL

Line 19: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE

15: TYPE trans_qty_type IS TABLE OF mr_tran_tbl.trans_qty%TYPE
16: INDEX BY BINARY_INTEGER;
17: TYPE orgn_code_type IS TABLE OF sy_orgn_mst.orgn_code%TYPE
18: INDEX BY BINARY_INTEGER;
19: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
20: INDEX BY BINARY_INTEGER;
21: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE

Line 21: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE

17: TYPE orgn_code_type IS TABLE OF sy_orgn_mst.orgn_code%TYPE
18: INDEX BY BINARY_INTEGER;
19: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
20: INDEX BY BINARY_INTEGER;
21: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE
24: INDEX BY BINARY_INTEGER;
25: trans_date_tab TRANS_DATE_TYPE;

Line 23: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE

19: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
20: INDEX BY BINARY_INTEGER;
21: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE
24: INDEX BY BINARY_INTEGER;
25: trans_date_tab TRANS_DATE_TYPE;
26: doc_type_tab DOCUMENT_TYPE;
27: trans_qty_tab TRANS_QTY_TYPE;

Line 272: FROM ps_matl_dtl

268: CLOSE Cur_check_hdr;
269:
270: IF (V_matl_rep_id IS NOT NULL) THEN
271: DELETE
272: FROM ps_matl_dtl
273: WHERE matl_rep_id = V_matl_rep_id
274: AND item_id = V_item_id;
275: END IF;
276:

Line 409: INSERT INTO ps_matl_dtl

405: X_net_ss_reqmt := ROUND(NVL(V_total_ss,0) - X_ending_bal,9);
406: END IF;
407: X_prev_balance := X_ending_bal;
408:
409: INSERT INTO ps_matl_dtl
410: (MATL_REP_ID,
411: ITEM_ID,
412: WHSE_CODE,
413: QTY_ON_HAND,

Line 490: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE

486: TYPE whse_code_type IS TABLE OF ic_whse_mst.whse_code%TYPE
487: INDEX BY BINARY_INTEGER;
488: TYPE organization_id_type IS TABLE OF hr_organization_units.organization_id%TYPE -- akaruppa added **
489: INDEX BY BINARY_INTEGER;
490: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
491: INDEX BY BINARY_INTEGER;
492: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
493: INDEX BY BINARY_INTEGER;
494: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE

Line 492: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE

488: TYPE organization_id_type IS TABLE OF hr_organization_units.organization_id%TYPE -- akaruppa added **
489: INDEX BY BINARY_INTEGER;
490: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
491: INDEX BY BINARY_INTEGER;
492: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
493: INDEX BY BINARY_INTEGER;
494: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE
495: INDEX BY BINARY_INTEGER;
496: trans_date_tab TRANS_DATE_TYPE;

Line 494: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE

490: TYPE period_start_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
491: INDEX BY BINARY_INTEGER;
492: TYPE period_end_date_type IS TABLE OF ps_matl_dtl.perd_end_date%TYPE
493: INDEX BY BINARY_INTEGER;
494: TYPE period_name_type IS TABLE OF ps_matl_dtl.perd_name%TYPE
495: INDEX BY BINARY_INTEGER;
496: trans_date_tab TRANS_DATE_TYPE;
497: doc_type_tab DOCUMENT_TYPE;
498: trans_qty_tab TRANS_QTY_TYPE;

Line 1174: FROM ps_matl_dtl

1170: CLOSE Cur_check_hdr;
1171:
1172: IF (V_matl_rep_id IS NOT NULL) THEN
1173: DELETE
1174: FROM ps_matl_dtl
1175: WHERE matl_rep_id = V_matl_rep_id
1176: AND item_id = V_item_id;
1177: END IF;
1178: IF (INSTR(V_org_list,',') <> 0) THEN

Line 1331: INSERT INTO ps_matl_dtl

1327: X_net_ss_reqmt := ROUND(NVL(V_total_ss,0) - X_ending_bal,9);
1328: END IF;
1329: X_prev_balance := X_ending_bal;
1330:
1331: INSERT INTO ps_matl_dtl
1332: (MATL_REP_ID,
1333: /* nsinghi MPSCONV Start */
1334: -- ITEM_ID,
1335: INVENTORY_ITEM_ID,