DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on GL_INTERFACE

Line 734: lv_reference_10_desc gl_interface.reference10%type;

730:
731: /* Character Variable Declarations */
732: lv_reference_10_desc1 VARCHAR2(75);--File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
733: lv_reference_10_desc2 VARCHAR2(30);--File.Sql.35 Cbabu := ' For the Transaction Type ';
734: lv_reference_10_desc gl_interface.reference10%type;
735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';

Line 736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';

732: lv_reference_10_desc1 VARCHAR2(75);--File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
733: lv_reference_10_desc2 VARCHAR2(30);--File.Sql.35 Cbabu := ' For the Transaction Type ';
734: lv_reference_10_desc gl_interface.reference10%type;
735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';

Line 739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';

735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
741:
742: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
743: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;

Line 740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';

736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
741:
742: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
743: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;
744: ln_credit_amount number;

Line 859: p_destination => 'G', /*Indicates that GL Interface needs to be hit */

855: p_reference_23 => lv_reference23,
856: p_reference_24 => lv_reference24,
857: p_reference_25 => lv_reference25,
858: p_reference_26 => to_char(p_transaction_id),
859: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
860: p_simulate_flag => p_simulate,
861: p_codepath => p_codepath,
862: p_process_message => p_process_message,
863: p_process_status => p_process_status

Line 915: p_destination => 'G', /*Indicates that GL Interface needs to be hit */

911: p_reference_23 => lv_reference23,
912: p_reference_24 => lv_reference24,
913: p_reference_25 => lv_reference25,
914: p_reference_26 => to_char(p_transaction_id),
915: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
916: p_simulate_flag => p_simulate,
917: p_codepath => p_codepath,--lv_reference23, changed by zheng peng for bug 9457006
918: p_process_message => p_process_message,
919: p_process_status => p_process_status

Line 1496: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';

1492:
1493: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Expense Accounting';
1494: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1495: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1496: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1499: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1500: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';

Line 1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';

1493: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Expense Accounting';
1494: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1495: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1496: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1499: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1500: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1501: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';

Line 1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';

1494: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1495: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1496: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1499: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1500: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1501: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';
1502: lv_reference_10_desc gl_interface.reference10%type;

Line 1502: lv_reference_10_desc gl_interface.reference10%type;

1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1499: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1500: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1501: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';
1502: lv_reference_10_desc gl_interface.reference10%type;
1503:
1504: ln_credit_amount NUMBER;
1505: ln_debit_amount NUMBER;
1506: ln_expense_account mtl_secondary_inventories.expense_account%type;

Line 1595: p_destination => 'G', /*Indicates that GL Interface needs to be hit */

1591: p_reference_23 => lv_reference23,
1592: p_reference_24 => lv_reference24,
1593: p_reference_25 => lv_reference25,
1594: p_reference_26 => to_char(p_transaction_id),
1595: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
1596: p_simulate_flag => p_simulate,
1597: p_codepath => p_codepath,
1598: p_process_message => p_process_message,
1599: p_process_status => p_process_status

Line 1642: p_destination => 'G', /*Indicates that GL Interface needs to be hit */

1638: p_reference_23 => lv_reference23,
1639: p_reference_24 => lv_reference24,
1640: p_reference_25 => lv_reference25,
1641: p_reference_26 => to_char(p_transaction_id),
1642: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
1643: p_simulate_flag => p_simulate,
1644: p_codepath => p_codepath,
1645: p_process_message => p_process_message,
1646: p_process_status => p_process_status

Line 1931: lv_reference_10_desc gl_interface.reference10%type;--rchandan for bug#4473022

1927:
1928: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1929: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1930: lv_reference_10_desc2 VARCHAR2(30); --rchandan for bug#4473022
1931: lv_reference_10_desc gl_interface.reference10%type;--rchandan for bug#4473022
1932:
1933: BEGIN
1934:
1935: lv_source := 'Inventory India';