1 PACKAGE jai_cmn_rg_23ac_ii_pkg AS
2 /* $Header: jai_cmn_rg_23p2.pls 120.5 2006/11/03 11:52:20 sacsethi ship $ */
3
4 CURSOR c_get_last_record(cp_register_id IN NUMBER) IS
5 SELECT slno, opening_balance, closing_balance, fin_year
6 FROM JAI_CMN_RG_23AC_II_TRXS
7 WHERE register_id = cp_register_id;
8
9 PROCEDURE insert_row(
10 P_REGISTER_ID OUT NOCOPY JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE,
11 P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE,
12 P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE,
13 P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE,
14 P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE,
15 P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE,
16 P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE,
17 P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
18 P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE,
19 P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE,
20 P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE,
21 P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
22 P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE,
23 P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE,
24 P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE,
25 P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE,
26 P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE,
27 P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE,
28 P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE,
29 P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE,
30 P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE,
31 P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE,
32 P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE,
33 P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE,
34 P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE,
35 P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE,
36 P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE,
37 -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
38 P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE,
39 P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE,
40 p_transaction_type IN VARCHAR2,
41 P_TRANSACTION_SOURCE IN VARCHAR2,
42 P_CALLED_FROM IN VARCHAR2,
43 P_SIMULATE_FLAG IN VARCHAR2,
44 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
45 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,
46 P_ADDITIONAL_CVD IN NUMBER DEFAULT NULL -- Harshita for bug 5096787
47 );
48
49 PROCEDURE update_row(
50 P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
51 P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
52 P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
53 P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.transaction_source_num%TYPE DEFAULT NULL,
54 P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
55 P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
56 P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE DEFAULT NULL,
57 P_RECEIPT_DATE IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE DEFAULT NULL,
58 P_RANGE_NO IN JAI_CMN_RG_23AC_II_TRXS.range_no%TYPE DEFAULT NULL,
59 P_DIVISION_NO IN JAI_CMN_RG_23AC_II_TRXS.division_no%TYPE DEFAULT NULL,
60 P_CR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE DEFAULT NULL,
61 P_CR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE DEFAULT NULL,
62 P_CR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
63 P_CR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE DEFAULT NULL,
64 P_DR_BASIC_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE DEFAULT NULL,
65 P_DR_ADDITIONAL_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE DEFAULT NULL,
66 P_DR_ADDITIONAL_CVD IN JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE DEFAULT NULL, -- Date 01/11/2006 Bug 5228046 added by SACSETHI
67 P_DR_OTHER_ED IN JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE DEFAULT NULL,
68 P_EXCISE_INVOICE_NO IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE DEFAULT NULL,
69 P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
70 P_REGISTER_TYPE IN JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE DEFAULT NULL,
71 P_REMARKS IN JAI_CMN_RG_23AC_II_TRXS.remarks%TYPE DEFAULT NULL,
72 P_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_id%TYPE DEFAULT NULL,
73 P_VENDOR_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.vendor_site_id%TYPE DEFAULT NULL,
74 P_CUSTOMER_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_id%TYPE DEFAULT NULL,
75 P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE DEFAULT NULL,
76 P_LOCATION_ID IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE DEFAULT NULL,
77 P_TRANSACTION_DATE IN JAI_CMN_RG_23AC_II_TRXS.transaction_date%TYPE DEFAULT NULL,
78 P_OPENING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.opening_balance%TYPE DEFAULT NULL,
79 P_CLOSING_BALANCE IN JAI_CMN_RG_23AC_II_TRXS.closing_balance%TYPE DEFAULT NULL,
80 P_CHARGE_ACCOUNT_ID IN JAI_CMN_RG_23AC_II_TRXS.charge_account_id%TYPE DEFAULT NULL,
81 P_REGISTER_ID_PART_I IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE DEFAULT NULL,
82 P_POSTED_FLAG IN JAI_CMN_RG_23AC_II_TRXS.posted_flag%TYPE DEFAULT NULL,
83 P_MASTER_FLAG IN JAI_CMN_RG_23AC_II_TRXS.master_flag%TYPE DEFAULT NULL,
84 P_REFERENCE_NUM IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE DEFAULT NULL,
85 P_ROUNDING_ID IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE DEFAULT NULL,
86 -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
87 P_OTHER_TAX_CREDIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_credit%TYPE DEFAULT NULL,
88 P_OTHER_TAX_DEBIT IN JAI_CMN_RG_23AC_II_TRXS.other_tax_debit%TYPE DEFAULT NULL,
89 P_SIMULATE_FLAG IN VARCHAR2,
90 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
91 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,
92 P_ADDITIONAL_CVD IN NUMBER DEFAULT NULL -- Harshita for bug 5096787
93 );
94
95 PROCEDURE update_payment_details(
96 p_register_id IN NUMBER,
97 p_register_id_part_i IN NUMBER,
98 p_charge_account_id IN NUMBER
99 );
100
101 FUNCTION get_trxn_entry_cnt(
102 p_register_type IN VARCHAR2,
103 p_organization_id IN NUMBER,
104 p_location_id IN NUMBER,
105 p_inventory_item_id IN NUMBER,
106 p_receipt_id IN VARCHAR2,
107 p_transaction_id IN NUMBER,
108 p_reference_num IN VARCHAR2
109 ) RETURN NUMBER;
110
111 PROCEDURE get_trxn_type_and_id(
112 p_transaction_type IN OUT NOCOPY VARCHAR2,
113 p_transaction_source IN VARCHAR2,
114 p_transaction_id OUT NOCOPY NUMBER
115 );
116
117 PROCEDURE generate_component_balances
118 (
119 errbuf VARCHAR2,
120 retcode VARCHAR2
121 );
122
123 END jai_cmn_rg_23ac_ii_pkg;