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 BODY jai_cmn_rg_pla_trxs_pkg AS

1: PACKAGE BODY jai_cmn_rg_pla_trxs_pkg AS
2: /* $Header: jai_cmn_rg_pla.plb 120.4 2007/08/07 07:46:46 vkaranam ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 18: Issue : In the insert into the JAI_CMN_RG_PLA_TRXS , register_id

14: 14/07/2005 4485801 Brathod, File Version 117.1
15: Issue: Inventory Convergence Uptake for R12 Initiative
16:
17: 28/12/2005 4892111 Hjujjuru, File Version 120.2
18: Issue : In the insert into the JAI_CMN_RG_PLA_TRXS , register_id
19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring
20: out.
21:
22: Fix : Created a cursor to retrieve the register_id value from the

Line 19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring

15: Issue: Inventory Convergence Uptake for R12 Initiative
16:
17: 28/12/2005 4892111 Hjujjuru, File Version 120.2
18: Issue : In the insert into the JAI_CMN_RG_PLA_TRXS , register_id
19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring
20: out.
21:
22: Fix : Created a cursor to retrieve the register_id value from the
23: sequence and inserted the same into the JAI_CMN_RG_PLA_TRXS table

Line 23: sequence and inserted the same into the JAI_CMN_RG_PLA_TRXS table

19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring
20: out.
21:
22: Fix : Created a cursor to retrieve the register_id value from the
23: sequence and inserted the same into the JAI_CMN_RG_PLA_TRXS table
24:
25: 24/04/2007 Vijay Shankar for Bug# 6012570(5876390), Version:120.3 (115.7)
26: FP: Modified the code in get_trxn_type_and_id to return a transaction_id for Projects Billing
27:

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

32: */
33:
34: PROCEDURE insert_row(
35:
36: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,

Line 37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,

33:
34: PROCEDURE insert_row(
35:
36: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,

Line 38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,

34: PROCEDURE insert_row(
35:
36: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,

Line 39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,

35:
36: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,

Line 40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,

36: P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_PLA_TRXS.register_id%TYPE,
37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,

Line 41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,

37: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE,
38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,

Line 42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,

38: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE,
39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,

Line 43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,

39: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE,
40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,

Line 44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,

40: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE,
41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,

Line 45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,

41: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE,
42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,

Line 46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,

42: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE,
43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,

Line 47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,

43: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE,
44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,

Line 48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,

44: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE,
45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,

Line 49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,

45: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE,
46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,

Line 50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,

46: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE,
47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,

Line 51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,

47: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE,
48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,

Line 52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,

48: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE,
49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,

Line 53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,

49: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE,
50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,

Line 54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,

50: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE,
51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,

Line 55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,

51: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE,
52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,

Line 56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,

52: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE,
53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,

Line 57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,

53: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE,
54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

Line 58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,

54: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE,
55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,

Line 59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,

55: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE,
56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
63: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,

Line 60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,

56: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE,
57: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE,
58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
63: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
64: p_transaction_type IN VARCHAR2,

Line 62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,

58: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE,
59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
63: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
64: p_transaction_type IN VARCHAR2,
65: p_transaction_source IN VARCHAR2,
66: p_called_from IN VARCHAR2,

Line 63: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,

59: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE,
60: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE,
61: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
62: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE,
63: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE,
64: p_transaction_type IN VARCHAR2,
65: p_transaction_source IN VARCHAR2,
66: p_called_from IN VARCHAR2,
67: P_SIMULATE_FLAG IN VARCHAR2,

Line 88: lv_range JAI_CMN_RG_PLA_TRXS.range_no%TYPE;

84: ln_closing_balance NUMBER;
85: ln_tr_amount NUMBER;
86:
87: ln_fin_year NUMBER(4);
88: lv_range JAI_CMN_RG_PLA_TRXS.range_no%TYPE;
89: lv_division JAI_CMN_RG_PLA_TRXS.division_no%TYPE;
90: lv_master_flag JAI_CMN_RG_PLA_TRXS.master_flag%TYPE;
91:
92: r_last_record c_get_last_record%ROWTYPE;

Line 89: lv_division JAI_CMN_RG_PLA_TRXS.division_no%TYPE;

85: ln_tr_amount NUMBER;
86:
87: ln_fin_year NUMBER(4);
88: lv_range JAI_CMN_RG_PLA_TRXS.range_no%TYPE;
89: lv_division JAI_CMN_RG_PLA_TRXS.division_no%TYPE;
90: lv_master_flag JAI_CMN_RG_PLA_TRXS.master_flag%TYPE;
91:
92: r_last_record c_get_last_record%ROWTYPE;
93: r_orgn_info c_orgn_info%ROWTYPE;

Line 90: lv_master_flag JAI_CMN_RG_PLA_TRXS.master_flag%TYPE;

86:
87: ln_fin_year NUMBER(4);
88: lv_range JAI_CMN_RG_PLA_TRXS.range_no%TYPE;
89: lv_division JAI_CMN_RG_PLA_TRXS.division_no%TYPE;
90: lv_master_flag JAI_CMN_RG_PLA_TRXS.master_flag%TYPE;
91:
92: r_last_record c_get_last_record%ROWTYPE;
93: r_orgn_info c_orgn_info%ROWTYPE;
94: lv_message VARCHAR2(200);

Line 102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;

98: lv_statement_id VARCHAR2(5);
99:
100: -- added, Harshita for 4892111
101: Cursor c_fetch_register_id IS
102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;
103:
104: ln_register_id jai_cmn_rg_pla_trxs.register_id%type ;
105: -- ended, Harshita for 4892111
106:

Line 104: ln_register_id jai_cmn_rg_pla_trxs.register_id%type ;

100: -- added, Harshita for 4892111
101: Cursor c_fetch_register_id IS
102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;
103:
104: ln_register_id jai_cmn_rg_pla_trxs.register_id%type ;
105: -- ended, Harshita for 4892111
106:
107: BEGIN
108:

Line 110: CHANGE HISTORY for FILENAME: jai_cmn_rg_pla_trxs_pkg.sql

106:
107: BEGIN
108:
109: /*----------------------------------------------------------------------------------------------------------------------------
110: CHANGE HISTORY for FILENAME: jai_cmn_rg_pla_trxs_pkg.sql
111: S.No dd/mm/yyyy Author and Details
112: ------------------------------------------------------------------------------------------------------------------------------
113: 1 16/07/2002 Vijay Shankar for Bug# 3496408, Version:115.0
114: Table Handler coded for PLA table. Update_row of the package was just a skeleton that needs to be modified

Line 226: INSERT INTO JAI_CMN_RG_PLA_TRXS(

222: FETCH c_fetch_register_id INTO ln_register_id ;
223: CLOSE c_fetch_register_id ;
224: -- ended, Harshita for 4892111
225:
226: INSERT INTO JAI_CMN_RG_PLA_TRXS(
227: REGISTER_ID,
228: FIN_YEAR,
229: SLNO,
230: TR6_CHALLAN_NO,

Line 277: ln_register_id, --JAI_CMN_RG_PLA_TRXS_S1.nextval, Harshita for 4892111 --P_REGISTER_ID,

273: other_tax_credit,
274: other_tax_debit,
275: rounding_id
276: ) VALUES (
277: ln_register_id, --JAI_CMN_RG_PLA_TRXS_S1.nextval, Harshita for 4892111 --P_REGISTER_ID,
278: ln_fin_year, --P_FIN_YEAR,
279: ln_slno, --P_SLNO,
280: P_TR6_CHALLAN_NO,
281: P_TR6_CHALLAN_DATE,

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

349: END insert_row;
350:
351: PROCEDURE update_row(
352:
353: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,

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

350:
351: PROCEDURE update_row(
352:
353: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,

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

351: PROCEDURE update_row(
352:
353: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,

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

352:
353: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,

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

353: P_REGISTER_ID IN JAI_CMN_RG_PLA_TRXS.register_id%TYPE DEFAULT NULL,
354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,

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

354: P_FIN_YEAR IN JAI_CMN_RG_PLA_TRXS.fin_year%TYPE DEFAULT NULL,
355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,

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

355: P_SLNO IN JAI_CMN_RG_PLA_TRXS.slno%TYPE DEFAULT NULL,
356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,

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

356: P_TR6_CHALLAN_NO IN JAI_CMN_RG_PLA_TRXS.tr6_challan_no%TYPE DEFAULT NULL,
357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,

Line 361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,

357: P_TR6_CHALLAN_DATE IN JAI_CMN_RG_PLA_TRXS.tr6_challan_date%TYPE DEFAULT NULL,
358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,

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

358: P_CR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,

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

359: P_CR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,

Line 364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,

360: P_CR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE DEFAULT NULL,
361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,

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

361: P_TRANSACTION_ID IN JAI_CMN_RG_PLA_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,

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

362: P_REF_DOCUMENT_ID IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE DEFAULT NULL,
363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,

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

363: P_REF_DOCUMENT_DATE IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE DEFAULT NULL,
364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,

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

364: P_DR_INVOICE_ID IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE DEFAULT NULL,
365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,

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

365: P_DR_INVOICE_DATE IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE DEFAULT NULL,
366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,

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

366: P_DR_BASIC_ED IN JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,

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

367: P_DR_ADDITIONAL_ED IN JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,

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

368: P_DR_OTHER_ED IN JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE DEFAULT NULL,
369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,

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

369: P_ORGANIZATION_ID IN JAI_CMN_RG_PLA_TRXS.organization_id%TYPE DEFAULT NULL,
370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,

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

370: P_LOCATION_ID IN JAI_CMN_RG_PLA_TRXS.location_id%TYPE DEFAULT NULL,
371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,

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

371: P_BANK_BRANCH_ID IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE DEFAULT NULL,
372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,

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

372: P_ENTRY_DATE IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE DEFAULT NULL,
373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,

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

373: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_PLA_TRXS.inventory_item_id%TYPE DEFAULT NULL,
374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,

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

374: P_VENDOR_CUST_FLAG IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE DEFAULT NULL,
375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,

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

375: P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_id%TYPE DEFAULT NULL,
376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,

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

376: P_VENDOR_SITE_ID IN JAI_CMN_RG_PLA_TRXS.vendor_site_id%TYPE DEFAULT NULL,
377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,

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

377: P_RANGE_NO IN JAI_CMN_RG_PLA_TRXS.range_no%TYPE DEFAULT NULL,
378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,

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

378: P_DIVISION_NO IN JAI_CMN_RG_PLA_TRXS.division_no%TYPE DEFAULT NULL,
379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,

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

379: P_EXCISE_INVOICE_NO IN JAI_CMN_RG_PLA_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement

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

380: P_REMARKS IN JAI_CMN_RG_PLA_TRXS.remarks%TYPE DEFAULT NULL,
381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
388: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,

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

381: P_TRANSACTION_DATE IN JAI_CMN_RG_PLA_TRXS.transaction_date%TYPE DEFAULT NULL,
382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
388: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
389: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,

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

382: P_OPENING_BALANCE IN JAI_CMN_RG_PLA_TRXS.opening_balance%TYPE DEFAULT NULL,
383: P_CLOSING_BALANCE IN JAI_CMN_RG_PLA_TRXS.closing_balance%TYPE DEFAULT NULL,
384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
388: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
389: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
390: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161

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

384: P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_PLA_TRXS.charge_account_id%TYPE DEFAULT NULL,
385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
388: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
389: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
390: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
391: ) IS
392:

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

385: P_POSTED_FLAG IN JAI_CMN_RG_PLA_TRXS.posted_flag%TYPE DEFAULT NULL,
386: P_MASTER_FLAG IN JAI_CMN_RG_PLA_TRXS.master_flag%TYPE DEFAULT NULL,
387: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
388: P_OTHER_TAX_CREDIT IN JAI_CMN_RG_PLA_TRXS.other_tax_credit%TYPE DEFAULT NULL,
389: P_OTHER_TAX_DEBIT IN JAI_CMN_RG_PLA_TRXS.other_tax_debit%TYPE DEFAULT NULL,
390: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
391: ) IS
392:
393: /* Added by Ramananda for bug#4407165 */

Line 394: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_pla_trxs_pkg.update_row';

390: p_rounding_id IN NUMBER default null -- Vijay Shankar for Bug#4103161
391: ) IS
392:
393: /* Added by Ramananda for bug#4407165 */
394: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_pla_trxs_pkg.update_row';
395:
396: BEGIN
397:
398: UPDATE JAI_CMN_RG_PLA_TRXS SET

Line 398: UPDATE JAI_CMN_RG_PLA_TRXS SET

394: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_pla_trxs_pkg.update_row';
395:
396: BEGIN
397:
398: UPDATE JAI_CMN_RG_PLA_TRXS SET
399: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),
400: FIN_YEAR = nvl(P_FIN_YEAR, FIN_YEAR),
401: SLNO = nvl(P_SLNO, SLNO),
402: TR6_CHALLAN_NO = nvl(P_TR6_CHALLAN_NO, TR6_CHALLAN_NO),

Line 458: UPDATE JAI_CMN_RG_PLA_TRXS

454: ) IS
455:
456: BEGIN
457:
458: UPDATE JAI_CMN_RG_PLA_TRXS
459: SET charge_account_id = p_charge_account_id,
460: last_update_date= SYSDATE
461: WHERE register_id = p_register_id;
462:

Line 476: FROM JAI_CMN_RG_PLA_TRXS

472:
473: ln_record_exist_cnt NUMBER(4);
474: CURSOR c_record_exist IS
475: SELECT count(1)
476: FROM JAI_CMN_RG_PLA_TRXS
477: WHERE organization_id = p_organization_id
478: AND location_id = p_location_id
479: AND inventory_item_id = p_inventory_item_id
480: AND ref_document_id = p_ref_document_id

Line 581: FROM JAI_CMN_RG_PLA_TRXS A

577: A.LAST_UPDATE_DATE,
578: A.LAST_UPDATED_BY,
579: A.TRANSACTION_DATE,
580: A.LAST_UPDATE_LOGIN
581: FROM JAI_CMN_RG_PLA_TRXS A
582: WHERE NOT EXISTS ( SELECT '1'
583: FROM JAI_CMN_RG_PLA_CMP_DTLS B
584: WHERE B.REGISTER_ID = A.REGISTER_ID
585: AND B.SLNO = A.SLNO)

Line 604: FILENAME: jai_cmn_rg_pla_trxs_pkg.generate_component_balances.sql

600:
601: BEGIN --B1
602:
603: /*------------------------------------------------------------------------------------------
604: FILENAME: jai_cmn_rg_pla_trxs_pkg.generate_component_balances.sql
605: CHANGE HISTORY:
606:
607: 1. 2002/07/28 Nagaraj.s - For Enh#2371031
608: This Procedure is Created for Textile Industry specifically wherin individual

Line 772: END jai_cmn_rg_pla_trxs_pkg;

768: ROLLBACK;
769: END generate_component_balances; --E1
770:
771:
772: END jai_cmn_rg_pla_trxs_pkg;