[Home] [Help]
PACKAGE: APPS.BOM_BOMRBOMS_XMLP_PKG
Source
1 PACKAGE BOM_BOMRBOMS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: BOMRBOMSS.pls 120.2.12010000.2 2010/02/15 11:29:26 agoginen ship $ */
3 P_BOM_OR_ENG VARCHAR2(3);
4
5 P_COMPO_FLEXDATA VARCHAR2(800);
6
7 P_LOCATOR_FLEXDATA VARCHAR2(800);
8
9 P_PRINT_OPTION1 VARCHAR2(4);
10
11 P_PRINT_OPTION2 VARCHAR2(4);
12
13 P_PRINT_OPTION3 VARCHAR2(4);
14
15 P_PRINT_OPTION4 VARCHAR2(4);
16
17 P_GROUP_ID NUMBER;
18
19 P_LOCATOR_STRUCTURE_ID NUMBER;
20
21 P_ITEM_STRUCTURE_ID NUMBER;
22
23 P_CONC_REQUEST_ID NUMBER := 0;
24
25 P_PRVD31_CNT NUMBER;
26
27 P_PRVD32_CNT NUMBER;
28
29 P_REVISION VARCHAR2(3);
30
31 P_REVISION_DATE VARCHAR2(1000);
32 LP_REVISION_DATE VARCHAR2(1000);
33
34 P_PRINT_OPTION5 VARCHAR2(4);
35
36 P_ORGANIZATION_ID NUMBER;
37 LP_ORGANIZATION_ID NUMBER;
38
39 P_ORGANIZATION_NAME VARCHAR2(240);
40
41 P_EXPLODE_OPTION_TYPE NUMBER;
42
43 P_EXPLODE_OPTION VARCHAR2(80);
44
45 P_EXPLOSION_QUANTITY NUMBER;
46
47 P_EXPLOSION_LEVEL NUMBER;
48
49 P_IMPL_FLAG NUMBER;
50
51 P_IMPL VARCHAR2(4);
52
53 P_RANGE_OPTION_TYPE NUMBER;
54
55 P_RANGE_OPTION VARCHAR2(80);
56
57 P_SPECIFIC_ITEM VARCHAR2(245);
58
59 P_ALTERNATE_DESG VARCHAR2(10);
60
61 P_ITEM_ID NUMBER;
62
63 P_ITEM_FROM VARCHAR2(820);
64
65 P_ITEM_TO VARCHAR2(820);
66
67 P_CATEGORY_SET_ID NUMBER;
68
69 P_CATEGORY_SET VARCHAR2(30);
70
71 P_CATEGORY_STRUCTURE_ID NUMBER;
72
73 P_CATEGORY_FROM VARCHAR2(820);
74
75 P_CATEGORY_TO VARCHAR2(820);
76
77 P_PRINT_OPTION1_FLAG NUMBER;
78
79 P_PRINT_OPTION2_FLAG NUMBER;
80
81 P_PRINT_OPTION3_FLAG NUMBER;
82
83 P_PRINT_OPTION4_FLAG NUMBER;
84
85 P_PRINT_OPTION5_FLAG NUMBER;
86
87 -- Commented for bug 9364923
88 -- P_ASS_BETWEEN VARCHAR2(480) := '1 = 1';
89
90 P_CAT_BETWEEN VARCHAR2(480) := '1 = 1';
91
92 P_ORDER_BY_TYPE NUMBER;
93
94 P_ALT_OPTION_TYPE NUMBER;
95
96 P_ALT_OPTION VARCHAR2(80);
97
98 P_QTY_PRECISION NUMBER;
99
100 P_SEQUENCE_ID NUMBER := 1;
101
102 P_ORDER_BY VARCHAR2(80);
103
104 P_VERIFY_FLAG NUMBER;
105
106 P_MSG_BUF VARCHAR2(80);
107
108 P_ERR_MSG VARCHAR2(80);
109
110 P_PLAN_FACTOR_FLAG NUMBER;
111
112 P_PLAN_FACTOR VARCHAR2(4);
113
114 P_YES VARCHAR2(4);
115
116 P_NO VARCHAR2(4);
117
118 P_DEBUG VARCHAR2(2);
119
120 DUMMY VARCHAR2(80);
121
122 P_PRINT_OPTION6_FLAG NUMBER;
123
124 P_PRINT_OPTION6 VARCHAR2(4);
125
126 P_FULL_DESCRIPTION NUMBER;
127
128 P_FULL_DESC_CHOICE VARCHAR2(32767);
129
130 P_ALL_ORGS VARCHAR2(3);
131 LP_ALL_ORGS VARCHAR2(3);
132
133 P_ORG_HIERARCHY VARCHAR2(30);
134
135 P_SEQUENCE_ID1 NUMBER;
136
137 FUNCTION BEFOREREPORT RETURN BOOLEAN;
138
139 FUNCTION AFTERREPORT RETURN BOOLEAN;
140
141 FUNCTION GET_REV(COMPO_ORG_ID IN NUMBER
142 ,COMPONENT_ITEM_ID IN NUMBER) RETURN VARCHAR2;
143
144 FUNCTION GET_ELE_DESC(M_BOM_ITEM_TYPE IN NUMBER
145 ,D2_ELEMENT_NAME IN VARCHAR2
146 ,M_ITEM_CATALOG_GROUP_ID IN NUMBER) RETURN VARCHAR2;
147
148 FUNCTION OPTIONAL_DISPFORMULA(OPTIONAL IN NUMBER) RETURN VARCHAR2;
149
150 FUNCTION MUTUALLY_DISPFORMULA(MUTUALLY_EXCLUSIVE_OPTION IN NUMBER) RETURN VARCHAR2;
151
152 FUNCTION CHECK_ATP_DISPFORMULA(CHECK_ATP IN NUMBER) RETURN VARCHAR2;
153
154 FUNCTION REQUIRED_TO_SHIP_DISPFORMULA(REQUIRED_TO_SHIP IN NUMBER) RETURN VARCHAR2;
155
156 FUNCTION REQUIRED_FOR_REVENUE_DISPFORMU(REQUIRED_FOR_REVENUE IN NUMBER) RETURN VARCHAR2;
157
158 FUNCTION INCLUDE_ON_SHIP_DOCS_DISPFORMU(INCLUDE_ON_SHIP_DOCS IN NUMBER) RETURN VARCHAR2;
159
160 FUNCTION ENG_BILL_DISPFORMULA(ENG_BILL IN NUMBER) RETURN VARCHAR2;
161
162 FUNCTION SUPPLY_TYPE_DISPFORMULA(WIP_SUPPLY_TYPE IN NUMBER) RETURN VARCHAR2;
163
164 FUNCTION CF_REVISION_DESCFORMULA(COMPONENT_ITEM_ID IN NUMBER
165 ,C_D3_REVISION IN VARCHAR2) RETURN CHAR;
166
167 FUNCTION CF_ORG_NAMEFORMULA(M_ORG_ID IN NUMBER) RETURN CHAR;
168
169 FUNCTION CF_ITEM_DESCFORMULA(M_ITEM_ID IN NUMBER
170 ,M_ORG_ID IN NUMBER) RETURN VARCHAR;
171
172 FUNCTION CF_COMP_DESCFORMULA(COMPONENT_ITEM_ID IN NUMBER
173 ,COMPO_ORG_ID IN NUMBER) RETURN VARCHAR;
174
175 FUNCTION CF_SUBCOMP_DESCFORMULA(D32_ITEM_ID IN NUMBER
176 ,D32_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
177
178 PROCEDURE EXPLODER_USEREXIT(VERIFY_FLAG IN NUMBER
179 ,ORG_ID IN NUMBER
180 ,ORDER_BY IN NUMBER
181 ,GRP_ID IN NUMBER
182 ,SESSION_ID IN NUMBER
183 ,LEVELS_TO_EXPLODE IN NUMBER
184 ,BOM_OR_ENG IN NUMBER
185 ,IMPL_FLAG IN NUMBER
186 ,PLAN_FACTOR_FLAG IN NUMBER
187 ,EXPLODE_OPTION IN NUMBER
188 ,MODULE IN NUMBER
189 ,CST_TYPE_ID IN NUMBER
190 ,STD_COMP_FLAG IN NUMBER
191 ,EXPL_QTY IN NUMBER
192 ,ITEM_ID IN NUMBER
193 ,ALT_DESG IN VARCHAR2
194 ,COMP_CODE IN VARCHAR2
195 ,REV_DATE IN VARCHAR2
196 ,ERR_MSG OUT NOCOPY VARCHAR2
197 ,ERROR_CODE OUT NOCOPY NUMBER);
198
199 PROCEDURE EXPLOSION_REPORT(VERIFY_FLAG IN NUMBER
200 ,ORG_ID IN NUMBER
201 ,ORDER_BY IN NUMBER
202 ,LIST_ID IN NUMBER
203 ,GRP_ID IN NUMBER
204 ,SESSION_ID IN NUMBER
205 ,LEVELS_TO_EXPLODE IN NUMBER
206 ,BOM_OR_ENG IN NUMBER
207 ,IMPL_FLAG IN NUMBER
208 ,PLAN_FACTOR_FLAG IN NUMBER
209 ,INCL_LT_FLAG IN NUMBER
210 ,EXPLODE_OPTION IN NUMBER
211 ,MODULE IN NUMBER
212 ,CST_TYPE_ID IN NUMBER
213 ,STD_COMP_FLAG IN NUMBER
214 ,EXPL_QTY IN NUMBER
215 ,REPORT_OPTION IN NUMBER
216 ,REQ_ID IN NUMBER
217 ,CST_RLP_ID IN NUMBER
218 ,LOCK_FLAG IN NUMBER
219 ,ROLLUP_OPTION IN NUMBER
220 ,ALT_RTG_DESG IN VARCHAR2
221 ,ALT_DESG IN VARCHAR2
222 ,REV_DATE IN VARCHAR2
223 ,ERR_MSG OUT NOCOPY VARCHAR2
224 ,ERROR_CODE OUT NOCOPY NUMBER);
225
226 END BOM_BOMRBOMS_XMLP_PKG;
227
228