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 RCV_TRANSACTIONS

Line 50: - started passing the value to newly added parameter by fetching the value from JAI_RCV_TRANSACTIONS table

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".
54: This would be called from jai_rcv_rgm_claims_pkg incase of VAT NOCLAIM selected by user for a receipt line incase

Line 114: FROM JAI_RCV_TRANSACTIONS

110:
111: /* Cursor Definitions */
112: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
113: SELECT *
114: FROM JAI_RCV_TRANSACTIONS
115: WHERE transaction_id = cp_transaction_id;
116:
117: CURSOR c_base_line_dtls(cp_transaction_id IN NUMBER) IS
118: SELECT quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity

Line 119: from rcv_transactions

115: WHERE transaction_id = cp_transaction_id;
116:
117: CURSOR c_base_line_dtls(cp_transaction_id IN NUMBER) IS
118: SELECT quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity
119: from rcv_transactions
120: where transaction_id = cp_transaction_id;
121:
122: CURSOR c_rcv_trx(cp_transaction_id IN NUMBER) IS
123: SELECT *

Line 124: FROM rcv_transactions

120: where transaction_id = cp_transaction_id;
121:
122: CURSOR c_rcv_trx(cp_transaction_id IN NUMBER) IS
123: SELECT *
124: FROM rcv_transactions
125: where transaction_id = cp_transaction_id;
126:
127: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
128: /* Bug 4941701. Added by Lakshmi Gopalsami

Line 153: lv_destination_type rcv_transactions.destination_type_code%type;

149: lv_statement_id VARCHAR2(4);
150: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
151: lv_accounting_type VARCHAR2(30);
152: lv_include_cenvat_in_costing VARCHAR2(1);
153: lv_destination_type rcv_transactions.destination_type_code%type;
154:
155:
156: /* Number Declarations */
157: ln_apportion_factor NUMBER; --File.Sql.35 Cbabu := 1; -- default value added by Vijay Shankar for Bug#4068823 for RECEIPTS DEPLUG

Line 164: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

160: ln_other_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
161: ln_total NUMBER; --File.Sql.35 Cbabu := 0;
162: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
163: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
164: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
165:
166: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
167: lv_temp VARCHAR2(50);
168:

Line 166: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

162: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
163: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
164: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
165:
166: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
167: lv_temp VARCHAR2(50);
168:
169: lv_cenvat_costed_flag VARCHAR2(15);
170:

Line 188: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

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;
191: CLOSE c_trx;
192:

Line 205: /* Fetch all the information from rcv_transactions for transaction type RECEIVE*/

201: p_required_trx_type => 'RECEIVE'
202: );
203: */
204:
205: /* Fetch all the information from rcv_transactions for transaction type RECEIVE*/
206: OPEN c_base_line_dtls(ln_receive_trx_id);
207: FETCH c_base_line_dtls INTO r_base_line_dtls;
208: CLOSE c_base_line_dtls;
209:

Line 214: p_process_message := 'The Quantity in rcv_transactions for RECEIVE line is Zero';

210: lv_statement_id := '2';
211: if r_base_line_dtls.quantity = 0 THEN
212: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
213: p_process_status := 'E';
214: p_process_message := 'The Quantity in rcv_transactions for RECEIVE line is Zero';
215: goto exit_from_procedure;
216: end if;
217:
218: --p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

Line 221: /* Fetch the information of certain columns which are not present in JAI_RCV_TRANSACTIONS */

217:
218: --p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
219: --lv_statement_id := '2.1';
220:
221: /* Fetch the information of certain columns which are not present in JAI_RCV_TRANSACTIONS */
222: OPEN c_rcv_trx(p_transaction_id);
223: FETCH c_rcv_trx into r_rcv_trx;
224: CLOSE c_rcv_trx;
225:

Line 587: jai_rcv_transactions_pkg.update_attributes(

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);
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: );

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 668: lv_reference24 := 'rcv_transactions';

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';
670: ln_individual_tax_amount := 0;
671: ln_rec_account_tax_amount := 0;
672:

Line 868: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is

864: ln_conv_factor NUMBER;
865: lv_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag%type;
866: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
867:
868: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
869: select item_trading_flag,organization_type,excise_in_trading,item_excisable
870: from JAI_RCV_TRANSACTIONS
871: where transaction_id = cp_transaction_id;
872:

Line 870: from JAI_RCV_TRANSACTIONS

866: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
867:
868: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
869: select item_trading_flag,organization_type,excise_in_trading,item_excisable
870: from JAI_RCV_TRANSACTIONS
871: where transaction_id = cp_transaction_id;
872:
873: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
874:

Line 873: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;

869: select item_trading_flag,organization_type,excise_in_trading,item_excisable
870: from JAI_RCV_TRANSACTIONS
871: where transaction_id = cp_transaction_id;
872:
873: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
874:
875: BEGIN
876:
877: --File.Sql.35 Cbabu

Line 885: OPEN c_ja_in_rcv_transactions(p_transaction_id);

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;
888:
889: FOR tax_rec IN

Line 886: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;

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;
888:
889: FOR tax_rec IN
890: (

Line 887: CLOSE c_ja_in_rcv_transactions;

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;
888:
889: FOR tax_rec IN
890: (
891: SELECT

Line 950: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */

946: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
947: lv_tax_modvat_flag := 'Y';
948:
949: elsif tax_rec.modvat_flag = 'N'
950: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',

Line 951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'

947: lv_tax_modvat_flag := 'Y';
948:
949: elsif tax_rec.modvat_flag = 'N'
950: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 952: and r_ja_in_rcv_transactions.item_excisable = 'Y'

948:
949: elsif tax_rec.modvat_flag = 'N'
950: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,

Line 953: and r_ja_in_rcv_transactions.organization_type = 'T'

949: elsif tax_rec.modvat_flag = 'N'
950: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
951: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
952: and r_ja_in_rcv_transactions.item_excisable = 'Y'
953: and r_ja_in_rcv_transactions.organization_type = 'T'
954: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
955: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
956: jai_constants.tax_type_exc_edu_cess,
957: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

Line 1097: ln_rcv_quantity rcv_transactions.quantity%TYPE;

1093: /* following parameter added by Vijay Shankar for Bug#4229164 */
1094: p_currency_conversion_rate IN NUMBER
1095: ) IS
1096:
1097: ln_rcv_quantity rcv_transactions.quantity%TYPE;
1098: ln_material_account_id mtl_secondary_inventories.material_account%type;
1099: ln_costing_amount NUMBER;
1100:
1101: lv_accounting_type varchar2(30); --File.Sql.35 Cbabu := 'REGULAR'; /*Hard coded as Localization does not do anything in case of a RTR Transaction */

Line 1122: Only JAI_RCV_JOURNAL_ENTRIES is recorded with above entries But RCV_TRANSACTIONS will be updated only

1118: | DELIVER | Total | Inv.Receiving | |
1119: | DELIVER | Total | | Material Account |
1120: ----------------|-----------------------|---------------------------|--------------------------|
1121:
1122: Only JAI_RCV_JOURNAL_ENTRIES is recorded with above entries But RCV_TRANSACTIONS will be updated only
1123: once.
1124: */
1125:
1126: BEGIN

Line 1136: source doc quantity of RCV_TRANSACTIONS needs to be picked up

1132:
1133: /* This comparison is for Evaluating the Quantity */
1134: /* Meaning of this comparison
1135: if the Unit Of Measure is changed while RECEIVING then
1136: source doc quantity of RCV_TRANSACTIONS needs to be picked up
1137: otherwise
1138: the Quantity of RCV_TRANSACTIONS can be picked up.
1139: */
1140:

Line 1138: the Quantity of RCV_TRANSACTIONS can be picked up.

1134: /* Meaning of this comparison
1135: if the Unit Of Measure is changed while RECEIVING then
1136: source doc quantity of RCV_TRANSACTIONS needs to be picked up
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:

Line 1201: and also rcv_transactions would be updated */

1197: );
1198: end if;
1199:
1200: /* Destination in this case is O1, which indicates that the JAI_RCV_JOURNAL_ENTRIES would be hit
1201: and also rcv_transactions would be updated */
1202: /* Credit Inventory Receiving Account */
1203: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1204: jai_rcv_accounting_pkg.process_transaction
1205: (

Line 1240: and also rcv_transactions would be updated */

1236: end if;
1237:
1238: /* Debit Material Account
1239: Destination in this case is O1, which indicates that the JAI_RCV_JOURNAL_ENTRIES would be hit
1240: and also rcv_transactions would be updated */
1241:
1242: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1243: jai_rcv_accounting_pkg.process_transaction
1244: (

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 1351: lv_reference24 := 'rcv_transactions';

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 ';
1355: lv_reference_10_desc2 := ' For the Transaction Type ';

Line 1764: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

1760: lv_category VARCHAR2(30); --File.Sql.35 Cbabu := 'MTL';
1761: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Standard Costing';
1762: --lv_debug varchar2(1) := 'Y';
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:

Line 1834: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

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. */
1838: p_simulate_flag => p_simulate,

Line 1882: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

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. */
1886: p_simulate_flag => p_simulate,

Line 2234: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;

2230: lv_ret_value VARCHAR2(30);
2231:
2232: lv_destination_type varchar2(30);
2233: lv_transaction_type varchar2(30);
2234: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;
2235: lv_debug varchar2(1);--File.Sql.35 Cbabu := 'Y';
2236: lv_include_cenvat_in_costing varchar2(1);
2237:
2238: ln_dlry_trx_id NUMBER;

Line 2249: FROM JAI_RCV_TRANSACTIONS

2245: WHERE transaction_id = cp_transaction_id;
2246:
2247: CURSOR c_trx(cp_transaction_id number) is
2248: SELECT *
2249: FROM JAI_RCV_TRANSACTIONS
2250: WHERE transaction_id = cp_transaction_id;
2251:
2252: r_trx c_trx%ROWTYPE;
2253: r_dlry_trx c_trx%ROWTYPE;