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_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 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 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 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 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 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;