PACKAGE: APPS.PSB_PSBRPSPD_XMLP_PKG

Source

1 PACKAGE PSB_PSBRPSPD_XMLP_PKG AS
2 /* $Header: PSBRPSPDS.pls 120.0 2008/01/07 10:48:13 vijranga noship $ */
3   P_GLOBAL_WORKSHEET_ID NUMBER;
4 
5   P_CONC_REQUEST_ID VARCHAR2(15) := '0';
6 
7   P_SERVICE_PACKAGE_ID NUMBER;
8 
9   P_ORDER_BY VARCHAR2(32767);
10 
11   P_STAGE_ID NUMBER;
12 
13   CP_SERVICE_PACKAGE_ID NUMBER;
14 
15   CP_NO_DATA_FOUND VARCHAR2(80);
16 
17   CP_END_OF_REPORT VARCHAR2(80);
18 
19   SELECT_AMT VARCHAR2(500);
20 
21   CP_PARAM_WS_NAME VARCHAR2(80);
22 
23   CP_PARAM_SP_NAME VARCHAR2(30);
24 
25   CP_PARAM_ORDER_BY VARCHAR2(30);
26 
27   CP_SORT VARCHAR2(30) := 'SHORT_NAME';
28 
29   CP_WS_STAGE_NAME VARCHAR2(100);
30 
31   CP_PARAM_STAGE_NAME VARCHAR2(100);
32 
33   CP_SEQUENCE_NUMBER NUMBER;
34 
35   FUNCTION CF_SERVICE_PACKAGE_IDFORMULA(SP_SERVICE_PACKAGE_ID IN NUMBER) RETURN NUMBER;
36 
37   FUNCTION BEFOREREPORT RETURN BOOLEAN;
38 
39   FUNCTION BEFOREPFORM RETURN BOOLEAN;
40 
41   FUNCTION AFTERPFORM RETURN BOOLEAN;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION CF_STAGE_NAMEFORMULA(WS_CURRENT_STAGE_NAME IN VARCHAR2) RETURN VARCHAR2;
46 
47   FUNCTION BETWEENPAGE RETURN BOOLEAN;
48 
49   FUNCTION CP_SERVICE_PACKAGE_ID_P RETURN NUMBER;
50 
51   FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
52 
53   FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2;
54 
55   FUNCTION SELECT_AMT_P RETURN VARCHAR2;
56 
57   FUNCTION CP_PARAM_WS_NAME_P RETURN VARCHAR2;
58 
59   FUNCTION CP_PARAM_SP_NAME_P RETURN VARCHAR2;
60 
61   FUNCTION CP_PARAM_ORDER_BY_P RETURN VARCHAR2;
62 
63   FUNCTION CP_SORT_P RETURN VARCHAR2;
64 
65   FUNCTION CP_WS_STAGE_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION CP_PARAM_STAGE_NAME_P RETURN VARCHAR2;
68 
69   FUNCTION CP_SEQUENCE_NUMBER_P RETURN NUMBER;
70 
71 END PSB_PSBRPSPD_XMLP_PKG;
72 
73 
74 
75 
76