DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;

1336: ln_debit_amount NUMBER;
1337: lv_excise_cess CONSTANT varchar2(30) := 'EXCISE-CESS'; --rchandan for bug#4428980
1338: /*Added by CSahoo, BUG#5073553*/
1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;

Line 1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;

1337: lv_excise_cess CONSTANT varchar2(30) := 'EXCISE-CESS'; --rchandan for bug#4428980
1338: /*Added by CSahoo, BUG#5073553*/
1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;

Line 1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;

1338: /*Added by CSahoo, BUG#5073553*/
1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
1346:

Line 2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,

2038: -- added, Harshita for Bug 5096787
2039: PROCEDURE create_io_register_entry (
2040: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
2041: p_tax_type IN VARCHAR2 ,
2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,

Line 2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,

2039: PROCEDURE create_io_register_entry (
2040: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
2041: p_tax_type IN VARCHAR2 ,
2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,

Line 2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,

2040: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
2041: p_tax_type IN VARCHAR2 ,
2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,

Line 2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,

2041: p_tax_type IN VARCHAR2 ,
2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,

Line 2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,

2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,

Line 2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,

2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,

Line 2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,

2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,
2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,

Line 2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,

2045: p_cr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE ,
2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,

Line 2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,

2046: p_cr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE ,
2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,

Line 2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,

2047: p_dr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE ,
2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,

Line 2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,

2048: p_dr_additional_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE ,
2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,

Line 2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,

2049: p_dr_other_ed IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE ,
2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,

Line 2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,

2050: p_excise_invoice_no IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE ,
2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
2058: p_transaction_type IN VARCHAR2 ,

Line 2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,

2051: p_remarks IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE ,
2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
2058: p_transaction_type IN VARCHAR2 ,
2059: p_transaction_source IN VARCHAR2 ,

Line 2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,

2052: p_vendor_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE ,
2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
2058: p_transaction_type IN VARCHAR2 ,
2059: p_transaction_source IN VARCHAR2 ,
2060: p_called_from IN VARCHAR2 ,

Line 2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,

2053: p_vendor_site_id IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE ,
2054: p_transaction_date IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE ,
2055: p_charge_account_id IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE ,
2056: p_other_tax_credit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE ,
2057: p_other_tax_debit IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE ,
2058: p_transaction_type IN VARCHAR2 ,
2059: p_transaction_source IN VARCHAR2 ,
2060: p_called_from IN VARCHAR2 ,
2061: p_simulate_flag IN VARCHAR2 ,

Line 2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,

2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,

Line 2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,

2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,

Line 2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,

2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,

Line 2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,

2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,

Line 2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,

2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,

Line 2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,

2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,

Line 2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,

2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,

Line 2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,

2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,
2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,

Line 2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,

2070: p_customer_id IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE Default NULL ,
2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,