1 PACKAGE jai_cmn_rg_pla_trxs_pkg 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
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,
11 pref_rg23a, pref_rg23c, pref_pla, excise_in_rg23d, excise_23d_account, excise_rcvble_account
12 FROM JAI_CMN_INVENTORY_ORGS
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,
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,
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,
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,
49 P_PROCESS_STATUS OUT NOCOPY VARCHAR2,
50 P_PROCESS_MESSAGE OUT NOCOPY VARCHAR2,
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,
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,
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,
77 P_VENDOR_ID IN JAI_CMN_RG_PLA_TRXS.vendor_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,
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,
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(
96 p_register_id IN NUMBER,
97 p_charge_account_id IN NUMBER
98 );
99
100 FUNCTION get_trxn_entry_cnt(
101 p_organization_id IN NUMBER,
102 p_location_id IN NUMBER,
103 p_inventory_item_id IN NUMBER,
104 p_ref_document_id IN NUMBER,
105 p_transaction_id IN NUMBER
106 ) RETURN NUMBER;
107
108 PROCEDURE get_trxn_type_and_id(
109 p_transaction_type IN OUT NOCOPY VARCHAR2,
110 p_transaction_source IN VARCHAR2,
111 p_transaction_id OUT NOCOPY NUMBER
112 );
113
114 PROCEDURE generate_component_balances(
115 errbuf VARCHAR2,
116 retcode VARCHAR2
117 );
118
119 END jai_cmn_rg_pla_trxs_pkg;