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 116: 19. 15-Apr_2010 Bo Li For bug9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS

112: 18. 06-04-2009 FP 12.0: 7539200:RECEIVING AND DELIVERY ACC VISIBLE FROM LOCALISATION SCREEN
113: Fix details: Commented the code which inserts accounting
114: entries in jai_rcv_journal_entries for OPM costing
115:
116: 19. 15-Apr_2010 Bo Li For bug9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS
117: with new meaningful one
118: 26-nov-2010 Bug 10335708
119: Description : Cenvat credit should be claimable, even if the items are delivered
120: to EXPENSE (not tracked as Inventory). Also, the quantity register should be updated

Line 145: FROM JAI_RCV_TRANSACTIONS

141:
142: /* Cursor Definitions */
143: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
144: SELECT *
145: FROM JAI_RCV_TRANSACTIONS
146: WHERE transaction_id = cp_transaction_id;
147:
148: CURSOR c_base_line_dtls(cp_transaction_id IN NUMBER) IS
149: SELECT quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity

Line 195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

191: ln_other_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
192: ln_total NUMBER; --File.Sql.35 Cbabu := 0;
193: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
194: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
196:
197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
198: lv_temp VARCHAR2(50);
199:

Line 197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

193: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
194: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
196:
197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
198: lv_temp VARCHAR2(50);
199:
200: lv_cenvat_costed_flag VARCHAR2(15);
201:

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

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;
222: CLOSE c_trx;
223:

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

248:
249: --p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
250: --lv_statement_id := '2.1';
251:
252: /* Fetch the information of certain columns which are not present in JAI_RCV_TRANSACTIONS */
253: OPEN c_rcv_trx(p_transaction_id);
254: FETCH c_rcv_trx into r_rcv_trx;
255: CLOSE c_rcv_trx;
256:

Line 667: /*jai_rcv_transactions_pkg.update_attributes(

663: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);
664:
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: );*/

Line 673: jai_rcv_transactions_pkg.update_cenvat_costed_flag(

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(
674: p_transaction_id => p_transaction_id,
675: p_cenvat_costed_flag => lv_cenvat_costed_flag
676: );
677: --------------------------------------------------------------------------------------------

Line 966: from JAI_RCV_TRANSACTIONS

962: ln_tax_amount NUMBER ; /* Added for bug #13494816 */
963:
964: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
965: select item_trading_flag,organization_type,excise_in_trading,item_excisable
966: from JAI_RCV_TRANSACTIONS
967: where transaction_id = cp_transaction_id;
968:
969: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
970:

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

1924: lv_category VARCHAR2(30); --File.Sql.35 Cbabu := 'MTL';
1925: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Standard Costing';
1926: --lv_debug varchar2(1) := 'Y';
1927:
1928: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1929: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1930: lv_reference_10_desc2 VARCHAR2(30); --rchandan for bug#4473022
1931: lv_reference_10_desc gl_interface.reference10%type;--rchandan for bug#4473022
1932:

Line 2398: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;

2394: lv_ret_value VARCHAR2(30);
2395:
2396: lv_destination_type varchar2(30);
2397: lv_transaction_type varchar2(30);
2398: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;
2399: lv_debug varchar2(1);--File.Sql.35 Cbabu := 'Y';
2400: lv_include_cenvat_in_costing varchar2(1);
2401:
2402: ln_dlry_trx_id NUMBER;

Line 2413: FROM JAI_RCV_TRANSACTIONS

2409: WHERE transaction_id = cp_transaction_id;
2410:
2411: CURSOR c_trx(cp_transaction_id number) is
2412: SELECT *
2413: FROM JAI_RCV_TRANSACTIONS
2414: WHERE transaction_id = cp_transaction_id;
2415:
2416: r_trx c_trx%ROWTYPE;
2417: r_dlry_trx c_trx%ROWTYPE;

Line 2600: (r_trx IN jai_rcv_transactions%ROWTYPE,

2596: end include_cenvat_in_costing;
2597: /*procedures added for bug 10335708*/
2598:
2599: PROCEDURE pr_issue_auto_trans
2600: (r_trx IN jai_rcv_transactions%ROWTYPE,
2601: pn_transaction_id IN NUMBER,
2602: p_rg23_entry IN NUMBER,
2603: p_rg_i_entry IN NUMBER,
2604: p_process_status OUT NOCOPY VARCHAR2,

Line 2609: lv_transaction_type jai_rcv_transactions.transaction_type%TYPE;

2605: p_process_message OUT NOCOPY VARCHAR2)
2606: IS
2607: PRAGMA autonomous_transaction;
2608: ln_register_id NUMBER;
2609: lv_transaction_type jai_rcv_transactions.transaction_type%TYPE;
2610: ln_quantity NUMBER;
2611: lv_slno NUMBER;
2612:
2613: BEGIN

Line 2752: FROM jai_rcv_transactions

2748: IS
2749:
2750: CURSOR c_trx IS
2751: SELECT *
2752: FROM jai_rcv_transactions
2753: WHERE transaction_id = pn_transaction_id;
2754:
2755: CURSOR c_rg23_i_entry (cp_transaction_id NUMBER) IS
2756: SELECT 1