PACKAGE: APPS.JL_JLCOFARR_XMLP_PKG

Source

1 PACKAGE JL_JLCOFARR_XMLP_PKG AS
2 /* $Header: JLCOFARRS.pls 120.1 2007/12/25 16:45:58 dwkrishn noship $ */
3   P_END_OF_REPORT VARCHAR2(25);
4 
5   P_MIN_PRECISION NUMBER;
6 
7   P_NO_DATA_FOUND VARCHAR2(25);
8 
9   P_CATEGORY_ID NUMBER;
10 
11   P_BOOK_TYPE_CODE VARCHAR2(15);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   CURRENCY_CODE VARCHAR2(32767);
16 
17   C_COMPANY_NAME VARCHAR2(80);
18 
19   C_STATUS VARCHAR2(50);
20 
21   C_APP_VALUATION NUMBER;
22 
23   CP_NET_VALUE NUMBER;
24 
25   CAT_FLEX_STRUCT NUMBER;
26 
27   C_ALL_SEGS VARCHAR2(600) := '(segment1|| ''\n'' ||segment2|| ''\n'' ||segment3|| ''\n'' ||segment4|| ''\n'' ||segment5|| ''\n'' ||segment6|| ''\n'' ||segment7)';
28 
29   PROCEDURE GET_BASE_CURR_DATA;
30 
31   PROCEDURE RAISE_ERR(MSGNAME IN VARCHAR2);
32 
33   PROCEDURE RAISE_ORA_ERR(MSGNAME IN VARCHAR2);
34 
35   FUNCTION AFTERREPORT RETURN BOOLEAN;
36 
37   FUNCTION F_NET_VALFORMULA(CURRENT_VALUATION IN NUMBER
38                            ,PRIOR_VALUATION IN NUMBER) RETURN NUMBER;
39 
40   FUNCTION F_APP_VALUATIONFORMULA(APPRAISAL_VALUE IN NUMBER
41                                  ,CURRENT_VALUATION IN NUMBER) RETURN NUMBER;
42 
43   FUNCTION FORMULA2FORMULA(CS_APPRAISAL_VALUE IN NUMBER) RETURN NUMBER;
44 
45   FUNCTION C_COMPANY_NAME_P RETURN VARCHAR2;
46 
47   FUNCTION C_STATUS_P RETURN VARCHAR2;
48 
49   FUNCTION C_APP_VALUATION_P RETURN NUMBER;
50 
51   FUNCTION CP_NET_VALUE_P RETURN NUMBER;
52 
53   FUNCTION CAT_FLEX_STRUCT_P RETURN NUMBER;
54 
55   FUNCTION C_ALL_SEGS_P RETURN VARCHAR2;
56 
57   FUNCTION BEFOREREPORT RETURN BOOLEAN;
58 
59 END JL_JLCOFARR_XMLP_PKG;
60 
61