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

869:
870: r_trx c_trx%ROWTYPE;
871: r_base_trx c_base_trx%ROWTYPE;
872: r_orgn_info c_orgn_info%ROWTYPE;
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;

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

1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
1859: r_parent_base_trx c_base_trx%ROWTYPE;
1860:
1861: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
1859: r_parent_base_trx c_base_trx%ROWTYPE;
1860:
1861: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
1862: ln_basic_ed NUMBER;

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

2073: r_base_trx c_base_trx%ROWTYPE;
2074: r_po_header c_po_header%ROWTYPE;
2075:
2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2074: r_po_header c_po_header%ROWTYPE;
2075:
2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2084: r_parent_base_trx c_base_trx%ROWTYPE;
2085:

Line 2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2084: r_parent_base_trx c_base_trx%ROWTYPE;
2085:
2086: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2084: r_parent_base_trx c_base_trx%ROWTYPE;
2085:
2086: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
2087: ln_basic_ed NUMBER;

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

2310: r_trx c_trx%ROWTYPE;
2311: r_base_trx c_base_trx%ROWTYPE;
2312:
2313: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2314: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2315: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2316: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2317: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2318: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;

Line 2315: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2311: r_base_trx c_base_trx%ROWTYPE;
2312:
2313: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2314: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2315: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2316: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2317: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2318: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2319: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 2319: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2315: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2316: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2317: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2318: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2319: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2320: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2321: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2322: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2323: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2321: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2317: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2318: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2319: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2320: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2321: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2322: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2323: r_parent_base_trx c_base_trx%ROWTYPE;
2324:
2325: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;

Line 2322: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2318: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2319: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2320: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2321: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2322: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2323: r_parent_base_trx c_base_trx%ROWTYPE;
2324:
2325: ln_entry_type NUMBER; --File.Sql.35 Cbabu := 1;
2326: ln_basic_ed NUMBER;

Line 2336: ln_ancestor_trxn_id RCV_TRANSACTIONS.transaction_id%TYPE;

2332: ln_quantity_received NUMBER;
2333: ln_qty_to_adjust NUMBER;
2334:
2335: ln_ancestor_reg_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2336: ln_ancestor_trxn_id RCV_TRANSACTIONS.transaction_id%TYPE;
2337:
2338: lv_statement_id VARCHAR2(5);
2339:
2340: ln_other_tax_debit NUMBER;

Line 2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

2682: r_base_trx c_base_trx%ROWTYPE;
2683: r_parent_trx c_trx%ROWTYPE;
2684:
2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

Line 2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2683: r_parent_trx c_trx%ROWTYPE;
2684:
2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2684:
2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;

Line 2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;

Line 2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;

2966: r_base_trx c_base_trx%ROWTYPE;
2967: r_orgn_info c_orgn_info%ROWTYPE;
2968:
2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;

2967: r_orgn_info c_orgn_info%ROWTYPE;
2968:
2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:

Line 2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;

Line 3221: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

3217: r_orgn_info c_orgn_info%ROWTYPE;
3218: r_rcv_params c_rcv_params%ROWTYPE;
3219:
3220: lv_register_type VARCHAR2(1);
3221: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3222: ln_total_excise_amt NUMBER;
3223: ln_cenvat_claimed_ptg NUMBER;
3224:
3225: lv_accnt_type JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE;

Line 3701: P_REFERENCE_24 => 'rcv_transactions',

3697: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3698: P_ACCOUNTING_DATE => lv_accounting_date,
3699: P_REFERENCE_10 => lv_reference10,
3700: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3701: P_REFERENCE_24 => 'rcv_transactions',
3702: P_REFERENCE_25 => 'transaction_id',
3703: P_REFERENCE_26 => to_char(p_transaction_id),
3704: P_DESTINATION => 'G',
3705: P_SIMULATE_FLAG => p_simulate_flag,

Line 3742: P_REFERENCE_24 => 'rcv_transactions',

3738: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3739: P_ACCOUNTING_DATE => lv_accounting_date,
3740: P_REFERENCE_10 => lv_reference10,
3741: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3742: P_REFERENCE_24 => 'rcv_transactions',
3743: P_REFERENCE_25 => 'transaction_id',
3744: P_REFERENCE_26 => to_char(p_transaction_id),
3745: P_DESTINATION => 'G',
3746: P_SIMULATE_FLAG => p_simulate_flag,

Line 3783: P_REFERENCE_24 => 'rcv_transactions',

3779: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3780: P_ACCOUNTING_DATE => lv_accounting_date,
3781: P_REFERENCE_10 => lv_reference10,
3782: P_REFERENCE_23 => 'ja_in_receipt_cenvat_rg_pkg.accounting_entries',
3783: P_REFERENCE_24 => 'rcv_transactions',
3784: P_REFERENCE_25 => 'transaction_id',
3785: P_REFERENCE_26 => to_char(p_transaction_id),
3786: P_DESTINATION => 'G',
3787: P_SIMULATE_FLAG => p_simulate_flag,

Line 3827: P_REFERENCE_24 => 'rcv_transactions',

3823: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3824: P_ACCOUNTING_DATE => lv_accounting_date,
3825: P_REFERENCE_10 => lv_reference10,
3826: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3827: P_REFERENCE_24 => 'rcv_transactions',
3828: P_REFERENCE_25 => 'transaction_id',
3829: P_REFERENCE_26 => to_char(p_transaction_id),
3830: P_DESTINATION => 'G',
3831: P_SIMULATE_FLAG => p_simulate_flag,

Line 3870: P_REFERENCE_24 => 'rcv_transactions',

3866: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3867: P_ACCOUNTING_DATE => lv_accounting_date,
3868: P_REFERENCE_10 => lv_reference10,
3869: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3870: P_REFERENCE_24 => 'rcv_transactions',
3871: P_REFERENCE_25 => 'transaction_id',
3872: P_REFERENCE_26 => to_char(p_transaction_id),
3873: P_DESTINATION => 'G',
3874: P_SIMULATE_FLAG => p_simulate_flag,

Line 3915: P_REFERENCE_24 => 'rcv_transactions',

3911: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3912: P_ACCOUNTING_DATE => lv_accounting_date,
3913: P_REFERENCE_10 => lv_reference10,
3914: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3915: P_REFERENCE_24 => 'rcv_transactions',
3916: P_REFERENCE_25 => 'transaction_id',
3917: P_REFERENCE_26 => to_char(p_transaction_id),
3918: P_DESTINATION => 'G',
3919: P_SIMULATE_FLAG => p_simulate_flag,

Line 4165: P_REFERENCE_24 => 'rcv_transactions',

4161: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4162: P_ACCOUNTING_DATE => lv_accounting_date,
4163: P_REFERENCE_10 => lv_reference10,
4164: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4165: P_REFERENCE_24 => 'rcv_transactions',
4166: P_REFERENCE_25 => 'transaction_id',
4167: P_REFERENCE_26 => to_char(p_transaction_id),
4168: P_DESTINATION => 'G',
4169: P_SIMULATE_FLAG => p_simulate_flag,

Line 4208: P_REFERENCE_24 => 'rcv_transactions',

4204: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4205: P_ACCOUNTING_DATE => lv_accounting_date,
4206: P_REFERENCE_10 => lv_reference10,
4207: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4208: P_REFERENCE_24 => 'rcv_transactions',
4209: P_REFERENCE_25 => 'transaction_id',
4210: P_REFERENCE_26 => to_char(p_transaction_id),
4211: P_DESTINATION => 'G',
4212: P_SIMULATE_FLAG => p_simulate_flag,

Line 4250: P_REFERENCE_24 => 'rcv_transactions',

4246: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4247: P_ACCOUNTING_DATE => lv_accounting_date,
4248: P_REFERENCE_10 => lv_reference10,
4249: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4250: P_REFERENCE_24 => 'rcv_transactions',
4251: P_REFERENCE_25 => 'transaction_id',
4252: P_REFERENCE_26 => to_char(p_transaction_id),
4253: P_DESTINATION => 'G',
4254: P_SIMULATE_FLAG => p_simulate_flag,

Line 4296: P_REFERENCE_24 => 'rcv_transactions',

4292: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4293: P_ACCOUNTING_DATE => lv_accounting_date,
4294: P_REFERENCE_10 => lv_reference10,
4295: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4296: P_REFERENCE_24 => 'rcv_transactions',
4297: P_REFERENCE_25 => 'transaction_id',
4298: P_REFERENCE_26 => to_char(p_transaction_id),
4299: P_DESTINATION => 'G',
4300: P_SIMULATE_FLAG => p_simulate_flag,

Line 4339: P_REFERENCE_24 => 'rcv_transactions',

4335: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4336: P_ACCOUNTING_DATE => lv_accounting_date,
4337: P_REFERENCE_10 => lv_reference10,
4338: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4339: P_REFERENCE_24 => 'rcv_transactions',
4340: P_REFERENCE_25 => 'transaction_id',
4341: P_REFERENCE_26 => to_char(p_transaction_id),
4342: P_DESTINATION => 'G',
4343: P_SIMULATE_FLAG => p_simulate_flag,

Line 4382: P_REFERENCE_24 => 'rcv_transactions',

4378: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4379: P_ACCOUNTING_DATE => lv_accounting_date,
4380: P_REFERENCE_10 => lv_reference10,
4381: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4382: P_REFERENCE_24 => 'rcv_transactions',
4383: P_REFERENCE_25 => 'transaction_id',
4384: P_REFERENCE_26 => to_char(p_transaction_id),
4385: P_DESTINATION => 'G',
4386: P_SIMULATE_FLAG => p_simulate_flag,

Line 4529: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

4525:
4526: r_trx c_trx%ROWTYPE;
4527: r_base_trx c_base_trx%ROWTYPE;
4528: lv_validation_message VARCHAR2(100);
4529: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
4530:
4531: lv_include_cenvat_in_cost VARCHAR2(5);
4532:
4533: CURSOR c_rg23_part_ii_chk(cp_transaction_id IN NUMBER) IS

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:

Line 5627: from rcv_transactions

5623: cursor c_po_dist_accrual_accnt_id(cp_transaction_id in number) is
5624: select accrual_account_id
5625: from po_distributions_all a,
5626: ( select po_line_location_id
5627: from rcv_transactions
5628: where transaction_id = cp_transaction_id) b
5629: where a.line_location_id = b.po_line_location_id;
5630:
5631: cursor c_mtl_ap_accrual_accnt_id(cp_organization_id in number) is

Line 5904: lv_reference24 := 'rcv_transactions';

5900: lv_acct_nature := 'CENVAT-SSI';
5901: lv_accounting_date := trunc(sysdate);
5902:
5903: lv_reference23 := 'JAINRTVN';
5904: lv_reference24 := 'rcv_transactions';
5905: lv_reference25 := 'transaction_id';
5906: lv_reference26 := to_char(r_trx.transaction_id);
5907:
5908: lv_statement_id := '16';

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

5939: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5940: p_accounting_date => lv_accounting_date,
5941: p_reference_10 => lv_reference10,
5942: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5943: p_reference_24 => lv_reference24, --'rcv_transactions',
5944: p_reference_25 => lv_reference25, --'transaction_id',
5945: p_reference_26 => lv_reference26, --
5946: p_destination => 'G',
5947: p_simulate_flag => lv_simulate_flag,

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

5973: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5974: p_accounting_date => lv_accounting_date,
5975: p_reference_10 => lv_reference10,
5976: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5977: p_reference_24 => lv_reference24, --'rcv_transactions',
5978: p_reference_25 => lv_reference25, --'transaction_id',
5979: p_reference_26 => lv_reference26, --
5980: p_destination => 'G',
5981: p_simulate_flag => lv_simulate_flag,

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

6026: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6027: p_accounting_date => lv_accounting_date,
6028: p_reference_10 => lv_reference10,
6029: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6030: p_reference_24 => lv_reference24, --'rcv_transactions',
6031: p_reference_25 => lv_reference25, --'transaction_id',
6032: p_reference_26 => lv_reference26, --
6033: p_destination => 'G',
6034: p_simulate_flag => lv_simulate_flag,

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

6060: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6061: p_accounting_date => lv_accounting_date,
6062: p_reference_10 => lv_reference10,
6063: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6064: p_reference_24 => lv_reference24, --'rcv_transactions',
6065: p_reference_25 => lv_reference25, --'transaction_id',
6066: p_reference_26 => lv_reference26, --
6067: p_destination => 'G',
6068: p_simulate_flag => lv_simulate_flag,

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

6116: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6117: p_accounting_date => lv_accounting_date,
6118: p_reference_10 => lv_reference10,
6119: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6120: p_reference_24 => lv_reference24, --'rcv_transactions',
6121: p_reference_25 => lv_reference25, --'transaction_id',
6122: p_reference_26 => lv_reference26, --
6123: p_destination => 'G',
6124: p_simulate_flag => lv_simulate_flag,

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

6150: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6151: p_accounting_date => lv_accounting_date,
6152: p_reference_10 => lv_reference10,
6153: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6154: p_reference_24 => lv_reference24, --'rcv_transactions',
6155: p_reference_25 => lv_reference25, --'transaction_id',
6156: p_reference_26 => lv_reference26, --
6157: p_destination => 'G',
6158: p_simulate_flag => lv_simulate_flag,