DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on GL_INTERFACE

Line 647: lv_reference_10_desc gl_interface.reference10%type;

643:
644: /* Character Variable Declarations */
645: lv_reference_10_desc1 VARCHAR2(75);--File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
646: lv_reference_10_desc2 VARCHAR2(30);--File.Sql.35 Cbabu := ' For the Transaction Type ';
647: lv_reference_10_desc gl_interface.reference10%type;
648: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
649: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
650: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
651: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';

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

645: lv_reference_10_desc1 VARCHAR2(75);--File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
646: lv_reference_10_desc2 VARCHAR2(30);--File.Sql.35 Cbabu := ' For the Transaction Type ';
647: lv_reference_10_desc gl_interface.reference10%type;
648: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
649: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
650: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
651: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
652: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
653: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';

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

648: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
649: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
650: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
651: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
652: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
653: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
654:
655: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
656: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;

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

649: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
650: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
651: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
652: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
653: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
654:
655: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
656: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;
657: ln_credit_amount number;

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

760: p_reference_23 => lv_reference23,
761: p_reference_24 => lv_reference24,
762: p_reference_25 => lv_reference25,
763: p_reference_26 => to_char(p_transaction_id),
764: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
765: p_simulate_flag => p_simulate,
766: p_codepath => p_codepath,
767: p_process_message => p_process_message,
768: p_process_status => p_process_status

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

816: p_reference_23 => lv_reference23,
817: p_reference_24 => lv_reference24,
818: p_reference_25 => lv_reference25,
819: p_reference_26 => to_char(p_transaction_id),
820: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
821: p_simulate_flag => p_simulate,
822: p_codepath => lv_reference23,
823: p_process_message => p_process_message,
824: p_process_status => p_process_status

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

1328:
1329: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Expense Accounting';
1330: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1331: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1332: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1333: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1334: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1335: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1336: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';

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

1329: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Expense Accounting';
1330: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1331: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1332: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1333: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1334: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1335: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1336: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1337: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';

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

1330: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1331: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1332: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1333: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1334: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1335: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1336: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1337: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';
1338: lv_reference_10_desc gl_interface.reference10%type;

Line 1338: lv_reference_10_desc gl_interface.reference10%type;

1334: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1335: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1336: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1337: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';
1338: lv_reference_10_desc gl_interface.reference10%type;
1339:
1340: ln_credit_amount NUMBER;
1341: ln_debit_amount NUMBER;
1342: ln_expense_account mtl_secondary_inventories.expense_account%type;

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

1427: p_reference_23 => lv_reference23,
1428: p_reference_24 => lv_reference24,
1429: p_reference_25 => lv_reference25,
1430: p_reference_26 => to_char(p_transaction_id),
1431: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
1432: p_simulate_flag => p_simulate,
1433: p_codepath => p_codepath,
1434: p_process_message => p_process_message,
1435: p_process_status => p_process_status

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

1474: p_reference_23 => lv_reference23,
1475: p_reference_24 => lv_reference24,
1476: p_reference_25 => lv_reference25,
1477: p_reference_26 => to_char(p_transaction_id),
1478: p_destination => 'G', /*Indicates that GL Interface needs to be hit */
1479: p_simulate_flag => p_simulate,
1480: p_codepath => p_codepath,
1481: p_process_message => p_process_message,
1482: p_process_status => p_process_status

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

1763:
1764: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1765: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1766: lv_reference_10_desc2 VARCHAR2(30); --rchandan for bug#4473022
1767: lv_reference_10_desc gl_interface.reference10%type;--rchandan for bug#4473022
1768:
1769: BEGIN
1770:
1771: lv_source := 'Inventory India';