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

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 1004: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

1000:
1001: r_trx c_trx%ROWTYPE;
1002: r_base_trx c_base_trx%ROWTYPE;
1003: r_orgn_info c_orgn_info%ROWTYPE;
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;

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 2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2037: r_parent_base_trx c_base_trx%ROWTYPE;
2038:
2039: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2037: r_parent_base_trx c_base_trx%ROWTYPE;
2038:
2039: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
2040: ln_basic_ed NUMBER;

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 2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

2282: r_base_trx c_base_trx%ROWTYPE;
2283: r_po_header c_po_header%ROWTYPE;
2284:
2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2283: r_po_header c_po_header%ROWTYPE;
2284:
2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2293: r_parent_base_trx c_base_trx%ROWTYPE;
2294:

Line 2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2293: r_parent_base_trx c_base_trx%ROWTYPE;
2294:
2295: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2293: r_parent_base_trx c_base_trx%ROWTYPE;
2294:
2295: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
2296: ln_basic_ed NUMBER;

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 2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

2544: r_trx c_trx%ROWTYPE;
2545: r_base_trx c_base_trx%ROWTYPE;
2546:
2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;

Line 2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2545: r_base_trx c_base_trx%ROWTYPE;
2546:
2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2556: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2557: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2556: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2557: r_parent_base_trx c_base_trx%ROWTYPE;
2558:
2559: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 2556: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2556: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2557: r_parent_base_trx c_base_trx%ROWTYPE;
2558:
2559: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
2560: ln_basic_ed NUMBER;

Line 2570: ln_ancestor_trxn_id RCV_TRANSACTIONS.transaction_id%TYPE;

2566: ln_quantity_received NUMBER;
2567: ln_qty_to_adjust NUMBER;
2568:
2569: ln_ancestor_reg_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2570: ln_ancestor_trxn_id RCV_TRANSACTIONS.transaction_id%TYPE;
2571:
2572: lv_statement_id VARCHAR2(5);
2573:
2574: ln_other_tax_debit NUMBER;

Line 2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

2920: ln_reference_num NUMBER ;/*vkaranam for bug#4767479*/
2921: lv_exc_flag VARCHAR2 (1);/*vkaranam for bug#4767479*/
2922:
2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

Line 2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2921: lv_exc_flag VARCHAR2 (1);/*vkaranam for bug#4767479*/
2922:
2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2922:
2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;

Line 2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;

Line 3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

3274: r_base_trx c_base_trx%ROWTYPE;
3275: r_orgn_info c_orgn_info%ROWTYPE;
3276:
3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

3275: r_orgn_info c_orgn_info%ROWTYPE;
3276:
3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:

Line 3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;

Line 3561: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

3557: r_orgn_info c_orgn_info%ROWTYPE;
3558: r_rcv_params c_rcv_params%ROWTYPE;
3559:
3560: lv_register_type VARCHAR2(1);
3561: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3562: ln_total_excise_amt NUMBER;
3563: ln_cenvat_claimed_ptg NUMBER;
3564:
3565: lv_accnt_type JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE;

Line 4069: P_REFERENCE_24 => 'rcv_transactions',

4065: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4066: P_ACCOUNTING_DATE => lv_accounting_date,
4067: P_REFERENCE_10 => lv_reference10,
4068: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4069: P_REFERENCE_24 => 'rcv_transactions',
4070: P_REFERENCE_25 => 'transaction_id',
4071: P_REFERENCE_26 => to_char(p_transaction_id),
4072: P_DESTINATION => 'G',
4073: P_SIMULATE_FLAG => p_simulate_flag,

Line 4110: P_REFERENCE_24 => 'rcv_transactions',

4106: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4107: P_ACCOUNTING_DATE => lv_accounting_date,
4108: P_REFERENCE_10 => lv_reference10,
4109: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4110: P_REFERENCE_24 => 'rcv_transactions',
4111: P_REFERENCE_25 => 'transaction_id',
4112: P_REFERENCE_26 => to_char(p_transaction_id),
4113: P_DESTINATION => 'G',
4114: P_SIMULATE_FLAG => p_simulate_flag,

Line 4151: P_REFERENCE_24 => 'rcv_transactions',

4147: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4148: P_ACCOUNTING_DATE => lv_accounting_date,
4149: P_REFERENCE_10 => lv_reference10,
4150: P_REFERENCE_23 => 'ja_in_receipt_cenvat_rg_pkg.accounting_entries',
4151: P_REFERENCE_24 => 'rcv_transactions',
4152: P_REFERENCE_25 => 'transaction_id',
4153: P_REFERENCE_26 => to_char(p_transaction_id),
4154: P_DESTINATION => 'G',
4155: P_SIMULATE_FLAG => p_simulate_flag,

Line 4195: P_REFERENCE_24 => 'rcv_transactions',

4191: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4192: P_ACCOUNTING_DATE => lv_accounting_date,
4193: P_REFERENCE_10 => lv_reference10,
4194: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4195: P_REFERENCE_24 => 'rcv_transactions',
4196: P_REFERENCE_25 => 'transaction_id',
4197: P_REFERENCE_26 => to_char(p_transaction_id),
4198: P_DESTINATION => 'G',
4199: P_SIMULATE_FLAG => p_simulate_flag,

Line 4238: P_REFERENCE_24 => 'rcv_transactions',

4234: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4235: P_ACCOUNTING_DATE => lv_accounting_date,
4236: P_REFERENCE_10 => lv_reference10,
4237: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4238: P_REFERENCE_24 => 'rcv_transactions',
4239: P_REFERENCE_25 => 'transaction_id',
4240: P_REFERENCE_26 => to_char(p_transaction_id),
4241: P_DESTINATION => 'G',
4242: P_SIMULATE_FLAG => p_simulate_flag,

Line 4283: P_REFERENCE_24 => 'rcv_transactions',

4279: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4280: P_ACCOUNTING_DATE => lv_accounting_date,
4281: P_REFERENCE_10 => lv_reference10,
4282: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4283: P_REFERENCE_24 => 'rcv_transactions',
4284: P_REFERENCE_25 => 'transaction_id',
4285: P_REFERENCE_26 => to_char(p_transaction_id),
4286: P_DESTINATION => 'G',
4287: P_SIMULATE_FLAG => p_simulate_flag,

Line 4533: P_REFERENCE_24 => 'rcv_transactions',

4529: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4530: P_ACCOUNTING_DATE => lv_accounting_date,
4531: P_REFERENCE_10 => lv_reference10,
4532: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4533: P_REFERENCE_24 => 'rcv_transactions',
4534: P_REFERENCE_25 => 'transaction_id',
4535: P_REFERENCE_26 => to_char(p_transaction_id),
4536: P_DESTINATION => 'G',
4537: P_SIMULATE_FLAG => p_simulate_flag,

Line 4576: P_REFERENCE_24 => 'rcv_transactions',

4572: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4573: P_ACCOUNTING_DATE => lv_accounting_date,
4574: P_REFERENCE_10 => lv_reference10,
4575: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4576: P_REFERENCE_24 => 'rcv_transactions',
4577: P_REFERENCE_25 => 'transaction_id',
4578: P_REFERENCE_26 => to_char(p_transaction_id),
4579: P_DESTINATION => 'G',
4580: P_SIMULATE_FLAG => p_simulate_flag,

Line 4618: P_REFERENCE_24 => 'rcv_transactions',

4614: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4615: P_ACCOUNTING_DATE => lv_accounting_date,
4616: P_REFERENCE_10 => lv_reference10,
4617: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4618: P_REFERENCE_24 => 'rcv_transactions',
4619: P_REFERENCE_25 => 'transaction_id',
4620: P_REFERENCE_26 => to_char(p_transaction_id),
4621: P_DESTINATION => 'G',
4622: P_SIMULATE_FLAG => p_simulate_flag,

Line 4664: P_REFERENCE_24 => 'rcv_transactions',

4660: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4661: P_ACCOUNTING_DATE => lv_accounting_date,
4662: P_REFERENCE_10 => lv_reference10,
4663: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4664: P_REFERENCE_24 => 'rcv_transactions',
4665: P_REFERENCE_25 => 'transaction_id',
4666: P_REFERENCE_26 => to_char(p_transaction_id),
4667: P_DESTINATION => 'G',
4668: P_SIMULATE_FLAG => p_simulate_flag,

Line 4707: P_REFERENCE_24 => 'rcv_transactions',

4703: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4704: P_ACCOUNTING_DATE => lv_accounting_date,
4705: P_REFERENCE_10 => lv_reference10,
4706: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4707: P_REFERENCE_24 => 'rcv_transactions',
4708: P_REFERENCE_25 => 'transaction_id',
4709: P_REFERENCE_26 => to_char(p_transaction_id),
4710: P_DESTINATION => 'G',
4711: P_SIMULATE_FLAG => p_simulate_flag,

Line 4750: P_REFERENCE_24 => 'rcv_transactions',

4746: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4747: P_ACCOUNTING_DATE => lv_accounting_date,
4748: P_REFERENCE_10 => lv_reference10,
4749: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4750: P_REFERENCE_24 => 'rcv_transactions',
4751: P_REFERENCE_25 => 'transaction_id',
4752: P_REFERENCE_26 => to_char(p_transaction_id),
4753: P_DESTINATION => 'G',
4754: P_SIMULATE_FLAG => p_simulate_flag,

Line 4897: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

4893:
4894: r_trx c_trx%ROWTYPE;
4895: r_base_trx c_base_trx%ROWTYPE;
4896: lv_validation_message VARCHAR2(100);
4897: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
4898:
4899: lv_include_cenvat_in_cost VARCHAR2(5);
4900:
4901: CURSOR c_rg23_part_ii_chk(cp_transaction_id IN NUMBER) IS

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:

Line 6213: from rcv_transactions

6209: cursor c_po_dist_accrual_accnt_id(cp_transaction_id in number) is
6210: select accrual_account_id
6211: from po_distributions_all a,
6212: ( select po_line_location_id
6213: from rcv_transactions
6214: where transaction_id = cp_transaction_id) b
6215: where a.line_location_id = b.po_line_location_id;
6216:
6217: cursor c_mtl_ap_accrual_accnt_id(cp_organization_id in number) is

Line 6491: lv_reference24 := 'rcv_transactions';

6487: lv_acct_nature := 'CENVAT-SSI';
6488: lv_accounting_date := trunc(sysdate);
6489:
6490: lv_reference23 := 'JAINRTVN';
6491: lv_reference24 := 'rcv_transactions';
6492: lv_reference25 := 'transaction_id';
6493: lv_reference26 := to_char(r_trx.transaction_id);
6494:
6495: lv_statement_id := '16';

Line 6530: p_reference_24 => lv_reference24, --'rcv_transactions',

6526: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6527: p_accounting_date => lv_accounting_date,
6528: p_reference_10 => lv_reference10,
6529: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6530: p_reference_24 => lv_reference24, --'rcv_transactions',
6531: p_reference_25 => lv_reference25, --'transaction_id',
6532: p_reference_26 => lv_reference26, --
6533: p_destination => 'G',
6534: p_simulate_flag => lv_simulate_flag,

Line 6564: p_reference_24 => lv_reference24, --'rcv_transactions',

6560: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6561: p_accounting_date => lv_accounting_date,
6562: p_reference_10 => lv_reference10,
6563: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6564: p_reference_24 => lv_reference24, --'rcv_transactions',
6565: p_reference_25 => lv_reference25, --'transaction_id',
6566: p_reference_26 => lv_reference26, --
6567: p_destination => 'G',
6568: p_simulate_flag => lv_simulate_flag,

Line 6617: p_reference_24 => lv_reference24, --'rcv_transactions',

6613: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6614: p_accounting_date => lv_accounting_date,
6615: p_reference_10 => lv_reference10,
6616: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6617: p_reference_24 => lv_reference24, --'rcv_transactions',
6618: p_reference_25 => lv_reference25, --'transaction_id',
6619: p_reference_26 => lv_reference26, --
6620: p_destination => 'G',
6621: p_simulate_flag => lv_simulate_flag,

Line 6651: p_reference_24 => lv_reference24, --'rcv_transactions',

6647: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6648: p_accounting_date => lv_accounting_date,
6649: p_reference_10 => lv_reference10,
6650: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6651: p_reference_24 => lv_reference24, --'rcv_transactions',
6652: p_reference_25 => lv_reference25, --'transaction_id',
6653: p_reference_26 => lv_reference26, --
6654: p_destination => 'G',
6655: p_simulate_flag => lv_simulate_flag,

Line 6707: p_reference_24 => lv_reference24, --'rcv_transactions',

6703: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6704: p_accounting_date => lv_accounting_date,
6705: p_reference_10 => lv_reference10,
6706: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6707: p_reference_24 => lv_reference24, --'rcv_transactions',
6708: p_reference_25 => lv_reference25, --'transaction_id',
6709: p_reference_26 => lv_reference26, --
6710: p_destination => 'G',
6711: p_simulate_flag => lv_simulate_flag,

Line 6741: p_reference_24 => lv_reference24, --'rcv_transactions',

6737: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6738: p_accounting_date => lv_accounting_date,
6739: p_reference_10 => lv_reference10,
6740: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6741: p_reference_24 => lv_reference24, --'rcv_transactions',
6742: p_reference_25 => lv_reference25, --'transaction_id',
6743: p_reference_26 => lv_reference26, --
6744: p_destination => 'G',
6745: p_simulate_flag => lv_simulate_flag,

Line 6786: FROM jai_rcv_line_taxes jrt,rcv_transactions rt,

6782: )
6783: IS
6784: CURSOR c_get_tax_rounding_factor(cp_transaction_id NUMBER) IS
6785: SELECT jt.tax_id,jt.tax_name,nvl(jt.ROUNDING_FACTOR,0) rf,jt.tax_type
6786: FROM jai_rcv_line_taxes jrt,rcv_transactions rt,
6787: jai_cmn_taxes_all jt
6788: WHERE jrt.shipment_line_id = rt.shipment_line_id
6789: AND jrt.shipment_header_id = rt.shipment_header_id
6790: AND jt.tax_id = jrt.tax_id