1 PACKAGE BOM_BOMRBOMS_XMLP_PKG AS
2 /* $Header: BOMRBOMSS.pls 120.2 2008/01/07 11:44:51 nchinnam noship $ */
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 P_ASS_BETWEEN VARCHAR2(480) := '1 = 1';
88
89 P_CAT_BETWEEN VARCHAR2(480) := '1 = 1';
90
91 P_ORDER_BY_TYPE NUMBER;
92
93 P_ALT_OPTION_TYPE NUMBER;
94
95 P_ALT_OPTION VARCHAR2(80);
96
97 P_QTY_PRECISION NUMBER;
98
99 P_SEQUENCE_ID NUMBER := 1;
100
101 P_ORDER_BY VARCHAR2(80);
102
103 P_VERIFY_FLAG NUMBER;
104
105 P_MSG_BUF VARCHAR2(80);
106
107 P_ERR_MSG VARCHAR2(80);
108
109 P_PLAN_FACTOR_FLAG NUMBER;
110
111 P_PLAN_FACTOR VARCHAR2(4);
112
113 P_YES VARCHAR2(4);
114
115 P_NO VARCHAR2(4);
116
117 P_DEBUG VARCHAR2(2);
118
119 DUMMY VARCHAR2(80);
120
121 P_PRINT_OPTION6_FLAG NUMBER;
122
123 P_PRINT_OPTION6 VARCHAR2(4);
124
125 P_FULL_DESCRIPTION NUMBER;
126
127 P_FULL_DESC_CHOICE VARCHAR2(32767);
128
129 P_ALL_ORGS VARCHAR2(3);
130 LP_ALL_ORGS VARCHAR2(3);
131
132 P_ORG_HIERARCHY VARCHAR2(30);
133
134 P_SEQUENCE_ID1 NUMBER;
135
136 FUNCTION BEFOREREPORT RETURN BOOLEAN;
137
138 FUNCTION AFTERREPORT RETURN BOOLEAN;
139
140 FUNCTION GET_REV(COMPO_ORG_ID IN NUMBER
141 ,COMPONENT_ITEM_ID IN NUMBER) RETURN VARCHAR2;
142
143 FUNCTION GET_ELE_DESC(M_BOM_ITEM_TYPE IN NUMBER
144 ,D2_ELEMENT_NAME IN VARCHAR2
145 ,M_ITEM_CATALOG_GROUP_ID IN NUMBER) RETURN VARCHAR2;
146
147 FUNCTION OPTIONAL_DISPFORMULA(OPTIONAL IN NUMBER) RETURN VARCHAR2;
148
149 FUNCTION MUTUALLY_DISPFORMULA(MUTUALLY_EXCLUSIVE_OPTION IN NUMBER) RETURN VARCHAR2;
150
151 FUNCTION CHECK_ATP_DISPFORMULA(CHECK_ATP IN NUMBER) RETURN VARCHAR2;
152
153 FUNCTION REQUIRED_TO_SHIP_DISPFORMULA(REQUIRED_TO_SHIP IN NUMBER) RETURN VARCHAR2;
154
155 FUNCTION REQUIRED_FOR_REVENUE_DISPFORMU(REQUIRED_FOR_REVENUE IN NUMBER) RETURN VARCHAR2;
156
157 FUNCTION INCLUDE_ON_SHIP_DOCS_DISPFORMU(INCLUDE_ON_SHIP_DOCS IN NUMBER) RETURN VARCHAR2;
158
159 FUNCTION ENG_BILL_DISPFORMULA(ENG_BILL IN NUMBER) RETURN VARCHAR2;
160
161 FUNCTION SUPPLY_TYPE_DISPFORMULA(WIP_SUPPLY_TYPE IN NUMBER) RETURN VARCHAR2;
162
163 FUNCTION CF_REVISION_DESCFORMULA(COMPONENT_ITEM_ID IN NUMBER
164 ,C_D3_REVISION IN VARCHAR2) RETURN CHAR;
165
166 FUNCTION CF_ORG_NAMEFORMULA(M_ORG_ID IN NUMBER) RETURN CHAR;
167
168 FUNCTION CF_ITEM_DESCFORMULA(M_ITEM_ID IN NUMBER
169 ,M_ORG_ID IN NUMBER) RETURN VARCHAR;
170
171 FUNCTION CF_COMP_DESCFORMULA(COMPONENT_ITEM_ID IN NUMBER
172 ,COMPO_ORG_ID IN NUMBER) RETURN VARCHAR;
173
174 FUNCTION CF_SUBCOMP_DESCFORMULA(D32_ITEM_ID IN NUMBER
175 ,D32_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
176
177 PROCEDURE EXPLODER_USEREXIT(VERIFY_FLAG IN NUMBER
178 ,ORG_ID IN NUMBER
179 ,ORDER_BY IN NUMBER
180 ,GRP_ID IN NUMBER
181 ,SESSION_ID IN NUMBER
182 ,LEVELS_TO_EXPLODE IN NUMBER
183 ,BOM_OR_ENG IN NUMBER
184 ,IMPL_FLAG IN NUMBER
185 ,PLAN_FACTOR_FLAG IN NUMBER
186 ,EXPLODE_OPTION IN NUMBER
187 ,MODULE IN NUMBER
188 ,CST_TYPE_ID IN NUMBER
189 ,STD_COMP_FLAG IN NUMBER
190 ,EXPL_QTY IN NUMBER
191 ,ITEM_ID IN NUMBER
192 ,ALT_DESG IN VARCHAR2
193 ,COMP_CODE IN VARCHAR2
194 ,REV_DATE IN VARCHAR2
195 ,ERR_MSG OUT NOCOPY VARCHAR2
196 ,ERROR_CODE OUT NOCOPY NUMBER);
197
198 PROCEDURE EXPLOSION_REPORT(VERIFY_FLAG IN NUMBER
199 ,ORG_ID IN NUMBER
200 ,ORDER_BY IN NUMBER
201 ,LIST_ID IN NUMBER
202 ,GRP_ID IN NUMBER
203 ,SESSION_ID IN NUMBER
204 ,LEVELS_TO_EXPLODE IN NUMBER
205 ,BOM_OR_ENG IN NUMBER
206 ,IMPL_FLAG IN NUMBER
207 ,PLAN_FACTOR_FLAG IN NUMBER
208 ,INCL_LT_FLAG IN NUMBER
209 ,EXPLODE_OPTION IN NUMBER
210 ,MODULE IN NUMBER
211 ,CST_TYPE_ID IN NUMBER
212 ,STD_COMP_FLAG IN NUMBER
213 ,EXPL_QTY IN NUMBER
214 ,REPORT_OPTION IN NUMBER
215 ,REQ_ID IN NUMBER
216 ,CST_RLP_ID IN NUMBER
217 ,LOCK_FLAG IN NUMBER
218 ,ROLLUP_OPTION IN NUMBER
219 ,ALT_RTG_DESG IN VARCHAR2
220 ,ALT_DESG IN VARCHAR2
221 ,REV_DATE IN VARCHAR2
222 ,ERR_MSG OUT NOCOPY VARCHAR2
223 ,ERROR_CODE OUT NOCOPY NUMBER);
224
225 END BOM_BOMRBOMS_XMLP_PKG;
226
227
[Home] [Help]