PACKAGE: APPS.BOM_CSTRDJVA_XMLP_PKG

Source

1 PACKAGE BOM_CSTRDJVA_XMLP_PKG AS
2 /* $Header: CSTRDJVAS.pls 120.0 2007/12/24 09:56:31 dwkrishn noship $ */
3   REPORT_SORT_OPT NUMBER;
4 
5   ORG_ID NUMBER;
6 
7   p_item_flex_num number;
8 
9   P_CONC_REQUEST_ID NUMBER := 0;
10 
11   P_FLEXDATA_ITEM VARCHAR2(850);
12 
13   P_WHERE_ITEM VARCHAR2(850) := '1 = 1';
14 
15   P_FROM_ITEM VARCHAR2(80);
16 
17   P_TO_ITEM VARCHAR2(80);
18 
19   CLASS_TYPE NUMBER;
20 
21   JOB_FROM VARCHAR2(80);
22 
23   JOB_TO VARCHAR2(80);
24 
25   CLASS_FROM VARCHAR2(80);
26 
27   CLASS_TO VARCHAR2(80);
28 
29   REPORT_RUN_OPT NUMBER;
30 
31   SUBMITTED_BY VARCHAR2(4);
32 
33   GROUP_ID NUMBER;
34 
35   P_FLEXDATA_ACCT VARCHAR2(850);
36 
37   STATUS_TYPE NUMBER;
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);
52 
53   P_INCLUDE_BULK NUMBER;
54 
55   P_INCLUDE_VENDOR NUMBER;
56 
57   P_COST_GROUP_ID NUMBER;
58 
59   P_JOB_SELECTION NUMBER;
60 
61   P_CURRENCY_CODE VARCHAR2(3);
62 
63   LP_CURRENCY_CODE VARCHAR2(3);
64 
65   P_EXCHANGE_RATE NUMBER;
66 
67   LP_EXCHANGE_RATE NUMBER;
68 
69   REPORT_SORT VARCHAR2(80);
70 
71   WHERE_CLASS VARCHAR2(80) := '1 = 1';
72 
73   REPORT_SORT_BY_AFT VARCHAR2(80) := ', ml_class_type.meaning';
74 
75   CLASS_TYPE_NAME VARCHAR2(80);
76 
77   REPORT_SORT_BY_BEF VARCHAR2(80) := 'wp.wip_entity_name,';
78 
79   PRECISION NUMBER := 0;
80 
81   EXT_PRECISION NUMBER := 0;
82 
83   CURRENCY_CODE VARCHAR2(15) := 'USD';
84 
85   REPORT_OPTION VARCHAR2(80);
86 
87   STATUS_TYPE_NAME VARCHAR2(80);
88 
89   ORG_NAME VARCHAR2(240);
90 
91   C_INCLUDE_BULK VARCHAR2(100);
92 
93   C_INCLUDE_VENDOR VARCHAR2(100);
94 
95   WHERE_JOB VARCHAR2(240) := '1 = 1';
96 
97   SELECTED_COST_GROUP VARCHAR2(80);
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) RETURN NUMBER;
106 
107   FUNCTION TOT_CST_INC_APP_CSTFORMULA(TOT_ACT_ISS_STD IN NUMBER
108                                      ,TOT_RES_APP_COST IN NUMBER
109                                      ,TOT_RES_OVR_APP_COST IN NUMBER) RETURN NUMBER;
110 
111   FUNCTION TOT_CST_INC_EFF_VARFORMULA(TOT_USG_VAR IN NUMBER
112                                      ,TOT_EFF_VAR IN NUMBER) RETURN NUMBER;
113 
114   FUNCTION TOT_JOB_BALANCE_CSTFORMULA(TOT_CST_INC_APP_CST IN NUMBER
115                                      ,TOT_SCP_AND_COMP_CST IN NUMBER
116                                      ,TOT_CLOSE_TRX_CST IN NUMBER) RETURN NUMBER;
117 
118   FUNCTION BEFOREREPORT RETURN BOOLEAN;
119 
120   FUNCTION AFTERREPORT RETURN BOOLEAN;
121 
122   FUNCTION AFTERPFORM RETURN BOOLEAN;
123 
124   FUNCTION C_MAT_DISPFORMULA(WIP_SUPPLY_TYPE IN NUMBER
125                             ,QTY_ISSUED IN NUMBER) RETURN NUMBER;
126 
127   FUNCTION GROUP_IDVALIDTRIGGER RETURN BOOLEAN;
128 
129   FUNCTION REPORT_SORT_P RETURN VARCHAR2;
130 
131   FUNCTION WHERE_CLASS_P RETURN VARCHAR2;
132 
133   FUNCTION REPORT_SORT_BY_AFT_P RETURN VARCHAR2;
134 
135   FUNCTION CLASS_TYPE_NAME_P RETURN VARCHAR2;
136 
137   FUNCTION REPORT_SORT_BY_BEF_P RETURN VARCHAR2;
138 
139   FUNCTION PRECISION_P RETURN NUMBER;
140 
141   FUNCTION EXT_PRECISION_P RETURN NUMBER;
142 
143   FUNCTION CURRENCY_CODE_P RETURN VARCHAR2;
144 
145   FUNCTION REPORT_OPTION_P RETURN VARCHAR2;
146 
147   FUNCTION STATUS_TYPE_NAME_P RETURN VARCHAR2;
148 
149   FUNCTION ORG_NAME_P RETURN VARCHAR2;
150 
151   FUNCTION C_INCLUDE_BULK_P RETURN VARCHAR2;
152 
153   FUNCTION C_INCLUDE_VENDOR_P RETURN VARCHAR2;
154 
155   FUNCTION WHERE_JOB_P RETURN VARCHAR2;
156 
157   FUNCTION SELECTED_COST_GROUP_P RETURN VARCHAR2;
158 
159   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
160                     ,NAME IN VARCHAR2);
161 
162   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
163                      ,VALUE IN VARCHAR2
164                      ,TRANSLATE IN BOOLEAN);
165 
166   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
167 
168   PROCEDURE CLEAR;
169 
170   FUNCTION GET_STRING(APPIN IN VARCHAR2
171                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
172 
173   FUNCTION GET_NUMBER(APPIN IN VARCHAR2
174                      ,NAMEIN IN VARCHAR2) RETURN NUMBER;
175 
176   FUNCTION GET RETURN VARCHAR2;
177 
178   FUNCTION GET_ENCODED RETURN VARCHAR2;
179 
180   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
181                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
182                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
183 
184   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
185 
186   PROCEDURE RAISE_ERROR;
187 
188 END BOM_CSTRDJVA_XMLP_PKG;
189 
190 
191