APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on GMF_LC_ADJ_TRANSACTIONS

Line 1: PACKAGE BODY GMF_LC_ADJ_TRANSACTIONS_PKG AS

1: PACKAGE BODY GMF_LC_ADJ_TRANSACTIONS_PKG AS
2: /* $Header: GMFLCATB.pls 120.4.12020000.3 2012/09/14 07:03:38 guobxu ship $ */
3:
4: /* define the structure, can be used in global */
5: TYPE transaction_type IS RECORD (

Line 60: gmf_lc_adj_transactions table

56:
57: SYNOPSIS
58: Type : Private
59: Function : Validate LCM adjustments before inserting in
60: gmf_lc_adj_transactions table
61:
62: Pre-reqs : None
63: Parameters :
64: IN : p_le_id IN NUMBER

Line 722: in gmf_lc_adj_transactions table after validation

718:
719: SYNOPSIS
720: Type : Private
721: Function : Create landed cost adjustment transactions line
722: in gmf_lc_adj_transactions table after validation
723:
724: Pre-reqs : None
725: Parameters :
726: IN : p_le_id IN NUMBER

Line 734: Insert Landed cost adjustment transaction in gmf_lc_adj_transactions

730: OUT : x_return_status OUT NOCOPY VARCHAR2
731:
732:
733: DESCRIPTION
734: Insert Landed cost adjustment transaction in gmf_lc_adj_transactions
735: table
736: AUTHOR
737: LCM-OPM dev 04-Aug-2009, LCM-OPM Integration, bug
738:

Line 758: INSERT INTO gmf_lc_adj_transactions

754: IF l_debug_level >= l_debug_level_medium THEN
755: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||l_proc_name);
756: END IF;
757:
758: INSERT INTO gmf_lc_adj_transactions
759: (adj_transaction_id, -- 01
760: rcv_transaction_id, -- 02
761: event_type, -- 03
762: event_source, -- 04

Line 812: (gmf_lc_adj_transactions_s.NEXTVAL, -- 01

808: program_application_id, -- 49
809: program_id, -- 50
810: program_udpate_date) -- 51
811: VALUES
812: (gmf_lc_adj_transactions_s.NEXTVAL, -- 01
813: p_adjustment_row.rcv_transaction_id, -- 02
814: p_adjustment_row.event_type, -- 03
815: p_adjustment_row.event_source, -- 04
816: p_adjustment_row.event_source_id, -- 05

Line 987: AND NOT EXISTS (SELECT 1 FROM gmf_lc_adj_transactions lat

983: AND TRUNC(glah.transaction_date) >= TRUNC(NVL(cp_start_dt, glah.transaction_date))
984: AND TRUNC(glah.transaction_date) <= TRUNC(NVL(cp_end_dt, glah.transaction_date))
985: AND glah.component_type IN ('ITEM PRICE','CHARGE')
986: -- AND NVL(glah.new_landed_cost,0) - NVL(glah.prior_landed_cost,0) <> 0
987: AND NOT EXISTS (SELECT 1 FROM gmf_lc_adj_transactions lat
988: WHERE lat.adjustment_num = glah.adjustment_num
989: AND lat.ship_header_id = glah.ship_header_id
990: AND lat.ship_line_id = glah.ship_line_id
991: AND lat.rcv_transaction_id = glah.rcv_transaction_id

Line 1271: -- Insert Into GMF_LC_ADJ_TRANSACTIONS

1267: IF l_ret_status = 'S' THEN
1268: IF l_debug_level >= l_debug_level_medium THEN
1269: fnd_file.put_line(fnd_file.log,'Call Create_AdjTrxLines');
1270: END IF;
1271: -- Insert Into GMF_LC_ADJ_TRANSACTIONS
1272: Create_AdjTrxLines(p_le_id => p_le_id,
1273: p_ledger_id => l_ledger_id,
1274: p_adjustment_row => l_adjustment_row,
1275: x_return_status => l_return_status);

Line 1298: ' LC Adjustment(s) created in gmf_lc_adj_transactions table : '|| l_total_adj ||

1294: END LOOP;
1295:
1296: fnd_file.put_line(fnd_file.log, 'Landed Cost Adjustments Import Processor finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1297: fnd_file.put_line(fnd_file.log,' Total of LC Adjustment(s): ' || l_total_lines||
1298: ' LC Adjustment(s) created in gmf_lc_adj_transactions table : '|| l_total_adj ||
1299: ' LC Adjustment(s) with errors: '|| l_total_ln_error);
1300: COMMIT;
1301:
1302: IF l_debug_level >= l_debug_level_medium THEN

Line 1341: END GMF_LC_ADJ_TRANSACTIONS_PKG;

1337: l_tmp := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' in ' || l_proc_name);
1338:
1339: END Process_Lc_Adjustments;
1340:
1341: END GMF_LC_ADJ_TRANSACTIONS_PKG;