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_PLA_TRXS_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 1: PACKAGE jai_cmn_rg_pla_trxs_pkg AUTHID CURRENT_USER AS

1: PACKAGE jai_cmn_rg_pla_trxs_pkg AUTHID CURRENT_USER AS
2: /* $Header: jai_cmn_rg_pla.pls 120.1 2005/07/20 12:57:24 avallabh ship $ */
3:
4: CURSOR c_get_last_record(cp_register_id IN NUMBER) IS
5: SELECT slno, opening_balance, closing_balance, fin_year

Line 6: FROM JAI_CMN_RG_PLA_TRXS

2: /* $Header: jai_cmn_rg_pla.pls 120.1 2005/07/20 12:57:24 avallabh 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_PLA_TRXS
7: WHERE register_id = cp_register_id;
8:
9: CURSOR c_orgn_info(cp_organization_id IN NUMBER, cp_location_id IN NUMBER) IS
10: SELECT modvat_rm_account_id, modvat_cg_account_id, modvat_pla_account_id, ssi_unit_flag,

Line 17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,

13: WHERE organization_id = cp_organization_id
14: AND location_id = cp_location_id;
15:
16: PROCEDURE insert_row(
17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,

Line 18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,

14: AND location_id = cp_location_id;
15:
16: PROCEDURE insert_row(
17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,

Line 19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,

15:
16: PROCEDURE insert_row(
17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,

Line 20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,

16: PROCEDURE insert_row(
17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,

Line 21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,

17: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,

Line 22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,

18: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,

Line 23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,

19: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,

Line 24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,

20: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,

Line 25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,

21: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,

Line 26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,

22: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,

Line 27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,

23: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,

Line 28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,

24: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,

Line 29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,

25: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE,
26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,

Line 30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,

26: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,

Line 31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,

27: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,

Line 32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,

28: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,

Line 33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,

29: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,

Line 34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,

30: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,

Line 35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,

31: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,

Line 36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,

32: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,

Line 37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,

33: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,

Line 38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,

34: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

Line 39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,

35: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,

Line 40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,

36: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
44: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,

Line 41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,

37: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
38: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
44: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
45: p_transaction_type IN VARCHAR2,

Line 43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,

39: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
44: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
45: p_transaction_type IN VARCHAR2,
46: p_transaction_source IN VARCHAR2,
47: p_called_from IN VARCHAR2,

Line 44: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,

40: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
41: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
42: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
43: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
44: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
45: p_transaction_type IN VARCHAR2,
46: p_transaction_source IN VARCHAR2,
47: p_called_from IN VARCHAR2,
48: P_SIMULATE_FLAG IN VARCHAR2,

Line 55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,

51: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
52: );
53:
54: PROCEDURE update_row(
55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,

Line 56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,

52: );
53:
54: PROCEDURE update_row(
55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,

Line 57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,

53:
54: PROCEDURE update_row(
55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,

Line 58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,

54: PROCEDURE update_row(
55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,

Line 59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,

55: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,

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

56: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,

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

57: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,

Line 62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,

58: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,

Line 63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,

59: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,

Line 64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,

60: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,

Line 65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,

61: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,

Line 66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,

62: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,

Line 67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,

63: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.transaction_source_num%TYPE DEFAULT NULL,
64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,

Line 68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,

64: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,

Line 69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,

65: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,

Line 70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,

66: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.dr_invoice_no%TYPE DEFAULT NULL,
67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,

Line 71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,

67: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,

Line 72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,

68: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,

Line 73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,

69: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,

Line 74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,

70: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,

Line 75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,

71: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,

Line 76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,

72: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,

Line 77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,

73: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

Line 78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,

74: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,

Line 79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,

75: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,

Line 80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,

76: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,

Line 81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

77: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,

Line 82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,

78: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,

Line 83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,

79: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,

Line 84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,

80: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,

Line 85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,

81: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

Line 86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,

82: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,

Line 87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,

83: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
91: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,

Line 88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,

84: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
85: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
91: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
92: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161

Line 90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,

86: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
91: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
92: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
93: );
94:

Line 91: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,

87: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
88: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
89: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
90: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
91: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
92: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
93: );
94:
95: PROCEDURE update_payment_details(

Line 119: END jai_cmn_rg_pla_trxs_pkg;

115: errbuf VARCHAR2,
116: retcode VARCHAR2
117: );
118:
119: END jai_cmn_rg_pla_trxs_pkg;