APPS.GMF_LOT_COSTING_PUB dependencies on GMF_LC_LOT_COST_ADJS

Line 7816: cp_lot_number gmf_lc_lot_cost_adjs.lot_number%TYPE) IS

7812: l_new_lc NUMBER;
7813: procedure_name VARCHAR2(100);
7814:
7815: CURSOR cur_lca_count (cp_adj_transaction_id NUMBER,
7816: cp_lot_number gmf_lc_lot_cost_adjs.lot_number%TYPE) IS
7817: SELECT 1 FROM gmf_lc_lot_cost_adjs
7818: WHERE adj_transaction_id = cp_adj_transaction_id
7819: AND lot_number = cp_lot_number ;
7820:

Line 7817: SELECT 1 FROM gmf_lc_lot_cost_adjs

7813: procedure_name VARCHAR2(100);
7814:
7815: CURSOR cur_lca_count (cp_adj_transaction_id NUMBER,
7816: cp_lot_number gmf_lc_lot_cost_adjs.lot_number%TYPE) IS
7817: SELECT 1 FROM gmf_lc_lot_cost_adjs
7818: WHERE adj_transaction_id = cp_adj_transaction_id
7819: AND lot_number = cp_lot_number ;
7820:
7821: l_count NUMBER := 0;

Line 7977: UPDATE gmf_lc_lot_cost_adjs lca SET

7973:
7974: /* If LC lot cost adjustments exists update else insert adjustment record */
7975: IF l_count >0 THEN
7976:
7977: UPDATE gmf_lc_lot_cost_adjs lca SET
7978: lca.lot_costed_flag = l_final_run_flag
7979: , lca.last_update_date = sysdate
7980: , lca.last_updated_by = l_user_id
7981: , lca.last_update_login = l_user_id

Line 7990: INSERT INTO gmf_lc_lot_cost_adjs(

7986: lca.adj_transaction_id = l_adjustments_cursor(i).adj_transaction_id
7987: AND lca.lot_number = transaction_row.lot_number ;
7988:
7989: ELSE
7990: INSERT INTO gmf_lc_lot_cost_adjs(
7991: lc_adjustment_id, --01
7992: adj_transaction_id, --02
7993: adjustment_quantity, --03
7994: costed_quantity, --04

Line 10717: FROM gmf_lc_lot_cost_adjs gllca

10713: AND glat.component_type IN ('ITEM PRICE','CHARGE')
10714: AND glat.cost_acquisition_flag = 'I'
10715: AND (glat.lc_adjustment_flag = 1 OR glat.adjustment_num > 0) /* Load only actual lc adj */
10716: AND NOT EXISTS (SELECT 1
10717: FROM gmf_lc_lot_cost_adjs gllca
10718: WHERE gllca.adj_transaction_id = glat.adj_transaction_id
10719: AND gllca.cost_type_id = l_cost_type_id
10720: AND gllca.lot_number = mtln.lot_number -- Bug 13906192
10721: AND gllca.lot_costed_flag = 1)

Line 11098: FROM gmf_lc_lot_cost_adjs gllca

11094: AND glat.component_type IN ('ITEM PRICE','CHARGE')
11095: AND glat.cost_acquisition_flag = 'I'
11096: AND (glat.lc_adjustment_flag = 1 OR glat.adjustment_num > 0) /* Load only actual lc adj */
11097: AND NOT EXISTS (SELECT 1
11098: FROM gmf_lc_lot_cost_adjs gllca
11099: WHERE gllca.adj_transaction_id = glat.adj_transaction_id
11100: AND gllca.cost_type_id = l_cost_type_id
11101: AND gllca.lot_number = mtln.lot_number -- Bug 13906192
11102: AND gllca.lot_costed_flag = 1)