1 PACKAGE jai_cmn_rg_i_trxs_pkg AS
2 /* $Header: jai_cmn_rg_i.pls 120.2 2007/05/02 11:04:04 bduvarag ship $ */
3
4 PROCEDURE validate_rg1_balances(
5 P_ORGANIZATION_ID IN NUMBER,
6 P_LOCATION_ID IN NUMBER,
7 P_INVENTORY_ITEM_ID IN NUMBER,
8 P_FIN_YEAR IN NUMBER,
9 P_QUANTITY IN NUMBER,
10 P_TRANSACTION_UOM_CODE IN VARCHAR2,
11 P_TRANSACTION_TYPE IN VARCHAR2,
12 P_ERR_BUF OUT NOCOPY VARCHAR2
13 );
14
15 FUNCTION get_rg1_transaction_id(
16 P_TRANSACTION_TYPE IN VARCHAR2,
17 P_ISSUE_TYPE IN VARCHAR2,
18 P_CALLED_FROM IN VARCHAR2
19 ) RETURN NUMBER;
20
21 PROCEDURE create_rg1_entry(
22 P_REGISTER_ID OUT NOCOPY NUMBER,
23 P_REGISTER_ID_PART_II IN NUMBER,
24 P_FIN_YEAR IN NUMBER,
25 P_SLNO OUT NOCOPY NUMBER,
26 P_TRANSACTION_ID IN NUMBER,
27 P_ORGANIZATION_ID IN NUMBER,
28 P_LOCATION_ID IN NUMBER,
29 P_TRANSACTION_DATE IN DATE,
30 P_INVENTORY_ITEM_ID IN NUMBER,
31 P_TRANSACTION_TYPE IN VARCHAR2,
32 P_REF_DOC_ID IN VARCHAR2,
33 P_QUANTITY IN NUMBER,
34 P_TRANSACTION_UOM_CODE IN VARCHAR2,
35 P_ISSUE_TYPE IN VARCHAR2,
36 P_EXCISE_DUTY_AMOUNT IN NUMBER,
37 P_EXCISE_INVOICE_NUMBER IN VARCHAR2,
38 P_EXCISE_INVOICE_DATE IN DATE,
39 P_PAYMENT_REGISTER IN VARCHAR2,
40 P_CHARGE_ACCOUNT_ID IN NUMBER,
41 P_RANGE_NO IN VARCHAR2,
42 P_DIVISION_NO IN VARCHAR2,
43 P_REMARKS IN VARCHAR2,
44 P_BASIC_ED IN NUMBER,
45 P_ADDITIONAL_ED IN NUMBER,
46 P_OTHER_ED IN NUMBER,
47 P_ASSESSABLE_VALUE IN NUMBER,
48 P_EXCISE_DUTY_RATE IN NUMBER,
49 P_VENDOR_ID IN NUMBER,
50 P_VENDOR_SITE_ID IN NUMBER,
51 P_CUSTOMER_ID IN NUMBER,
52 P_CUSTOMER_SITE_ID IN NUMBER,
53 P_CREATION_DATE IN DATE,
54 P_CREATED_BY IN NUMBER,
55 P_LAST_UPDATE_DATE IN DATE,
56 P_LAST_UPDATED_BY IN NUMBER,
57 P_LAST_UPDATE_LOGIN IN NUMBER,
58 P_CALLED_FROM IN VARCHAR2,
59 P_CESS_AMOUNT IN NUMBER DEFAULT NULL,/*Added for the Bug
60 2942973 to resolve compilation error - bduvarag*/
61 P_SH_CESS_AMOUNT IN NUMBER DEFAULT NULL/*Bug 5989740 bduvarag*/
62 );
63
64 END jai_cmn_rg_i_trxs_pkg;