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 207: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

203: p_other_cenvat_claimed_amt IN NUMBER
204: ) IS
205:
206: r_trx c_trx%ROWTYPE;
207: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
208:
209: ln_trx_qty_for_2nd_claim NUMBER;
210: ln_trx_equivalent_of_receive NUMBER;
211: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.post_cenvat_processor';

Line 877: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

873: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
874: ln_trx_type_code NUMBER(5);
875:
876: -- For RTV case
877: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
878: ln_receive_basic NUMBER;
879: ln_receive_addl NUMBER;
880: ln_receive_other NUMBER;
881: ln_receive_cvd NUMBER;

Line 913: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;

909: lv_part_ii_register VARCHAR2(20);
910: ln_part_ii_register_id NUMBER;
911: lv_register_type VARCHAR(1);
912:
913: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;
914: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;
915: lv_tax_breakup_type VARCHAR2(20);
916: lb_process_iso BOOLEAN;
917:

Line 914: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;

910: ln_part_ii_register_id NUMBER;
911: lv_register_type VARCHAR(1);
912:
913: lv_excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE;
914: ld_excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE;
915: lv_tax_breakup_type VARCHAR2(20);
916: lb_process_iso BOOLEAN;
917:
918: lv_message VARCHAR2(500);

Line 957: FROM jai_rcv_transactions jrt

953: CURSOR C_Get_Total_RTV (cp_shipment_header_id IN NUMBER,
954: cp_shipment_line_id IN NUMBER
955: ) IS
956: SELECT SUM(nvl(quantity,0))
957: FROM jai_rcv_transactions jrt
958: WHERE
959: -- jrt.transaction_id > p_transaction_id AND
960: jrt.transaction_type = 'RETURN TO VENDOR'
961: AND jrt.shipment_header_id = cp_shipment_header_id

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

1045:
1046: Problem
1047: -------
1048: During Cenvat Claim, while Inserting the Record into JAI_CMN_RG_23AC_II_TRXS, the Transaction date is inserted as Transaction Date of
1049: the JAI_RCV_TRANSACTIONS.transaction_date. It should be the date on which claim is being made.
1050:
1051: Fix
1052: ---
1053: In the Procedure rg23_part_ii_entry, while calling jai_cmn_rg_23ac_ii_pkg.insert_row, value of the parameter

Line 1272: jai_rcv_transactions_pkg.update_excise_invoice_no(

1268: );
1269:
1270: lv_statement_id := '7';
1271: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
1272: jai_rcv_transactions_pkg.update_excise_invoice_no(
1273: p_transaction_id => p_transaction_id,
1274: p_excise_invoice_no => lv_excise_invoice_no,
1275: p_excise_invoice_date => ld_excise_invoice_date
1276: );

Line 2033: UPDATE JAI_RCV_TRANSACTIONS

2029:
2030:
2031: /*bgowrava for forward porting Bug#5756676..start*/
2032:
2033: UPDATE JAI_RCV_TRANSACTIONS
2034: SET quantity_register_flag = 'Y',
2035: last_updated_by = fnd_global.user_id,
2036: last_update_date = sysdate,
2037: last_update_login = fnd_global.login_id

Line 2253: UPDATE JAI_RCV_TRANSACTIONS

2249: );
2250:
2251: /*bgowrava for forward porting Bug#5756676..start*/
2252:
2253: UPDATE JAI_RCV_TRANSACTIONS
2254: SET quantity_register_flag = 'Y',
2255: last_updated_by = fnd_global.user_id,
2256: last_update_date = sysdate,
2257: last_update_login = fnd_global.login_id

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

4773:
4774: ln_cenvat_claimed_ptg NUMBER;
4775: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_receive_claimed_ptg';
4776:
4777: --ln_ancestor_receive_trxn_id JAI_RCV_TRANSACTIONS.transaction_id%TYPE;
4778:
4779: BEGIN
4780:
4781: /*

Line 5075: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

5071: ) IS
5072:
5073: r_trx c_trx%ROWTYPE;
5074:
5075: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
5076: ln_receive_claimed_ptg NUMBER;
5077: lv_message VARCHAR2(200);
5078: lv_object_name varchar2(200) := 'jai_rcv_excise_processing_pkg.dervice_cgin_scenario';
5079:

Line 5267: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;

5263: ) IS
5264:
5265: r_orgn_info c_orgn_info%ROWTYPE;
5266:
5267: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;
5268: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;
5269:
5270: lv_pref1_register VARCHAR2(30);
5271: lv_pref2_register VARCHAR2(30);

Line 5268: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;

5264:
5265: r_orgn_info c_orgn_info%ROWTYPE;
5266:
5267: lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;
5268: lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;
5269:
5270: lv_pref1_register VARCHAR2(30);
5271: lv_pref2_register VARCHAR2(30);
5272: