[Home] [Help]
PACKAGE: APPS.JL_JLCOFAAR_XMLP_PKG
Source
1 PACKAGE JL_JLCOFAAR_XMLP_PKG 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