PACKAGE: APPS.PA_PAXALRUN_XMLP_PKG

Source

1 PACKAGE PA_PAXALRUN_XMLP_PKG AS
2 /* $Header: PAXALRUNS.pls 120.0 2008/01/02 11:14:32 krreddy noship $ */
3   P_RULE_OPTIMIZER VARCHAR2(3);
4 
5   P_DEBUG_MODE VARCHAR2(3);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_RULE_ID NUMBER;
10 
11   P_RUN_PERIOD VARCHAR2(40);
12 
13   P_EXPND_ITEM_DATE DATE;
14   P_EXPND_ITEM_DATE_1 VARCHAR2(30);
15 
16   P_RUN_ID NUMBER;
17 
18   P_RUN_MODE VARCHAR2(1);
19 
20   P_PURGEABLE VARCHAR2(32767);
21 
22   P_RUN_STATUS_CODE VARCHAR2(3);
23 
24   C_COMPANY_NAME_HEADER VARCHAR2(50);
25 
26   C_NO_DATA_FOUND VARCHAR2(80);
27 
28   C_DUMMY_DATA NUMBER;
29 
30   C_RULE_NAME VARCHAR2(60);
31 
32   C_REQUEST_ID NUMBER;
33 
34   C_RUN_STATUS VARCHAR2(80);
35 
36   C_FUNC_CURRENCY VARCHAR2(15);
37 
38   C_RUN_PERIOD VARCHAR2(40);
39 
40   C_EXPND_ITEM_DATE DATE;
41 
42   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
43 
44   FUNCTION BEFOREREPORT RETURN BOOLEAN;
45 
46   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
47 
48   FUNCTION AFTERREPORT RETURN BOOLEAN;
49 
50   FUNCTION DRAFT_EXCEPTION_EXISTS RETURN number;
51 
52   FUNCTION ALLOC_TXN_EXISTS RETURN number;
53 
54   FUNCTION RELEASE_EXCEPTION_EXISTS RETURN number;
55 
56   FUNCTION C_FMT_MASKFORMULA RETURN VARCHAR2;
57 
58   FUNCTION C_DSP_SUM_CURRENT_ALLOCATIONFO(SUM_CURRENT_ALLOCATION IN NUMBER
59                                          ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
60 
61   FUNCTION C_DSP_SUM_PREV_ALLOCATIONFORMU(SUM_PREVIOUS_ALLOCATION IN NUMBER
62                                          ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
63 
64   FUNCTION C_DSP_TOTAL_ALLOCATIONFORMULA(SUM_TOTAL_ALLOCATION IN NUMBER
65                                         ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
66 
67   FUNCTION C_DSP_CURRENT_ALLOCATIONFORMUL(CURRENT_ALLOCATION IN NUMBER
68                                          ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
69 
70   FUNCTION C_DSP_CURRENT_SUMFORMULA(CS_CURRENT_SUM IN NUMBER
71                                    ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
72 
73   FUNCTION C_DSP_PREVIOUS_SUMFORMULA(CS_PREVIOUS_SUM IN NUMBER
74                                     ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
75 
76   FUNCTION C_DSP_TOT_SUMFORMULA(CS_TOT_SUM IN NUMBER
77                                ,C_FMT_MASK IN VARCHAR2) RETURN VARCHAR2;
78 
79   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
80 
81   FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
82 
83   FUNCTION C_DUMMY_DATA_P RETURN NUMBER;
84 
85   FUNCTION C_RULE_NAME_P RETURN VARCHAR2;
86 
87   FUNCTION C_REQUEST_ID_P RETURN NUMBER;
88 
89   FUNCTION C_RUN_STATUS_P RETURN VARCHAR2;
90 
91   FUNCTION C_FUNC_CURRENCY_P RETURN VARCHAR2;
92 
93   FUNCTION C_RUN_PERIOD_P RETURN VARCHAR2;
94 
95   FUNCTION C_EXPND_ITEM_DATE_P RETURN DATE;
96 
97 END PA_PAXALRUN_XMLP_PKG;