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 270: FROM ps_matl_dtl

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

Line 407: INSERT INTO ps_matl_dtl

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

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

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

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

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

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

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

Line 1168: FROM ps_matl_dtl

1164: CLOSE Cur_check_hdr;
1165:
1166: IF (V_matl_rep_id IS NOT NULL) THEN
1167: DELETE
1168: FROM ps_matl_dtl
1169: WHERE matl_rep_id = V_matl_rep_id
1170: AND item_id = V_item_id;
1171: END IF;
1172: IF (INSTR(V_org_list,',') <> 0) THEN

Line 1325: INSERT INTO ps_matl_dtl

1321: X_net_ss_reqmt := ROUND(NVL(V_total_ss,0) - X_ending_bal,9);
1322: END IF;
1323: X_prev_balance := X_ending_bal;
1324:
1325: INSERT INTO ps_matl_dtl
1326: (MATL_REP_ID,
1327: /* nsinghi MPSCONV Start */
1328: -- ITEM_ID,
1329: INVENTORY_ITEM_ID,