eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_RCV_DELIVER_RTR_PKG

Line 1: PACKAGE BODY jai_rcv_deliver_rtr_pkg AS

1: PACKAGE BODY jai_rcv_deliver_rtr_pkg AS
2: /* $Header: jai_rcv_del_rtr.plb 120.6.12010000.2 2008/11/20 11:15:22 mbremkum ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_deliver_rtr_pkg.sql
5: S.No dd/mm/yyyy Author and Details

Line 4: CHANGE HISTORY for FILENAME: jai_rcv_deliver_rtr_pkg.sql

1: PACKAGE BODY jai_rcv_deliver_rtr_pkg AS
2: /* $Header: jai_rcv_del_rtr.plb 120.6.12010000.2 2008/11/20 11:15:22 mbremkum ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_rcv_deliver_rtr_pkg.sql
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 26/07/2004 Nagaraj.s for Bug# 3496408, Version:115.0
8: This Package is coded for Corrections Enhancement to pass Deliver and RTR Entries.

Line 48: Modified the code in jai_rcv_deliver_rtr_pkg.opm_costing procedure to consider currency rate also which is passed as parameter to the procedure.

44: Modified an IF condition in include_cenvat_in_costing function to allow FGIN items in case of RMA Receipts.
45: Previously it is allowing for ISO receipts only incase of FGIN items which is wrong
46:
47: 8 17/03/2005 Vijay Shankar for Bug#4229164, FileVersion:115.7
48: Modified the code in jai_rcv_deliver_rtr_pkg.opm_costing procedure to consider currency rate also which is passed as parameter to the procedure.
49: - Added a new parameter p_currency_conversion_rate to jai_rcv_deliver_rtr_pkg.opm_costing procedure
50: - started passing the value to newly added parameter by fetching the value from JAI_RCV_TRANSACTIONS table
51:
52: 9 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.8

Line 49: - Added a new parameter p_currency_conversion_rate to jai_rcv_deliver_rtr_pkg.opm_costing procedure

45: Previously it is allowing for ISO receipts only incase of FGIN items which is wrong
46:
47: 8 17/03/2005 Vijay Shankar for Bug#4229164, FileVersion:115.7
48: Modified the code in jai_rcv_deliver_rtr_pkg.opm_costing procedure to consider currency rate also which is passed as parameter to the procedure.
49: - Added a new parameter p_currency_conversion_rate to jai_rcv_deliver_rtr_pkg.opm_costing procedure
50: - started passing the value to newly added parameter by fetching the value from JAI_RCV_TRANSACTIONS table
51:
52: 9 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.8
53: modified the procedures to support the functinoality of "VAT UNCLAIM" in similar lines to "CENVAT UNCLAIM".

Line 146: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';

142: r_dlry_trx c_trx%rowtype;
143:
144:
145: /* Variable Declarations */
146: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';
147: -- lv_register_type VARCHAR2(1); --Either A or C.
148: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;
149: lv_statement_id VARCHAR2(4);
150: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';

Line 172: lv_procedure_name := 'jai_rcv_deliver_rtr_pkg.process_transaction';

168:
169: lv_cenvat_costed_flag VARCHAR2(15);
170:
171: BEGIN
172: lv_procedure_name := 'jai_rcv_deliver_rtr_pkg.process_transaction';
173: lv_debug := jai_constants.yes;
174: ln_apportion_factor := 1; -- default value added by Vijay Shankar for Bug#4068823 for RECEIPTS DEPLUG
175: ln_modvat_amount := 0;
176: ln_non_modvat_amount := 0;

Line 182: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;

178: ln_total := 0;
179: ln_opm_total := 0;
180:
181: -- this is to identify the path in SQL TRACE file if any problem occured
182: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
183:
184: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
185:
186: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */

Line 184: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));

180:
181: -- this is to identify the path in SQL TRACE file if any problem occured
182: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
183:
184: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
185:
186: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
187:
188: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

Line 186: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */

182: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
183:
184: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
185:
186: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
187:
188: /* Fetch all the information from JAI_RCV_TRANSACTIONS */
189: OPEN c_trx(p_transaction_id);
190: FETCH c_trx INTO r_trx;

Line 582: OR (r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag

578: lv_cenvat_costed_flag := jai_constants.no;
579: END IF;
580:
581: IF r_trx.attribute1 IS NULL
582: OR (r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag
583: AND nvl(r_trx.attribute1,jai_constants.no) <> jai_constants.yes)
584: THEN
585:
586: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);

Line 589: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,

585:
586: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);
587: jai_rcv_transactions_pkg.update_attributes(
588: p_transaction_id => p_transaction_id,
589: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,
590: p_attribute2 => lv_cenvat_costed_flag
591: );
592: END IF;
593:

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 665: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';

661: --File.Sql.35 Cbabu
662: lv_account_nature := 'Individual Tax';
663: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
664: lv_reference_10_desc2 := ' For the Transaction Type ';
665: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
666: lv_source := 'Purchasing India';
667: lv_category := 'Receiving India';
668: lv_reference24 := 'rcv_transactions';
669: lv_reference25 := 'transaction_id';

Line 673: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise', 'START'); /* 1 */

669: lv_reference25 := 'transaction_id';
670: ln_individual_tax_amount := 0;
671: ln_rec_account_tax_amount := 0;
672:
673: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise', 'START'); /* 1 */
674:
675: if p_transaction_type = 'CORRECT' then
676: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
677: lv_reference_10_desc := lv_reference_10_desc1 || p_receipt_num ||lv_reference_10_desc2 ||p_transaction_type ||' of Type ' || p_parent_transaction_type;

Line 883: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */

879: ln_non_modvat_amount := 0;
880: ln_other_modvat_amount := 0;
881: lv_debug := 'Y';
882:
883: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */
884:
885: OPEN c_ja_in_rcv_transactions(p_transaction_id);
886: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
887: CLOSE c_ja_in_rcv_transactions;

Line 1141: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.opm_costing', 'START'); /* 1 */

1137: otherwise
1138: the Quantity of RCV_TRANSACTIONS can be picked up.
1139: */
1140:
1141: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.opm_costing', 'START'); /* 1 */
1142:
1143: -- This procedure should not be used. So returning back
1144: -- GOTO exit_from_procedure;
1145:

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 1350: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.expense_accounting';

1346: --File.Sql.35 Cbabu
1347: lv_account_nature := 'Expense Accounting';
1348: lv_source := 'Purchasing India';
1349: lv_category := 'Receiving India';
1350: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1351: lv_reference24 := 'rcv_transactions';
1352: lv_reference25 := 'transaction_id';
1353: lv_debug := 'Y';
1354: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';

Line 1357: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_accounting', 'START'); /* 1 */

1353: lv_debug := 'Y';
1354: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
1355: lv_reference_10_desc2 := ' For the Transaction Type ';
1356:
1357: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_accounting', 'START'); /* 1 */
1358:
1359: /* Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1360: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1361: IF p_process_special_source = jai_constants.cenvat_noclaim THEN

Line 1568: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.average_costing', 'START'); /* 1 */

1564: lv_category := 'MTL';
1565: lv_debug := 'Y';
1566: lv_account_nature := 'Average Costing';
1567:
1568: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.average_costing', 'START'); /* 1 */
1569:
1570: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1571: lv_account_nature := 'Unclaim Average Costing';
1572:

Line 1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */

1773: lv_account_nature := 'Standard Costing';
1774: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1775: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1776:
1777: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1778:
1779: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1780: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1781: lv_account_nature := 'Unclaim Standard Costing';

Line 1833: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022

1829: p_entered_cr => ln_credit_amount,
1830: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1831: p_accounting_date => p_transaction_date,
1832: p_reference_10 => NULL,
1833: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1834: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1835: p_reference_25 => NULL,
1836: p_reference_26 => to_char(p_transaction_id),
1837: p_destination => 'S', /*Indicates Standard Costing. */

Line 1881: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022

1877: p_entered_cr => ln_credit_amount,
1878: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1879: p_accounting_date => p_transaction_date,
1880: p_reference_10 => NULL,
1881: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1882: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1883: p_reference_25 => NULL,
1884: p_reference_26 => to_char(p_transaction_id),
1885: p_destination => 'S', /*Indicates Standard Costing. */

Line 1932: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.receiving_account', 'START'); /* 1 */

1928: --lv_debug varchar2(1) := 'Y';
1929:
1930: BEGIN
1931:
1932: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.receiving_account', 'START'); /* 1 */
1933: open c_receiving_account(p_organization_id);
1934: fetch c_receiving_account into ln_receiving_account_id;
1935: close c_receiving_account;
1936:

Line 2002: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.material_account', 'START'); /* 1 */

1998:
1999: BEGIN
2000:
2001: lv_debug := 'Y';
2002: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.material_account', 'START'); /* 1 */
2003:
2004: if p_source_document_code = 'PO' then
2005:
2006: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 2112: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_account', 'START'); /* 1 */

2108: other possibilities
2109: */
2110:
2111: /* To be checked whether this can be done in a different way */
2112: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_account', 'START'); /* 1 */
2113:
2114: open c_fetch_expense_acct(p_organization_id, p_subinventory_code);
2115: fetch c_fetch_expense_acct into ln_expense_account;
2116: close c_fetch_expense_acct;

Line 2196: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.ppv_account', 'START'); /* 1 */

2192: BEGIN
2193:
2194: lv_debug := 'Y';
2195:
2196: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.ppv_account', 'START'); /* 1 */
2197: open c_ppv_account(p_organization_id);
2198: fetch c_ppv_account into ln_ppv_account_id;
2199: close c_ppv_account;
2200:

Line 2261: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.include_cenvat_in_costing', 'START'); /* 1 */

2257:
2258: begin
2259:
2260: lv_debug := 'Y';
2261: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.include_cenvat_in_costing', 'START'); /* 1 */
2262:
2263: OPEN c_trx(p_transaction_id);
2264: FETCH c_trx INTO r_trx;
2265: CLOSE c_trx;

Line 2434: END jai_rcv_deliver_rtr_pkg;

2430: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2431: return null;
2432: end include_cenvat_in_costing;
2433:
2434: END jai_rcv_deliver_rtr_pkg;