[Home] [Help]
PACKAGE: APPS.INV_ITEM_UTIL
Source
1 PACKAGE INV_ITEM_UTIL AUTHID CURRENT_USER AS
2 /* $Header: INVVITUS.pls 120.3 2007/11/08 21:43:34 mantyaku ship $ */
3
4 -- ------------------------------------------------------
5 -- -------------------- Global types --------------------
6 -- ------------------------------------------------------
7
8 TYPE Appl_Inst_type IS RECORD
9 (
10 inv NUMBER, po NUMBER
11 , bom NUMBER, eng NUMBER
12 , cs NUMBER, ar NUMBER
13 , mrp NUMBER, oe NUMBER
14 , ONT NUMBER, QP NUMBER
15 , wip NUMBER, fa NUMBER
16 , jl NUMBER, WMS NUMBER
17 , CSP NUMBER, CSS NUMBER
18 , OKS NUMBER, AMS NUMBER
19 , IBA NUMBER, IBE NUMBER
20 , CUI NUMBER, XNC NUMBER
21 , CUN NUMBER, CUS NUMBER
22 , WPS NUMBER, EAM NUMBER
23 , ENI NUMBER, EGO NUMBER
24 , CSI NUMBER, CZ NUMBER
25 , FTE NUMBER, GMI NUMBER
26 , PJM_Unit_Eff_flag VARCHAR(1)
27 /* Start Bug 3713912 */ /* remove GMI */
28 , GMD NUMBER
29 , GME NUMBER
30 , GR NUMBER
31 /* End Bug 3713912 */
32 /* Bug 5015595 */
33 , XDP NUMBER
34 , ICX NUMBER --6531763
35 );
36
37 -- ----------------------------------------------------------
38 -- -------------------- Global variables --------------------
39 -- ----------------------------------------------------------
40
41 -- Variable assigned application installation statuses
42 -- upon package initialization.
43 --
44 g_Appl_Inst Appl_Inst_type;
45
46
47 -- --------------------------------------------------------
48 -- ------------------- Procedure specs --------------------
49 -- --------------------------------------------------------
50
51 --
52 -- --------- Get record conaining application installation statuses --------
53 --
54
55 FUNCTION Appl_Install
56 RETURN Appl_Inst_type;
57
58 --
59 -- --------------- Single application installation status ---------------
60 --
61
62 FUNCTION Appl_Inst_Status ( p_Appl_ID IN NUMBER )
63 RETURN VARCHAR2;
64
65 FUNCTION Appl_Inst_inv
66 RETURN NUMBER;
67
68 FUNCTION Appl_Inst_po
69 RETURN NUMBER;
70
71 FUNCTION Appl_Inst_bom
72 RETURN NUMBER;
73
74 FUNCTION Appl_Inst_eng
75 RETURN NUMBER;
76
77 FUNCTION Appl_Inst_cs
78 RETURN NUMBER;
79
80 FUNCTION Appl_Inst_ar
81 RETURN NUMBER;
82
83 FUNCTION Appl_Inst_mrp
84 RETURN NUMBER;
85
86 FUNCTION Appl_Inst_oe
87 RETURN NUMBER;
88
89 FUNCTION Appl_Inst_ONT
90 RETURN NUMBER;
91
92 FUNCTION Appl_Inst_QP
93 RETURN NUMBER;
94
95 FUNCTION Appl_Inst_wip
96 RETURN NUMBER;
97
98 FUNCTION Appl_Inst_fa
99 RETURN NUMBER;
100
101 FUNCTION Appl_Inst_jl
102 RETURN NUMBER;
103
104 FUNCTION Appl_Inst_WMS
105 RETURN NUMBER;
106
107 FUNCTION Appl_Inst_CSP
108 RETURN NUMBER;
109
110 FUNCTION Appl_Inst_CSS
111 RETURN NUMBER;
112
113 FUNCTION Appl_Inst_OKS
114 RETURN NUMBER;
115
116 FUNCTION Appl_Inst_AMS
117 RETURN NUMBER;
118
119 FUNCTION Appl_Inst_IBA
120 RETURN NUMBER;
121
122 FUNCTION Appl_Inst_IBE
123 RETURN NUMBER;
124
125 FUNCTION Appl_Inst_CUI
126 RETURN NUMBER;
127
128 FUNCTION Appl_Inst_XNC
129 RETURN NUMBER;
130
131 FUNCTION Appl_Inst_CUN
132 RETURN NUMBER;
133
134 FUNCTION Appl_Inst_CUS
135 RETURN NUMBER;
136
137 FUNCTION Appl_Inst_WPS
138 RETURN NUMBER;
139
140 FUNCTION Appl_Inst_EAM
141 RETURN NUMBER;
142
143 --Bug: 2718703
144 FUNCTION Appl_Inst_ENI
145 RETURN NUMBER;
146
147 --Bug: 2728939
148 FUNCTION Appl_Inst_EGO
149 RETURN NUMBER;
150
151 FUNCTION Appl_Inst_CSI
152 RETURN NUMBER;
153
154 FUNCTION Appl_Inst_CZ
155 RETURN NUMBER;
156
157 --Bug:2691174
158 FUNCTION Appl_Inst_FTE
159 RETURN NUMBER;
160 FUNCTION Appl_Inst_GMI
161 RETURN NUMBER;
162 /* Start Bug 3713912 */ /* remove GMI function */
163 FUNCTION Appl_Inst_GMD
164 RETURN NUMBER;
165 FUNCTION Appl_Inst_GME
166 RETURN NUMBER;
167 FUNCTION Appl_Inst_GR
168 RETURN NUMBER;
169
170
171 /* End Bug 3713912 */
172 --
173 -- PJM_Unit_Eff_Enabled
174 --
175
176 FUNCTION PJM_Unit_Eff_Enabled
177 RETURN VARCHAR2;
178
179 FUNCTION Appl_Inst_ICX
180 RETURN NUMBER;
181
182
183 FUNCTION Object_Exists(p_object_type VARCHAR2,p_object_name VARCHAR2)
184 RETURN VARCHAR2;
185
186 FUNCTION create_inv_mvlog(p_table_name varchar2) /*fix for bug:6133992 */
187 RETURN NUMBER;
188
189 END INV_ITEM_UTIL;