PACKAGE: APPS.JA_JAINRGCR_XMLP_PKG

Source

1 PACKAGE JA_JAINRGCR_XMLP_PKG AS
2 /* $Header: JAINRGCRS.pls 120.1 2007/12/25 16:28:21 dwkrishn noship $ */
3   P_REGM_PRMY_REGN VARCHAR2(40);
4 
5   P_FROM_DATE DATE;
6 
7   P_TO_DATE DATE;
8 
9   CP_FROM_DATE VARCHAR2(40);
10 
11   CP_TO_DATE VARCHAR2(40);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   P_ORG_WHERE VARCHAR2(2000);
16 
17   P_REPORTING_ENTITY_ID NUMBER;
18 
19   P_REPORTING_LEVEL VARCHAR2(30);
20 
21   FUNCTION BEFOREREPORT RETURN BOOLEAN;
22 
23   FUNCTION CF_CREDIT_TAKENFORMULA(CS_SERVICE_CREDIT IN NUMBER
24                                  ,CS_EDU_CREDIT IN NUMBER) RETURN NUMBER;
25 
26   FUNCTION CF_CREDIT_UTILIZEDFORMULA RETURN NUMBER;
27 
28   FUNCTION CF_CLOSING_BALFORMULA(CF_OPENING_BAL IN NUMBER
29                                 ,CF_CREDIT_TAKEN IN NUMBER
30                                 ,CF_CREDIT_UTILIZED IN NUMBER) RETURN NUMBER;
31 
32   FUNCTION CF_OPENING_BALFORMULA RETURN NUMBER;
33 
34   FUNCTION AFTERPFORM RETURN BOOLEAN;
35 
36   FUNCTION AFTERREPORT RETURN BOOLEAN;
37 
38   FUNCTION CF_SERVICE_TYPEFORMULA(SERVICE_TYPE_CODE IN VARCHAR2) RETURN CHAR;
39 
40   FUNCTION CF_VALUEFORMULA(INVOICE_ID IN NUMBER
41                           ,SOURCE_TYPE IN VARCHAR2
42                           ,ST_RATE IN NUMBER
43                           ,ST IN NUMBER
44                           ,VALUE IN NUMBER) RETURN NUMBER;
45 
46   FUNCTION CF_DESCRIPTIONFORMULA(SRC_DOC_ID IN NUMBER
47                                 ,ITEM_ID IN NUMBER
48                                 ,SOURCE_TYPE IN VARCHAR2) RETURN CHAR;
49 
50   LV_TAX_TYPE_SERVICE CONSTANT VARCHAR2(15) DEFAULT 'Service';
51 
52   LV_TAX_TYPE_SERVICE_EDU_CESS CONSTANT VARCHAR2(30) DEFAULT 'SERVICE_EDUCATION_CESS';
53 
54   LV_TAX_TYPE_SH_SER_EDU_CESS CONSTANT VARCHAR2(30) DEFAULT 'SERVICE_SH_EDU_CESS';
55 
56   LV_SERVICE_REGIME CONSTANT VARCHAR2(15) DEFAULT 'SERVICE';
57 
58   LV_SERVICE_SRC_DISTRIBUTE_OUT CONSTANT VARCHAR2(30) DEFAULT 'SERVICE_DISTRIBUTE_OUT';
59 
60   LV_SERVICE_SRC_DISTRIBUTE_IN CONSTANT VARCHAR2(30) DEFAULT 'SERVICE_DISTRIBUTE_IN';
61 
62   LV_RECOVERY CONSTANT VARCHAR2(20) DEFAULT 'RECOVERY';
63 
64   LV_LIABILITY CONSTANT VARCHAR2(20) DEFAULT 'LIABILITY';
65 
66   LV_ADJUST_RECOVERY CONSTANT VARCHAR2(20) DEFAULT 'ADJUSTMENT-RECOVERY';
67 
68   LV_ADJUST_LIABILITY CONSTANT VARCHAR2(20) DEFAULT 'ADJUSTMENT-LIABILITY';
69 
70   LV_OTH_REG_TYPE CONSTANT VARCHAR2(30) DEFAULT 'OTHERS';
71 
72   LV_PRIM_ATT_TYPE_CODE CONSTANT VARCHAR2(30) DEFAULT 'PRIMARY';
73 
74   LV_SERVICE_ATT_CODE CONSTANT VARCHAR2(30) DEFAULT 'SERVICE_TAX_REGISTRATION_NO';
75 
76 END JA_JAINRGCR_XMLP_PKG;
77 
78