PACKAGE: APPS.PSB_PSBRPSPU_XMLP_PKG

Source

1 PACKAGE        "PSB_PSBRPSPU_XMLP_PKG" AS
2 /* $Header: PSBRPSPUS.pls 120.0 2008/01/07 14:28:37 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_CURRENCY_CODE VARCHAR2(15);
14 
15   CP_SERVICE_PACKAGE_ID NUMBER;
16 
17   CP_NO_DATA_FOUND VARCHAR2(500);
18 
19   CP_END_OF_REPORT VARCHAR2(500);
20 
21   SELECT_AMT VARCHAR2(500);
22 
23   CP_PARAM_WS_NAME VARCHAR2(80);
24 
25   CP_PARAM_SP_NAME VARCHAR2(30);
26 
27   CP_PARAM_ORDER_BY VARCHAR2(30);
28 
29   CP_SORT VARCHAR2(30) := 'SHORT_NAME';
30 
31   CP_PARAM_STAGE_NAME VARCHAR2(100);
32 
33   CP_WS_STAGE_NAME VARCHAR2(100);
34 
35   CP_SEQUENCE_NUMBER NUMBER;
36 
37   CP_REPORTING_SOB_ID NUMBER;
38 
39   FUNCTION CF_SERVICE_PACKAGE_IDFORMULA(SP_SERVICE_PACKAGE_ID IN NUMBER) RETURN NUMBER;
40 
41   FUNCTION BEFOREREPORT RETURN BOOLEAN;
42 
43   FUNCTION BEFOREPFORM RETURN BOOLEAN;
44 
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46 
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48 
49   FUNCTION CF_STAGE_NAMEFORMULA(WS_CURRENT_STAGE_NAME IN VARCHAR2) RETURN VARCHAR2;
50 
51   FUNCTION BETWEENPAGE RETURN BOOLEAN;
52 
53   FUNCTION CF_CURRENCY_CODEFORMULA(TOP_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
54 
55   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
56 
57   FUNCTION CP_SERVICE_PACKAGE_ID_P RETURN NUMBER;
58 
59   FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
60 
61   FUNCTION CP_END_OF_REPORT_P RETURN VARCHAR2;
62 
63   FUNCTION SELECT_AMT_P RETURN VARCHAR2;
64 
65   FUNCTION CP_PARAM_WS_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION CP_PARAM_SP_NAME_P RETURN VARCHAR2;
68 
69   FUNCTION CP_PARAM_ORDER_BY_P RETURN VARCHAR2;
70 
71   FUNCTION CP_SORT_P RETURN VARCHAR2;
72 
73   FUNCTION CP_PARAM_STAGE_NAME_P RETURN VARCHAR2;
74 
75   FUNCTION CP_WS_STAGE_NAME_P RETURN VARCHAR2;
76 
77   FUNCTION CP_SEQUENCE_NUMBER_P RETURN NUMBER;
78 
79   FUNCTION CP_REPORTING_SOB_ID_P RETURN NUMBER;
80 
81 END PSB_PSBRPSPU_XMLP_PKG;
82 
83 
84 
85 
86