PACKAGE: APPS.JL_JLCOFAAR_XMLP_PKG

Source

1 PACKAGE JL_JLCOFAAR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLCOFAARS.pls 120.1 2007/12/25 16:44:16 dwkrishn noship $ */
3   P_END_OF_REPORT VARCHAR2(21);
4 
5   P_NO_DATA_FOUND VARCHAR2(21);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_APPRAISAL_ID NUMBER;
10 
11   P_ALL_ROWS VARCHAR2(1);
12 
13   P_MIN_PRECISION NUMBER := 2;
14 
15   C_COMPANY_NAME VARCHAR2(80);
16 
17   C_STATUS VARCHAR2(50);
18 
19   CP_VALID_CURR_CODE NUMBER;
20 
21   FUNCTION BEFOREREPORT RETURN BOOLEAN;
22 
23   PROCEDURE GET_BASE_CURR_DATA;
24 
25   FUNCTION AFTERREPORT RETURN BOOLEAN;
26 
27   PROCEDURE RAISE_ORA_ERR(MSGNAME IN VARCHAR2);
28 
29   PROCEDURE RAISE_ERR(MSGNAME IN VARCHAR2);
30 
31   PROCEDURE CURRENCY_VALIDATION;
32 
33   FUNCTION CF_1FORMULA RETURN NUMBER;
34 
35   FUNCTION CF_2FORMULA(STATUS_CODE IN VARCHAR2) RETURN NUMBER;
36 
37   FUNCTION CF_3FORMULA(STATUS_DESC IN VARCHAR2) RETURN VARCHAR2;
38 
39   FUNCTION C_COMPANY_NAME_P RETURN VARCHAR2;
40 
41   FUNCTION C_STATUS_P RETURN VARCHAR2;
42 
43   FUNCTION CP_VALID_CURR_CODE_P RETURN NUMBER;
44 
45 END JL_JLCOFAAR_XMLP_PKG;
46 
47 
48