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_EXCISE_PROCESSING_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 256: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

252: p_other_cenvat_claimed_amt IN NUMBER
253: ) IS
254:
255: r_trx c_trx%ROWTYPE;
256: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
257:
258: --start additions for bug#4750798
259:
260: CURSOR c_rtv_qty(cp_transaction_id jai_rcv_transactions.transaction_id%TYPE)

Line 260: CURSOR c_rtv_qty(cp_transaction_id jai_rcv_transactions.transaction_id%TYPE)

256: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
257:
258: --start additions for bug#4750798
259:
260: CURSOR c_rtv_qty(cp_transaction_id jai_rcv_transactions.transaction_id%TYPE)
261: IS
262: select quantity from jai_rcv_transactions
263: WHERE transaction_id = cp_transaction_id;
264:

Line 262: select quantity from jai_rcv_transactions

258: --start additions for bug#4750798
259:
260: CURSOR c_rtv_qty(cp_transaction_id jai_rcv_transactions.transaction_id%TYPE)
261: IS
262: select quantity from jai_rcv_transactions
263: WHERE transaction_id = cp_transaction_id;
264:
265: cursor c_fetch_base_correct_qty(p_transaction_id number) is
266: select nvl(sum(quantity),0)

Line 271: v_rtv_qty jai_rcv_transactions.quantity%TYPE;

267: from rcv_transactions
268: where parent_transaction_id = p_transaction_id
269: and transaction_type='CORRECT';
270:
271: v_rtv_qty jai_rcv_transactions.quantity%TYPE;
272: v_excise_rf NUMBER;
273: v_excise_edu_cess_rf NUMBER;
274: v_excise_she_cess_rf NUMBER;
275: v_base_correct_quantity NUMBER;

Line 1008: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

1004: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
1005: ln_trx_type_code NUMBER(5);
1006:
1007: -- For RTV case
1008: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1009: ln_receive_basic NUMBER;
1010: ln_receive_addl NUMBER;
1011: ln_receive_other NUMBER;
1012: ln_receive_cvd NUMBER;

Line 1044: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;

1040: lv_part_ii_register VARCHAR2(20);
1041: ln_part_ii_register_id NUMBER;
1042: lv_register_type VARCHAR(1);
1043:
1044: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;
1045: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;
1046: lv_tax_breakup_type VARCHAR2(20);
1047: lb_process_iso BOOLEAN;
1048:

Line 1045: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;

1041: ln_part_ii_register_id NUMBER;
1042: lv_register_type VARCHAR(1);
1043:
1044: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;
1045: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;
1046: lv_tax_breakup_type VARCHAR2(20);
1047: lb_process_iso BOOLEAN;
1048:
1049: lv_message VARCHAR2(500);

Line 1088: FROM jai_rcv_transactions jrt

1084: CURSOR C_Get_Total_RTV (cp_shipment_header_id IN NUMBER,
1085: cp_shipment_line_id IN NUMBER
1086: ) IS
1087: SELECT SUM(nvl(quantity,0))
1088: FROM jai_rcv_transactions jrt
1089: WHERE
1090: -- jrt.transaction_id > p_transaction_id AND
1091: jrt.transaction_type = 'RETURN TO VENDOR'
1092: AND jrt.shipment_header_id = cp_shipment_header_id

Line 1101: FROM jai_rcv_transactions

1097:
1098: /* Added for bug #13362352 *//*Start*/
1099: CURSOR cur_destination_type_code IS
1100: SELECT destination_type_code
1101: FROM jai_rcv_transactions
1102: WHERE transaction_id = p_transaction_id;
1103:
1104: CURSOR cur_parent_trx( cp_prnt_trx_id NUMBER ) IS
1105: SELECT *

Line 1106: FROM jai_rcv_transactions

1102: WHERE transaction_id = p_transaction_id;
1103:
1104: CURSOR cur_parent_trx( cp_prnt_trx_id NUMBER ) IS
1105: SELECT *
1106: FROM jai_rcv_transactions
1107: WHERE transaction_id = cp_prnt_trx_id;
1108:
1109: parent_trx_rec cur_parent_trx%ROWTYPE ;
1110:

Line 1111: lv_destination_type_code jai_rcv_transactions.destination_type_code%type;

1107: WHERE transaction_id = cp_prnt_trx_id;
1108:
1109: parent_trx_rec cur_parent_trx%ROWTYPE ;
1110:
1111: lv_destination_type_code jai_rcv_transactions.destination_type_code%type;
1112: /* Added for bug #13362352 *//*End*/
1113:
1114: BEGIN
1115:

Line 1196: the JAI_RCV_TRANSACTIONS.transaction_date. It should be the date on which claim is being made.

1192:
1193: Problem
1194: -------
1195: During Cenvat Claim, while Inserting the Record into JAI_CMN_RG_23AC_II_TRXS, the Transaction date is inserted as Transaction Date of
1196: the JAI_RCV_TRANSACTIONS.transaction_date. It should be the date on which claim is being made.
1197:
1198: Fix
1199: ---
1200: In the Procedure rg23_part_ii_entry, while calling jai_cmn_rg_23ac_ii_pkg.insert_row, value of the parameter

Line 1431: jai_rcv_transactions_pkg.update_excise_invoice_no(

1427: );
1428:
1429: lv_statement_id := '7';
1430: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
1431: jai_rcv_transactions_pkg.update_excise_invoice_no(
1432: p_transaction_id => p_transaction_id,
1433: p_excise_invoice_no => lv_excise_invoice_no,
1434: p_excise_invoice_date => ld_excise_invoice_date
1435: );

Line 2242: UPDATE JAI_RCV_TRANSACTIONS

2238:
2239:
2240: /*bgowrava for forward porting Bug#5756676..start*/
2241:
2242: UPDATE JAI_RCV_TRANSACTIONS
2243: SET quantity_register_flag = 'Y',
2244: last_updated_by = fnd_global.user_id,
2245: last_update_date = sysdate,
2246: last_update_login = fnd_global.login_id

Line 2487: UPDATE JAI_RCV_TRANSACTIONS

2483: );
2484:
2485: /*bgowrava for forward porting Bug#5756676..start*/
2486:
2487: UPDATE JAI_RCV_TRANSACTIONS
2488: SET quantity_register_flag = 'Y',
2489: last_updated_by = fnd_global.user_id,
2490: last_update_date = sysdate,
2491: last_update_login = fnd_global.login_id

Line 4911: CURSOR c_taxes(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

4907: r_jai_receipt_line c_jai_receipt_line%ROWTYPE; -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
4908: lv_source_req CONSTANT VARCHAR2(3) := 'REQ';
4909:
4910: --Added for bug #14852106
4911: CURSOR c_taxes(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
4912: SELECT count(1) total_cnt,
4913: sum( decode(upper(tax_type), 'EXCISE', 1,
4914: 'ADDL. EXCISE', 1,
4915: 'OTHER EXCISE', 1,

Line 5170: --ln_ancestor_receive_trxn_id JAI_RCV_TRANSACTIONS.transaction_id%TYPE;

5166:
5167: ln_cenvat_claimed_ptg NUMBER;
5168: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_receive_claimed_ptg';
5169:
5170: --ln_ancestor_receive_trxn_id JAI_RCV_TRANSACTIONS.transaction_id%TYPE;
5171:
5172: BEGIN
5173:
5174: /*

Line 5608: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

5604: ) IS
5605:
5606: r_trx c_trx%ROWTYPE;
5607:
5608: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
5609: ln_receive_claimed_ptg NUMBER;
5610: lv_message VARCHAR2(200);
5611: lv_object_name varchar2(200) := 'jai_rcv_excise_processing_pkg.dervice_cgin_scenario';
5612:

Line 5802: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;

5798:
5799: r_orgn_info c_orgn_info%ROWTYPE;
5800: ln_trx_amount NUMBER; --added for bug#9854329
5801:
5802: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;
5803: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;
5804:
5805: lv_pref1_register VARCHAR2(30);
5806: lv_pref2_register VARCHAR2(30);

Line 5803: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;

5799: r_orgn_info c_orgn_info%ROWTYPE;
5800: ln_trx_amount NUMBER; --added for bug#9854329
5801:
5802: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;
5803: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;
5804:
5805: lv_pref1_register VARCHAR2(30);
5806: lv_pref2_register VARCHAR2(30);
5807: