PACKAGE: APPS.WIP_WIPRDJVR_XMLP_PKG

Source

1 PACKAGE WIP_WIPRDJVR_XMLP_PKG AS
2 /* $Header: WIPRDJVRS.pls 120.1 2008/01/31 12:32:28 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   CLASS_TYPE NUMBER;
18 
19   JOB_FROM VARCHAR2(240);
20 
21   JOB_TO VARCHAR2(240);
22 
23   CLASS_FROM VARCHAR2(80);
24 
25   CLASS_TO VARCHAR2(80);
26 
27   REPORT_RUN_OPT NUMBER;
28 
29   SUBMITTED_BY VARCHAR2(4);
30 
31   GROUP_ID NUMBER;
32 
33   P_FLEXDATA_ACCT VARCHAR2(850);
34 
35   STATUS_TYPE NUMBER;
36 
37   item_id_flex_num number(15);
38 
39   P_ORDER_FLEX VARCHAR2(850);
40 
41   P_QTY_PRECISION NUMBER;
42 
43   P_STRUCT_NUM NUMBER;
44 
45   ACCT_PERIOD_ID NUMBER;
46 
47   P_DEBUG NUMBER;
48 
49   P_OUTER VARCHAR2(32767) := '(+)';
50 
51   P_SUBMISSION_TYPE VARCHAR2(1000) :=' and 1=1';
52 
53   P_INCLUDE_BULK NUMBER;
54 
55   P_INCLUDE_VENDOR NUMBER;
56 
57   P_PROJECT_ID NUMBER;
58 
59   P_PROJECT_WHERE VARCHAR2(1500) := '1=1';
60 
61   P_PROJ_WHERE VARCHAR2(1400) := '1=1';
62 
63   P_EXCHANGE_RATE_TYPE NUMBER;
64 
65   P_EXCHANGE_RATE NUMBER;
66 
67   P_DISPLAY_INVERSE_RATE VARCHAR2(40);
68 
69   P_PROJECT_DUMMY NUMBER;
70 
71   REPORT_SORT VARCHAR2(80);
72 
73   WHERE_CLASS VARCHAR2(80) := '1 = 1';
74 
75   REPORT_SORT_BY_AFT VARCHAR2(80) := ', ml_class_type.meaning';
76 
77   CLASS_TYPE_NAME VARCHAR2(80);
78 
79   REPORT_SORT_BY_BEF VARCHAR2(80) := 'wp.wip_entity_name,';
80 
81   PRECISION NUMBER := 0;
82 
83   EXT_PRECISION NUMBER := 0;
84 
85   CURRENCY_CODE VARCHAR2(15) := 'USD';
86 
87   REPORT_OPTION VARCHAR2(80);
88 
89   STATUS_TYPE_NAME VARCHAR2(80);
90 
91   ORG_NAME VARCHAR2(240);
92 
93   C_INCLUDE_BULK VARCHAR2(100);
94 
95   C_INCLUDE_VENDOR VARCHAR2(100);
96 
97   WHERE_JOB VARCHAR2(240) := '1 = 1';
98 
99   FUNCTION DISP_CURRENCYFORMULA RETURN VARCHAR2;
100 
101   FUNCTION ORG_NAME_HDRFORMULA RETURN VARCHAR2;
102 
103   FUNCTION TOT_CST_INC_STD_CSTFORMULA(TOT_REQ_JOB_STD IN NUMBER
104                                      ,TOT_RES_STD_COST IN NUMBER
105                                      ,TOT_RES_OVR_STD_COST IN NUMBER
106                                      ,TOT_MV_OVR_STD_COST IN NUMBER) RETURN NUMBER;
107 
108   FUNCTION TOT_CST_INC_APP_CSTFORMULA(TOT_ACT_ISS_STD IN NUMBER
109                                      ,TOT_RES_APP_COST IN NUMBER
110                                      ,TOT_RES_OVR_APP_COST IN NUMBER
111                                      ,TOT_MV_OVR_APP_COST IN NUMBER) RETURN NUMBER;
112 
113   FUNCTION TOT_CST_INC_EFF_VARFORMULA(TOT_USG_VAR IN NUMBER
114                                      ,TOT_EFF_VAR IN NUMBER
115                                      ,TOT_RES_OVR_EFF_VAR IN NUMBER
116                                      ,TOT_MV_OVR_EFF_VAR IN NUMBER) RETURN NUMBER;
117 
118   FUNCTION TOT_JOB_BALANCE_CSTFORMULA(TOT_CST_INC_APP_CST IN NUMBER
119                                      ,TOT_SCP_AND_COMP_CST IN NUMBER
120                                      ,TOT_CLOSE_TRX_CST IN NUMBER) RETURN NUMBER;
121 
122   FUNCTION BEFOREREPORT RETURN BOOLEAN;
123 
124   FUNCTION AFTERREPORT RETURN BOOLEAN;
125 
126   FUNCTION AFTERPFORM RETURN BOOLEAN;
127 
128   FUNCTION C_MAT_DISPFORMULA(WIP_SUPPLY_TYPE IN NUMBER
129                             ,QTY_ISSUED IN NUMBER) RETURN NUMBER;
130 
131   FUNCTION BEFOREPFORM RETURN BOOLEAN;
132 
133   FUNCTION REPORT_SORT_P RETURN VARCHAR2;
134 
135   FUNCTION WHERE_CLASS_P RETURN VARCHAR2;
136 
137   FUNCTION REPORT_SORT_BY_AFT_P RETURN VARCHAR2;
138 
139   FUNCTION CLASS_TYPE_NAME_P RETURN VARCHAR2;
140 
141   FUNCTION REPORT_SORT_BY_BEF_P RETURN VARCHAR2;
142 
143   FUNCTION PRECISION_P RETURN NUMBER;
144 
145   FUNCTION EXT_PRECISION_P RETURN NUMBER;
146 
147   FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
148 
149   FUNCTION REPORT_OPTION_P RETURN VARCHAR2;
150 
151   FUNCTION STATUS_TYPE_NAME_P RETURN VARCHAR2;
152 
153   FUNCTION ORG_NAME_P RETURN VARCHAR2;
154 
155   FUNCTION C_INCLUDE_BULK_P RETURN VARCHAR2;
156 
157   FUNCTION C_INCLUDE_VENDOR_P RETURN VARCHAR2;
158 
159   FUNCTION WHERE_JOB_P RETURN VARCHAR2;
160 
161   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
162                     ,NAME IN VARCHAR2);
163 
164   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
165                      ,VALUE IN VARCHAR2
166                      ,TRANSLATE IN BOOLEAN);
167 
168   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
169 
170   PROCEDURE CLEAR;
171 
172   FUNCTION GET_STRING(APPIN IN VARCHAR2
173                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
174 
175   FUNCTION GET_NUMBER(APPIN IN VARCHAR2
176                      ,NAMEIN IN VARCHAR2) RETURN NUMBER;
177 
178   FUNCTION GET RETURN VARCHAR2;
179 
180   FUNCTION GET_ENCODED RETURN VARCHAR2;
181 
182   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
183                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
184                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
185 
186   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
187 
188   PROCEDURE RAISE_ERROR;
189 
190 END WIP_WIPRDJVR_XMLP_PKG;
191 
192