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_CMN_RG_23AC_II_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 6: FROM JAI_CMN_RG_23AC_II_TRXS

2: /* $Header: jai_cmn_rg_23p2.pls 120.5 2006/11/03 11:52:20 sacsethi ship $ */
3:
4: CURSOR c_get_last_record(cp_register_id IN NUMBER) IS
5: SELECT slno, opening_balance, closing_balance, fin_year
6: FROM JAI_CMN_RG_23AC_II_TRXS
7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,

Line 10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,

6: FROM JAI_CMN_RG_23AC_II_TRXS
7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,

Line 11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,

7: WHERE register_id = cp_register_id;
8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,

Line 12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,

8:
9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,

Line 13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,

9: PROCEDURE insert_row(
10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,

10: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,

Line 15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,

11: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,

Line 16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,

12: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,

Line 17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

13: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,

14: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,

Line 19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,

15: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,

Line 20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,

16: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,

Line 21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

17: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,

Line 22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,

18: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,

Line 23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,

19: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,

Line 24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,

20: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,

Line 25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,

21: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,

Line 26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,

22: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,

Line 27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,

23: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,

Line 28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,

24: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,

Line 29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,

25: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,

Line 30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,

26: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,

Line 31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,

27: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,

Line 32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,

28: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,

Line 33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,

29: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

Line 34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,

30: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,

Line 35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,

31: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,
39: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,

Line 36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,

32: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,
39: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,
40: p_transaction_type IN VARCHAR2,

Line 38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,

34: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,
39: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,
40: p_transaction_type IN VARCHAR2,
41: P_TRANSACTION_SOURCE IN VARCHAR2,
42: P_CALLED_FROM IN VARCHAR2,

Line 39: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,

35: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,
39: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,
40: p_transaction_type IN VARCHAR2,
41: P_TRANSACTION_SOURCE IN VARCHAR2,
42: P_CALLED_FROM IN VARCHAR2,
43: P_SIMULATE_FLAG IN VARCHAR2,

Line 50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,

46: P_ADDITIONAL_CVD IN NUMBER DEFAULT NULL -- Harshita for bug 5096787
47: );
48:
49: PROCEDURE update_row(
50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,

Line 51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,

47: );
48:
49: PROCEDURE update_row(
50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,

Line 52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,

48:
49: PROCEDURE update_row(
50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,

Line 53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,

49: PROCEDURE update_row(
50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,

Line 54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,

50: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,

Line 55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,

51: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,

Line 56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,

52: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,

Line 57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,

53: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,

Line 58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,

54: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,

55: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,

Line 60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,

56: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,

Line 61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,

57: P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,

Line 62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

58: P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,

59: P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,

Line 64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,

60: P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

Line 65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,

61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

Line 66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI

62: P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,

Line 67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,

63: P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,

Line 68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

64: P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,

Line 69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

65: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,

Line 70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,

66: P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,

Line 71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,

67: P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,

Line 72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,

68: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,

Line 73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,

69: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,

Line 74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,

70: P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,

Line 75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,

71: P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,

Line 76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,

72: P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,

Line 77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,

73: P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,

Line 78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,

74: P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,

Line 79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,

75: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,

Line 80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,

76: P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,

Line 81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,

77: P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,

Line 82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,

78: P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

Line 83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,

79: P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,

Line 84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,

80: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,
88: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,

Line 85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,

81: P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82: P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,
88: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,
89: P_SIMULATE_FLAG IN VARCHAR2,

Line 87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,

83: P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,
88: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,
89: P_SIMULATE_FLAG IN VARCHAR2,
90: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
91: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,

Line 88: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,

84: P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85: P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,
88: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,
89: P_SIMULATE_FLAG IN VARCHAR2,
90: P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
91: P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,
92: P_ADDITIONAL_CVD IN NUMBER DEFAULT NULL -- Harshita for bug 5096787