APPS.GMF_LOTCOSTADJUSTMENT_PUB dependencies on GMF_LOT_COST_ADJUSTMENT_DTLS

Line 964: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_dtl_id%TYPE;

960: l_text_cnt NUMBER;
961: l_header_cnt NUMBER;
962: l_detail_cnt NUMBER;
963: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.adjustment_id%TYPE;
964: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_dtl_id%TYPE;
965: l_adjustment_cost GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_cost%TYPE;
966: l_applied_ind GMF_LOT_COST_ADJUSTMENTS.applied_ind%TYPE;
967: l_cost_category_id NUMBER;
968: l_lot_costed_items_cnt NUMBER;

Line 965: l_adjustment_cost GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_cost%TYPE;

961: l_header_cnt NUMBER;
962: l_detail_cnt NUMBER;
963: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.adjustment_id%TYPE;
964: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_dtl_id%TYPE;
965: l_adjustment_cost GMF_LOT_COST_ADJUSTMENT_DTLS.adjustment_cost%TYPE;
966: l_applied_ind GMF_LOT_COST_ADJUSTMENTS.applied_ind%TYPE;
967: l_cost_category_id NUMBER;
968: l_lot_costed_items_cnt NUMBER;
969: --l_itemcost_class IC_ITEM_MST.itemcost_class%TYPE;

Line 1561: FROM gmf_lot_cost_adjustment_dtls

1557: THEN
1558: BEGIN
1559: SELECT 1
1560: INTO l_detail_cnt
1561: FROM gmf_lot_cost_adjustment_dtls
1562: WHERE adjustment_dtl_id = p_dtl_tbl(i).adjustment_dtl_id
1563: AND ROWNUM = 1;
1564: EXCEPTION
1565: WHEN NO_DATA_FOUND

Line 1720: FROM gmf_lot_cost_adjustment_dtls

1716: THEN
1717: BEGIN
1718: SELECT adjustment_dtl_id
1719: INTO p_dtl_tbl(i).adjustment_dtl_id
1720: FROM gmf_lot_cost_adjustment_dtls
1721: WHERE cost_cmpntcls_id = p_dtl_tbl(i).cost_cmpntcls_id
1722: AND cost_analysis_code = p_dtl_tbl(i).cost_analysis_code
1723: AND adjustment_id = p_header_rec.adjustment_id
1724: AND ROWNUM = 1;