1 PACKAGE BOM_BOMRBOMC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: BOMRBOMCS.pls 120.0 2007/12/24 09:37:13 dwkrishn noship $ */
3 P_BOM_OR_ENG VARCHAR2(3);
4
5 P_PRINT_OPTION1 VARCHAR2(4);
6
7 P_REVISION VARCHAR2(3);
8
9 P_REVISION_DATE VARCHAR2(32767);
10
11 LP_REVISION_DATE VARCHAR2(32767);
12
13 P_CONC_REQUEST_ID NUMBER := 0;
14
15 P_ORGANIZATION_ID NUMBER;
16
17 P_ORGANIZATION_NAME VARCHAR2(240);
18
19 P_EXPLODE_OPTION_TYPE NUMBER;
20
21 P_EXPLODE_OPTION VARCHAR2(40);
22
23 P_EXPLOSION_QUANTITY NUMBER;
24
25 P_EXPLOSION_LEVEL NUMBER;
26
27 P_IMPL_FLAG NUMBER;
28
29 P_IMPL VARCHAR2(4);
30
31 P_RANGE_OPTION_TYPE NUMBER;
32
33 P_RANGE_OPTION VARCHAR2(40);
34
35 P_ITEM_ID NUMBER;
36
37 P_SPECIFIC_ITEM VARCHAR2(81);
38
39 P_ALTERNATE_DESG VARCHAR2(10);
40
41 P_ITEM_FROM VARCHAR2(40);
42
43 P_ITEM_TO VARCHAR2(40);
44
45 P_CATEGORY_SET_ID NUMBER;
46
47 P_CATEGORY_SET VARCHAR2(40);
48
49 P_CATEGORY_FROM VARCHAR2(40);
50
51 P_CATEGORY_TO VARCHAR2(40);
52
53 P_CATEGORY_STRUCTURE_ID NUMBER;
54
55 P_PRINT_OPTION1_FLAG NUMBER;
56
57 P_GROUP_ID NUMBER;
58
59 P_CAT_BETWEEN VARCHAR2(480);
60
61 P_ASS_BETWEEN VARCHAR2(480);
62
63 P_ITEM_STRUCTURE_ID NUMBER;
64
65 P_ALT_OPTION_TYPE NUMBER;
66
67 P_ALT_OPTION VARCHAR2(40);
68
69 P_QTY_PRECISION NUMBER;
70
71 P_ORDER_BY_TYPE NUMBER;
72
73 P_SEQUENCE_ID NUMBER := 0;
74
75 P_ORDER_BY VARCHAR2(40);
76
77 P_MSG_BUF VARCHAR2(80);
78
79 P_ERR_MSG VARCHAR2(80);
80
81 P_PLAN_FACTOR_FLAG NUMBER;
82
83 P_PLAN_FACTOR VARCHAR2(4);
84
85 P_DEBUG VARCHAR2(2);
86
87 FUNCTION g_filter RETURN boolean;
88
89 FUNCTION GET_REV(D3_COMPO_ORG_ID IN NUMBER
90 ,D3_COMPONENT_ITEM_ID IN NUMBER) RETURN VARCHAR2;
91
92 FUNCTION BEFOREREPORT RETURN BOOLEAN;
93
94 FUNCTION GET_ELE_DESC(M_BOM_ITEM_TYPE IN NUMBER
95 ,D2_ELEMENT_NAME IN VARCHAR2
96 ,M_ITEM_CATALOG_GROUP_ID IN NUMBER) RETURN VARCHAR2;
97
98 FUNCTION AFTERREPORT RETURN BOOLEAN;
99
100 PROCEDURE EXPLODER_USEREXIT(VERIFY_FLAG IN NUMBER
101 ,ORG_ID IN NUMBER
102 ,ORDER_BY IN NUMBER
103 ,GRP_ID IN NUMBER
104 ,SESSION_ID IN NUMBER
105 ,LEVELS_TO_EXPLODE IN NUMBER
106 ,BOM_OR_ENG IN NUMBER
107 ,IMPL_FLAG IN NUMBER
108 ,PLAN_FACTOR_FLAG IN NUMBER
109 ,EXPLODE_OPTION IN NUMBER
110 ,MODULE IN NUMBER
111 ,CST_TYPE_ID IN NUMBER
112 ,STD_COMP_FLAG IN NUMBER
113 ,EXPL_QTY IN NUMBER
114 ,ITEM_ID IN NUMBER
115 ,ALT_DESG IN VARCHAR2
116 ,COMP_CODE IN VARCHAR2
117 ,REV_DATE IN VARCHAR2
118 ,ERR_MSG OUT NOCOPY VARCHAR2
119 ,ERROR_CODE OUT NOCOPY NUMBER);
120
121 PROCEDURE EXPLOSION_REPORT(VERIFY_FLAG IN NUMBER
122 ,ORG_ID IN NUMBER
123 ,ORDER_BY IN NUMBER
124 ,LIST_ID IN NUMBER
125 ,GRP_ID IN NUMBER
126 ,SESSION_ID IN NUMBER
127 ,LEVELS_TO_EXPLODE IN NUMBER
128 ,BOM_OR_ENG IN NUMBER
129 ,IMPL_FLAG IN NUMBER
130 ,PLAN_FACTOR_FLAG IN NUMBER
131 ,INCL_LT_FLAG IN NUMBER
132 ,EXPLODE_OPTION IN NUMBER
133 ,MODULE IN NUMBER
134 ,CST_TYPE_ID IN NUMBER
135 ,STD_COMP_FLAG IN NUMBER
136 ,EXPL_QTY IN NUMBER
137 ,REPORT_OPTION IN NUMBER
138 ,REQ_ID IN NUMBER
139 ,CST_RLP_ID IN NUMBER
140 ,LOCK_FLAG IN NUMBER
141 ,ROLLUP_OPTION IN NUMBER
142 ,ALT_RTG_DESG IN VARCHAR2
143 ,ALT_DESG IN VARCHAR2
144 ,REV_DATE IN VARCHAR2
145 ,ERR_MSG OUT NOCOPY VARCHAR2
146 ,ERROR_CODE OUT NOCOPY NUMBER);
147
148 PROCEDURE EXPLODERS(VERIFY_FLAG IN NUMBER
149 ,ONLINE_FLAG IN NUMBER
150 ,ORG_ID IN NUMBER
151 ,ORDER_BY IN NUMBER
152 ,GRP_ID IN NUMBER
153 ,SESSION_ID IN NUMBER
154 ,L_LEVELS_TO_EXPLODE IN NUMBER
155 ,BOM_OR_ENG IN NUMBER
156 ,IMPL_FLAG IN NUMBER
157 ,PLAN_FACTOR_FLAG IN NUMBER
158 ,INCL_LT_FLAG IN NUMBER
159 ,L_EXPLODE_OPTION IN NUMBER
160 ,MODULE IN NUMBER
161 ,CST_TYPE_ID IN NUMBER
162 ,STD_COMP_FLAG IN NUMBER
163 ,REV_DATE IN VARCHAR2
164 ,ERR_MSG OUT NOCOPY VARCHAR2
165 ,ERROR_CODE OUT NOCOPY NUMBER);
166
167 PROCEDURE LOOPSTR2MSG(GRP_ID IN NUMBER
168 ,VERIFY_MSG OUT NOCOPY VARCHAR2);
169
170 END BOM_BOMRBOMC_XMLP_PKG;
171