PACKAGE: APPS.JA_JAINDTBR_XMLP_PKG

Source

1 PACKAGE JA_JAINDTBR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINDTBRS.pls 120.1 2007/12/25 16:17:25 dwkrishn noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_CUSTOMER_ID NUMBER;
6 
7   P_CUSTOMER_TYPE VARCHAR2(30);
8 
9   P_START_DATE DATE;
10 
11   P_START_DATE1 VARCHAR2(30);
12 
13   P_END_DATE1 DATE;
14 
15   P_CUSTOMER_ID2 NUMBER;
16 
17   P_CONC_REQUEST_ID NUMBER;
18 
19   FUNC_OPEN_BAL NUMBER;
20 
21   ADD1 VARCHAR2(60);
22 
23   ADD2 VARCHAR2(60);
24 
25   ADD3 VARCHAR2(60);
26 
27   COUNTRY VARCHAR2(60);
28 
29   LOC_NAME VARCHAR2(60);
30 
31   FUNCTION BEFOREPFORM RETURN BOOLEAN;
32 
33   FUNCTION OPEN_BAL_TRFORMULA(P_CUSTOMER_ID IN NUMBER
34                              ,P_CURR_CODE IN VARCHAR2) RETURN NUMBER;
35 
36   FUNCTION FUNC_OPEN_BALFORMULA RETURN NUMBER;
37 
38   FUNCTION CF_1FORMULA0040 RETURN VARCHAR2;
39 
40   FUNCTION P_CUSTOMER_TYPEVALIDTRIGGER RETURN BOOLEAN;
41 
42   FUNCTION P_CUSTOMER_IDVALIDTRIGGER RETURN BOOLEAN;
43 
44   FUNCTION P_CUSTOMER_ID2VALIDTRIGGER RETURN BOOLEAN;
45 
46   FUNCTION AFTERPFORM RETURN BOOLEAN;
47 
48   FUNCTION BEFOREREPORT RETURN BOOLEAN;
49 
50   FUNCTION AFTERREPORT RETURN BOOLEAN;
51 
52   FUNCTION FUNC_OPEN_BAL_P RETURN NUMBER;
53 
54   FUNCTION ADD1_P RETURN VARCHAR2;
55 
56   FUNCTION ADD2_P RETURN VARCHAR2;
57 
58   FUNCTION ADD3_P RETURN VARCHAR2;
59 
60   FUNCTION COUNTRY_P RETURN VARCHAR2;
61 
62   FUNCTION LOC_NAME_P RETURN VARCHAR2;
63 
64   V_LAST_PAGE VARCHAR2(1) := 'F';
65 
66   LAST_PAGE NUMBER := 0;
67 
68   VALIDATION_FLAG VARCHAR2(1) := 'N';
69 
70   PREV_PAGE NUMBER := 0;
71 
72 END JA_JAINDTBR_XMLP_PKG;
73 
74