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.15.12020000.2 2012/07/15 10:46:19 nkodakan 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.15.12020000.2 2012/07/15 10:46:19 nkodakan 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 177: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';

173: r_dlry_trx c_trx%rowtype;
174:
175:
176: /* Variable Declarations */
177: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';
178: -- lv_register_type VARCHAR2(1); --Either A or C.
179: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;
180: lv_statement_id VARCHAR2(4);
181: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';

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

199:
200: lv_cenvat_costed_flag VARCHAR2(15);
201:
202: BEGIN
203: lv_procedure_name := 'jai_rcv_deliver_rtr_pkg.process_transaction';
204: lv_debug := jai_constants.yes;
205: ln_apportion_factor := 1; -- default value added by Vijay Shankar for Bug#4068823 for RECEIPTS DEPLUG
206: ln_modvat_amount := 0;
207: ln_non_modvat_amount := 0;

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

209: ln_total := 0;
210: ln_opm_total := 0;
211:
212: -- this is to identify the path in SQL TRACE file if any problem occured
213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
214:
215: 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'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */

Line 215: 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'));

211:
212: -- this is to identify the path in SQL TRACE file if any problem occured
213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
214:
215: 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'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
218:
219: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

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

213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
214:
215: 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'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
218:
219: /* Fetch all the information from JAI_RCV_TRANSACTIONS */
220: OPEN c_trx(p_transaction_id);
221: FETCH c_trx INTO r_trx;

Line 659: OR (/*r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag

655: lv_cenvat_costed_flag := jai_constants.no;
656: END IF;
657:
658: IF r_trx.cenvat_costed_flag IS NULL --Modified by Bo Li for replacing the attribute2 with cenvat_costed_flag
659: OR (/*r_trx.attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag
660: AND*/nvl(r_trx.cenvat_costed_flag,jai_constants.no) <> jai_constants.yes)--Modified by Bo Li for replacing the attribute2 with cenvat_costed_flg
661: THEN
662:
663: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);

Line 669: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,

665: --Modified by Bo Li for replacing the update_attributes with update_cenvat_costed_flag Begin
666: --------------------------------------------------------------------------------------------
667: /*jai_rcv_transactions_pkg.update_attributes(
668: p_transaction_id => p_transaction_id,
669: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,
670: p_attribute2 => lv_cenvat_costed_flag
671: );*/
672:
673: jai_rcv_transactions_pkg.update_cenvat_costed_flag(

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

748: --File.Sql.35 Cbabu
749: lv_account_nature := 'Individual Tax';
750: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
751: lv_reference_10_desc2 := ' For the Transaction Type ';
752: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
753: lv_source := 'Purchasing India';
754: lv_category := 'Receiving India';
755: lv_reference24 := 'rcv_transactions';
756: lv_reference25 := 'transaction_id';

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

756: lv_reference25 := 'transaction_id';
757: ln_individual_tax_amount := 0;
758: ln_rec_account_tax_amount := 0;
759:
760: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise', 'START'); /* 1 */
761:
762: if p_transaction_type = 'CORRECT' then
763: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
764: 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 979: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */

975: ln_non_modvat_amount := 0;
976: ln_other_modvat_amount := 0;
977: lv_debug := 'Y';
978:
979: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */
980:
981: OPEN c_ja_in_rcv_transactions(p_transaction_id);
982: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
983: CLOSE c_ja_in_rcv_transactions;

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

1287: otherwise
1288: the Quantity of RCV_TRANSACTIONS can be picked up.
1289: */
1290:
1291: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.opm_costing', 'START'); /* 1 */
1292:
1293: -- This procedure should not be used. So returning back
1294: -- GOTO exit_from_procedure;
1295:

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

1510: --File.Sql.35 Cbabu
1511: lv_account_nature := 'Expense Accounting';
1512: lv_source := 'Purchasing India';
1513: lv_category := 'Receiving India';
1514: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1515: lv_reference24 := 'rcv_transactions';
1516: lv_reference25 := 'transaction_id';
1517: lv_debug := 'Y';
1518: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';

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

1517: lv_debug := 'Y';
1518: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
1519: lv_reference_10_desc2 := ' For the Transaction Type ';
1520:
1521: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_accounting', 'START'); /* 1 */
1522:
1523: /* Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1524: vat_noclaim added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1525: IF p_process_special_source = jai_constants.cenvat_noclaim THEN

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

1728: lv_category := 'MTL';
1729: lv_debug := 'Y';
1730: lv_account_nature := 'Average Costing';
1731:
1732: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.average_costing', 'START'); /* 1 */
1733:
1734: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1735: lv_account_nature := 'Unclaim Average Costing';
1736:

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

1937: lv_account_nature := 'Standard Costing';
1938: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1939: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
1940:
1941: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.standard_costing', 'START'); /* 1 */
1942:
1943: -- Vijay Shankar for Bug#4068823. RECEIPTS DEPLUG
1944: IF p_process_special_source = jai_constants.cenvat_noclaim THEN
1945: lv_account_nature := 'Unclaim Standard Costing';

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

1993: p_entered_cr => ln_credit_amount,
1994: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1995: p_accounting_date => p_transaction_date,
1996: p_reference_10 => NULL,
1997: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1999: p_reference_25 => NULL,
2000: p_reference_26 => to_char(p_transaction_id),
2001: p_destination => 'S', /*Indicates Standard Costing. */

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

2041: p_entered_cr => ln_credit_amount,
2042: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
2043: p_accounting_date => p_transaction_date,
2044: p_reference_10 => NULL,
2045: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
2047: p_reference_25 => NULL,
2048: p_reference_26 => to_char(p_transaction_id),
2049: p_destination => 'S', /*Indicates Standard Costing. */

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

2092: --lv_debug varchar2(1) := 'Y';
2093:
2094: BEGIN
2095:
2096: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.receiving_account', 'START'); /* 1 */
2097: open c_receiving_account(p_organization_id);
2098: fetch c_receiving_account into ln_receiving_account_id;
2099: close c_receiving_account;
2100:

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

2162:
2163: BEGIN
2164:
2165: lv_debug := 'Y';
2166: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.material_account', 'START'); /* 1 */
2167:
2168: if p_source_document_code = 'PO' then
2169:
2170: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

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

2272: other possibilities
2273: */
2274:
2275: /* To be checked whether this can be done in a different way */
2276: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.expense_account', 'START'); /* 1 */
2277:
2278: open c_fetch_expense_acct(p_organization_id, p_subinventory_code);
2279: fetch c_fetch_expense_acct into ln_expense_account;
2280: close c_fetch_expense_acct;

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

2356: BEGIN
2357:
2358: lv_debug := 'Y';
2359:
2360: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.ppv_account', 'START'); /* 1 */
2361: open c_ppv_account(p_organization_id);
2362: fetch c_ppv_account into ln_ppv_account_id;
2363: close c_ppv_account;
2364:

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

2421:
2422: begin
2423:
2424: lv_debug := 'Y';
2425: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.include_cenvat_in_costing', 'START'); /* 1 */
2426:
2427: OPEN c_trx(p_transaction_id);
2428: FETCH c_trx INTO r_trx;
2429: CLOSE c_trx;

Line 2823: END jai_rcv_deliver_rtr_pkg;

2819: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END');
2820: END pr_issue_expense_delivery;
2821:
2822:
2823: END jai_rcv_deliver_rtr_pkg;