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,
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,
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,
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,
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
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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