PACKAGE: APPS.WIP_WIPREJVR_XMLP_PKG

Source

1 PACKAGE WIP_WIPREJVR_XMLP_PKG AS
2 /* $Header: WIPREJVRS.pls 120.1 2008/01/31 12:37:11 npannamp noship $ */
3   REPORT_SORT_OPT NUMBER;
4 
5   ORG_ID NUMBER;
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
8 
9   P_FLEXDATA_ITEM VARCHAR2(850);
10 
11   P_WHERE_ITEM VARCHAR2(850) := '1 = 1';
12 
13   P_FROM_ITEM VARCHAR2(80);
14 
15   P_TO_ITEM VARCHAR2(80);
16 
17   JOB_FROM VARCHAR2(80);
18 
19   JOB_TO VARCHAR2(80);
20 
21   CLASS_FROM VARCHAR2(80);
22   p_item_flex_num number;
23 
24   CLASS_TO VARCHAR2(80);
25 
26   REPORT_RUN_OPT NUMBER;
27 
28   GROUP_ID NUMBER;
29 
30   P_FLEXDATA_ACCT VARCHAR2(850);
31 
32   STATUS_TYPE NUMBER;
33 
34   P_ORDER_FLEX VARCHAR2(850);
35 
36   P_QTY_PRECISION NUMBER;
37 
38   SUBMITTED_BY VARCHAR2(4);
39 
40   PER_START_DATE DATE;
41 
42   PER_SCHD_CLS_DATE DATE;
43 
44   LPER_START_DATE varchar2(12);
45 
46   LPER_SCHD_CLS_DATE varchar2(12);
47 
48   P_STRUCT_NUM NUMBER;
49 
50   P_DEBUG NUMBER;
51 
52   P_OUTER VARCHAR2(32767) := '(+)';
53 
54   P_SUBSELECT VARCHAR2(1000);
55 
56   ORG_NAME VARCHAR2(240);
57 
58   PRECISION NUMBER := 0;
59 
60   EXT_PRECISION NUMBER := 0;
61 
62   CURRENCY_CODE VARCHAR2(15) := 'USD';
63 
64   REPORT_OPTION VARCHAR2(80);
65 
66   STATUS_TYPE_NAME VARCHAR2(80);
67 
68   REPORT_SORT_BY_AFT VARCHAR2(80) := ', ml_class_type.meaning';
69 
70   CLASS_TYPE_NAME VARCHAR2(80);
71 
72   WHERE_JOB VARCHAR2(240) := '1 = 1';
73 
74   REPORT_SORT_BY_BEF VARCHAR2(80) := 'wp.wip_entity_name,';
75 
76   WHERE_CLASS VARCHAR2(80) := '1 = 1';
77 
78   REPORT_SORT VARCHAR2(80);
79 
80   FUNCTION DISP_CURRENCYFORMULA RETURN VARCHAR2;
81 
82   FUNCTION ORG_NAME_HDRFORMULA RETURN VARCHAR2;
83 
84   FUNCTION TOT_CST_INC_APP_CSTFORMULA(TOT_ACT_ISS_STD IN NUMBER
85                                      ,TOT_RES_APP_COST IN NUMBER
86                                      ,TOT_RES_OVR_APP_COST IN NUMBER
87                                      ,TOT_MV_OVR_APP_COST IN NUMBER) RETURN NUMBER;
88 
89   FUNCTION TOT_JOB_BALANCE_CSTFORMULA(TOT_CST_INC_APP_CST IN NUMBER
90                                      ,TOT_SCP_AND_COMP_CST IN NUMBER
91                                      ,TOT_CLOSE_TRX_CST IN NUMBER) RETURN NUMBER;
92 
93   FUNCTION BEFOREREPORT RETURN BOOLEAN;
94 
95   FUNCTION AFTERREPORT RETURN BOOLEAN;
96 
97   FUNCTION AFTERPFORM RETURN BOOLEAN;
98 
99   FUNCTION ORG_NAME_P RETURN VARCHAR2;
100 
101   FUNCTION PRECISION_P RETURN NUMBER;
102 
103   FUNCTION EXT_PRECISION_P RETURN NUMBER;
104 
105   FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
106 
107   FUNCTION REPORT_OPTION_P RETURN VARCHAR2;
108 
109   FUNCTION STATUS_TYPE_NAME_P RETURN VARCHAR2;
110 
111   FUNCTION REPORT_SORT_BY_AFT_P RETURN VARCHAR2;
112 
113   FUNCTION CLASS_TYPE_NAME_P RETURN VARCHAR2;
114 
115   FUNCTION WHERE_JOB_P RETURN VARCHAR2;
116 
117   FUNCTION REPORT_SORT_BY_BEF_P RETURN VARCHAR2;
118 
119   FUNCTION WHERE_CLASS_P RETURN VARCHAR2;
120 
121   FUNCTION REPORT_SORT_P RETURN VARCHAR2;
122 
123 END WIP_WIPREJVR_XMLP_PKG;
124