1 PACKAGE JA_JAINST3_XMLP_PKG AS
2 /* $Header: JAINST3S.pls 120.1 2007/12/25 16:29:23 dwkrishn noship $ */
3 PRM_RGM_PRIM_REGNO VARCHAR2(240);
4 PRM_FROMDT DATE;
5 PRM_ORG_ID NUMBER;
6 PRM_TODT DATE;
7 P_CONC_REQUEST_ID NUMBER;
8 PRM_SERVICE_TYPE VARCHAR2(30);
9 P_REGIME NUMBER;
10 CP_SERVICE_CESS_AMOUNT NUMBER;
11 CP_INVOICE_DATE DATE;
12 CP_ST_SERVICE_CESS_AMOUNT NUMBER := 0;
13 CP_CREDIT_AVAILED NUMBER;
14 CP_EDUCESS_CREDIT_AVAILED NUMBER;
15 PRM_FROMDT1 varchar2(20);
16 PRM_TODT1 varchar2(10);
17 FUNCTION CF_REALISED_AMOUNTFORMULA(TAX_AMOUNT IN NUMBER
18 ,RECOVERED_AMOUNT IN NUMBER
19 ,CHARGED_BILLED IN NUMBER) RETURN NUMBER;
20 FUNCTION CF_1FORMULA RETURN CHAR;
21 FUNCTION CF_2FORMULA RETURN CHAR;
22 FUNCTION CF_SERVICEFORMULA(MONTH IN VARCHAR2
23 ,YEAR IN VARCHAR2) RETURN NUMBER;
24 FUNCTION CF_INVOICE_NUMFORMULA(MONTH IN VARCHAR2
25 ,YEAR IN VARCHAR2) RETURN VARCHAR2;
26 FUNCTION CF_ST_SERVICE_AMOUNTFORMULA(MONTH IN VARCHAR2
27 ,YEAR IN VARCHAR2) RETURN NUMBER;
28 FUNCTION CF_RETURN_NULL RETURN CHAR;
29 FUNCTION CF_OPENING_BALANCEFORMULA(MONTH1 IN VARCHAR2
30 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
31 FUNCTION CF_CREDIT_AVAILEDFORMULA(MONTH1 IN VARCHAR2
32 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
33 FUNCTION CF_CREDIT_RECEIVEDFORMULA(MONTH1 IN VARCHAR2
34 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
35 FUNCTION CF_CREDIT_UTILIZEDFORMULA(MONTH1 IN VARCHAR2
36 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
37 FUNCTION CF_CREDIT_INPUT_SERVICESFORMUL(MONTH1 IN VARCHAR2
38 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
39 FUNCTION CF_TOTAL_CREDITFORMULA(CF_CREDIT_AVAILED IN NUMBER
40 ,CF_CREDIT_RECEIVED IN NUMBER) RETURN NUMBER;
41 FUNCTION CF_CLOSING_BALANCEFORMULA(CF_OPENING_BALANCE IN NUMBER
42 ,CF_TOTAL_CREDIT IN NUMBER
43 ,CF_CREDIT_UTILIZED IN NUMBER) RETURN NUMBER;
44 FUNCTION CF_EDUCESS_OPENING_BALANCEFORM(MONTH1 IN VARCHAR2
45 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
46 FUNCTION CF_EDUCESS_CREDIT_AVAILEDFORMU(MONTH1 IN VARCHAR2
47 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
48 FUNCTION CF_EDUCESS_CLOSING_BALANCEFORM(CF_EDUCESS_OPENING_BALANCE IN NUMBER
49 ,CF_CREDIT_UTILIZED IN NUMBER) RETURN NUMBER;
50 FUNCTION CF_CCRD_ST_DISTRIBUTEDFORMULA(MONTH1 IN VARCHAR2
51 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
52 FUNCTION CF_CCRD_CLOSING_BALANCEFORMULA(CF_OPENING_BALANCE IN NUMBER
53 ,CF_TOTAL_CREDIT IN NUMBER
54 ,CF_CCRD_ST_DISTRIBUTED IN NUMBER) RETURN NUMBER;
55 FUNCTION CF_ECRD_EC_DISTRIBUTEDFORMULA(MONTH1 IN VARCHAR2
56 ,YEAR1 IN VARCHAR2) RETURN NUMBER;
57 FUNCTION CF_ECRD_EC_RECEIVEDFORMULA(CF_EDUCESS_CREDIT_AVAILED IN NUMBER) RETURN NUMBER;
58 FUNCTION CF_ECRD_CLOSING_BALANCEFORMULA(CF_EDUCESS_OPENING_BALANCE IN NUMBER
59 ,CF_ECRD_EC_RECEIVED IN NUMBER
60 ,CF_ECRD_EC_DISTRIBUTED IN NUMBER) RETURN NUMBER;
61 FUNCTION CF_GET_SERVICE_TYPE(LPN_REFERENCE_ID IN NUMBER) RETURN VARCHAR2;
62 FUNCTION BEFOREREPORT RETURN BOOLEAN;
63 FUNCTION CF_COUNTFORMULA(CS_COUNT IN NUMBER) RETURN NUMBER;
64 FUNCTION CF_COUNT_RECORDSFORMULA(CS_COUNT_RECORDS IN NUMBER) RETURN NUMBER;
65 FUNCTION CF_EDUCESS_SERVICESFORMULA RETURN CHAR;
66 FUNCTION CF_CCRD_ELIGIBLEFORMULA RETURN CHAR;
67 FUNCTION CF_ECRD_ELIGIBLEFORMULA RETURN CHAR;
68 FUNCTION CF_1FORMULA0012(CS_1 IN NUMBER) RETURN NUMBER;
69 FUNCTION CF_SERVICE_TYPE_DESCFORMULA(SERVICE_TYPE_CODE IN VARCHAR2) RETURN CHAR;
70 FUNCTION CP_SERVICE_CESS_AMOUNT_P RETURN NUMBER;
71 FUNCTION CP_INVOICE_DATE_P RETURN DATE;
72 FUNCTION CP_ST_SERVICE_CESS_AMOUNT_P RETURN NUMBER;
73 FUNCTION CP_CREDIT_AVAILED_P RETURN NUMBER;
74 FUNCTION CP_EDUCESS_CREDIT_AVAILED_P RETURN NUMBER;
75 END JA_JAINST3_XMLP_PKG;
76
77