PACKAGE: APPS.WIP_WIPREVAL_XMLP_PKG

Source

1 PACKAGE WIP_WIPREVAL_XMLP_PKG AS
2 /* $Header: WIPREVALS.pls 120.1 2008/01/09 10:07:35 dwkrishn noship $ */
3   ORG_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   C_FROM_PERIOD_START_DATE date;
8 
9   C_TO_PERIOD_END_DATE date;
10 
11   FROM_ASSEMBLY VARCHAR2(80);
12 
13   TO_ASSEMBLY VARCHAR2(80);
14 
15   FROM_CLASS VARCHAR2(80);
16 
17   TO_CLASS VARCHAR2(80);
18 
19   REPORT_RUN_OPT NUMBER;
20 
21   P_FLEXDATA_ACCT VARCHAR2(600);
22 
23   P_QTY_PRECISION NUMBER;
24 
25   FROM_PERIOD_START_DATE DATE;
26 
27   FROM_PERIOD_START_DATE_char varchar2(20);
28 
29   TO_PERIOD_END_DATE DATE;
30 
31   TO_PERIOD_END_DATE_char varchar2(20);
32 
33   FROM_LINE VARCHAR2(80);
34 
35   TO_LINE VARCHAR2(80);
36 
37   P_FLEXDATA_ITEM VARCHAR2(850);
38 
39   P_DEBUG NUMBER;
40 
41   P_INCLUDE_VENDOR NUMBER;
42 
43   P_INCLUDE_BULK NUMBER;
44 
45   FROM_ASSY_DISP VARCHAR2(80);
46 
47   TO_LINE_DISP VARCHAR2(80);
48 
49   TO_CLASS_DISP VARCHAR2(80);
50 
51   TO_ASSY_DISP VARCHAR2(80);
52 
53   FROM_LINE_DISP VARCHAR2(80);
54 
55   FROM_CLASS_DISP VARCHAR2(80);
56 
57   CHART_OF_ACCTS_ID NUMBER;
58 
59   C_COUNTER NUMBER;
60 
61   CALENDAR_CODE VARCHAR2(32767) := '''FordCal''';
62 
63   CURRENCY_CODE VARCHAR2(15) := 'USD';
64 
65   WHERE_PERIOD VARCHAR2(150) := '1 = 1';
66 
67   ORG_NAME VARCHAR2(240);
68 
69   REPORT_SORT_BY_AFT VARCHAR2(80) := ', ml_class_type.meaning,';
70 
71   EXCEPTION_SET_ID NUMBER := 4;
72 
73   REPORT_OPTION VARCHAR2(80);
74 
75   WHERE_CLASS VARCHAR2(150) := '1 = 1';
76 
77   WHERE_ASSEMBLY VARCHAR2(150) := '1 = 1';
78 
79   REPORT_SORT VARCHAR2(40);
80 
81   WHERE_LINE VARCHAR2(150) := '1 = 1';
82 
83   PRECISION NUMBER := 0;
84 
85   EXT_PRECISION NUMBER := 0;
86 
87   C_INCLUDE_VENDOR VARCHAR2(100) := '0';
88 
89   C_INCLUDE_BULK VARCHAR2(100) := '0';
90 
91   FUNCTION DISP_CURRENCYFORMULA RETURN VARCHAR2;
92 
93   FUNCTION ORG_NAME_HDRFORMULA RETURN VARCHAR2;
94 
95   FUNCTION TOT_CST_INC_APP_CSTFORMULA(TOT_ACT_ISS_STD IN NUMBER
96                                      ,TOT_RES_APP_COST IN NUMBER
97                                      ,TOT_RES_OVR_APP_COST IN NUMBER
98                                      ,TOT_MV_OVR_APP_COST IN NUMBER) RETURN NUMBER;
99 
100   FUNCTION TOT_CST_INC_EFF_VARFORMULA(TOT_USG_VAR IN NUMBER
101                                      ,TOT_EFF_VAR IN NUMBER
102                                      ,TOT_RES_OVR_EFF_VAR IN NUMBER
103                                      ,TOT_MV_OVR_EFF_VAR IN NUMBER) RETURN NUMBER;
104 
105   FUNCTION TOT_JOB_BALANCE_CSTFORMULA(TOT_CST_INC_APP_CST IN NUMBER
106                                      ,TOT_SCP_AND_COMP_CST IN NUMBER
107                                      ,TOT_CLOSE_TRX_CST IN NUMBER) RETURN NUMBER;
108 
109   FUNCTION TOT_CST_INC_STD_CSTFORMULA(TOT_REQ_JOB_STD IN NUMBER
110                                      ,TOT_RES_STD_COST IN NUMBER
111                                      ,TOT_RES_OVR_STD_COST IN NUMBER
112                                      ,TOT_MV_OVR_STD_COST IN NUMBER) RETURN NUMBER;
113 
114   FUNCTION AFTERREPORT RETURN BOOLEAN;
115 
116   FUNCTION AFTERPFORM RETURN BOOLEAN;
117 
118   FUNCTION BEFOREREPORT RETURN BOOLEAN;
119 
120   FUNCTION MAT_DISPFORMULA(QTY_REQ_SUM IN NUMBER
121                           ,REQ_JOB_STD_SUM IN NUMBER
122                           ,QTY_ISS_PER_OP_SUM IN NUMBER
123                           ,ACT_ISS_STD_SUM IN NUMBER
124                           ,SUPPLY_TYPE_CODE IN NUMBER) RETURN NUMBER;
125 
126   FUNCTION FROM_ASSY_DISP_P RETURN VARCHAR2;
127 
128   FUNCTION TO_LINE_DISP_P RETURN VARCHAR2;
129 
130   FUNCTION TO_CLASS_DISP_P RETURN VARCHAR2;
131 
132   FUNCTION TO_ASSY_DISP_P RETURN VARCHAR2;
133 
134   FUNCTION FROM_LINE_DISP_P RETURN VARCHAR2;
135 
136   FUNCTION FROM_CLASS_DISP_P RETURN VARCHAR2;
137 
138   FUNCTION CHART_OF_ACCTS_ID_P RETURN NUMBER;
139 
140   FUNCTION C_COUNTER_P RETURN NUMBER;
141 
142   FUNCTION CALENDAR_CODE_P RETURN VARCHAR2;
143 
144   FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
145 
146   FUNCTION WHERE_PERIOD_P RETURN VARCHAR2;
147 
148   FUNCTION ORG_NAME_P RETURN VARCHAR2;
149 
150   FUNCTION REPORT_SORT_BY_AFT_P RETURN VARCHAR2;
151 
152   FUNCTION EXCEPTION_SET_ID_P RETURN NUMBER;
153 
154   FUNCTION REPORT_OPTION_P RETURN VARCHAR2;
155 
156   FUNCTION WHERE_CLASS_P RETURN VARCHAR2;
157 
158   FUNCTION WHERE_ASSEMBLY_P RETURN VARCHAR2;
159 
160   FUNCTION REPORT_SORT_P RETURN VARCHAR2;
161 
162   FUNCTION WHERE_LINE_P RETURN VARCHAR2;
163 
164   FUNCTION PRECISION_P RETURN NUMBER;
165 
166   FUNCTION EXT_PRECISION_P RETURN NUMBER;
167 
168   FUNCTION C_INCLUDE_VENDOR_P RETURN VARCHAR2;
169 
170   FUNCTION C_INCLUDE_BULK_P RETURN VARCHAR2;
171 
172   FUNCTION GET_PRECISION RETURN VARCHAR2;
173 
174 END WIP_WIPREVAL_XMLP_PKG;
175