[Home] [Help]
PACKAGE: APPS.AHL_RM_MATERIAL_AS_PVT
Source
1 PACKAGE AHL_RM_MATERIAL_AS_PVT AS
2 /* $Header: AHLVMTLS.pls 120.1 2008/01/30 05:18:11 pdoki ship $ */
3
4 --modify the existing material record type to accommodate extra fields of disposition list
5 TYPE material_req_rec_type IS RECORD
6 (
7 RT_OPER_MATERIAL_ID NUMBER,
8 OBJECT_VERSION_NUMBER NUMBER,
9 ITEM_GROUP_ID NUMBER,
10 ITEM_GROUP_NAME VARCHAR2(80),
11 ITEM_NUMBER VARCHAR2(40),
12 INVENTORY_ITEM_ID NUMBER,
13 INVENTORY_ORG_ID NUMBER,
14 UOM VARCHAR2(25),
15 UOM_CODE VARCHAR2(3),
16 QUANTITY NUMBER,
17 ATTRIBUTE_CATEGORY VARCHAR2(30),
18 ATTRIBUTE1 VARCHAR2(150),
19 ATTRIBUTE2 VARCHAR2(150),
20 ATTRIBUTE3 VARCHAR2(150),
21 ATTRIBUTE4 VARCHAR2(150),
22 ATTRIBUTE5 VARCHAR2(150),
23 ATTRIBUTE6 VARCHAR2(150),
24 ATTRIBUTE7 VARCHAR2(150),
25 ATTRIBUTE8 VARCHAR2(150),
26 ATTRIBUTE9 VARCHAR2(150),
27 ATTRIBUTE10 VARCHAR2(150),
28 ATTRIBUTE11 VARCHAR2(150),
29 ATTRIBUTE12 VARCHAR2(150),
30 ATTRIBUTE13 VARCHAR2(150),
31 ATTRIBUTE14 VARCHAR2(150),
32 ATTRIBUTE15 VARCHAR2(150),
33 LAST_UPDATE_DATE DATE,
34 LAST_UPDATED_BY NUMBER(15),
35 CREATION_DATE DATE,
36 CREATED_BY NUMBER(15),
37 LAST_UPDATE_LOGIN NUMBER(15),
38 DML_OPERATION VARCHAR2(1),
39 POSITION_PATH VARCHAR2(4000),
40 POSITION_PATH_ID NUMBER,
41 ITEM_COMP_DETAIL_ID NUMBER,
42 EXCLUDE_FLAG VARCHAR2(1),
43 REWORK_PERCENT NUMBER,
44 REPLACE_PERCENT NUMBER,
45 COMP_MATERIAL_FLAG VARCHAR2(1),
46 IN_SERVICE VARCHAR2(1) --pdoki added for OGMA 105 issue
47 );
48
49 TYPE material_req_tbl_type IS TABLE OF material_req_rec_type INDEX BY BINARY_INTEGER;
50
51 TYPE route_efct_rec_type IS RECORD
52 (
53 ROUTE_EFFECTIVITY_ID NUMBER
54 , ROUTE_NO VARCHAR2(30)
55 , INVENTORY_ITEM_ID NUMBER
56 , INVENTORY_MASTER_ORG_ID NUMBER
57 , ITEM_NUMBER VARCHAR2(40)
58 , DESCRIPTION VARCHAR2(240)
59 , ORGANIZATION_CODE VARCHAR2(3)
60 , MC_ID NUMBER
61 , MC_NAME VARCHAR2(80)
62 , MC_VERSION_NUMBER NUMBER
63 , MC_REVISION VARCHAR2(30)
64 , MC_DESCRIPTION VARCHAR2(240)
65 , MC_HEADER_ID NUMBER
66 , LAST_UPDATE_DATE DATE
67 , LAST_UPDATED_BY NUMBER(15)
68 , CREATION_DATE DATE
69 , CREATED_BY NUMBER(15)
70 , LAST_UPDATE_LOGIN NUMBER(15)
71 , OBJECT_VERSION_NUMBER NUMBER
72 , SECURITY_GROUP_ID NUMBER
73 , ATTRIBUTE_CATEGORY VARCHAR2(30)
74 , ATTRIBUTE1 VARCHAR2(150)
75 , ATTRIBUTE2 VARCHAR2(150)
76 , ATTRIBUTE3 VARCHAR2(150)
77 , ATTRIBUTE4 VARCHAR2(150)
78 , ATTRIBUTE5 VARCHAR2(150)
79 , ATTRIBUTE6 VARCHAR2(150)
80 , ATTRIBUTE7 VARCHAR2(150)
81 , ATTRIBUTE8 VARCHAR2(150)
82 , ATTRIBUTE9 VARCHAR2(150)
83 , ATTRIBUTE10 VARCHAR2(150)
84 , ATTRIBUTE11 VARCHAR2(150)
85 , ATTRIBUTE12 VARCHAR2(150)
86 , ATTRIBUTE13 VARCHAR2(150)
87 , ATTRIBUTE14 VARCHAR2(150)
88 , ATTRIBUTE15 VARCHAR2(150)
89 , DML_OPERATION VARCHAR2(1)
90 )
91 ;
92
93 TYPE route_efct_tbl_type IS TABLE OF route_efct_rec_type INDEX BY BINARY_INTEGER;
94
95 -- Start of Comments
96 -- Procedure name : process_material_req
97 -- Type : Private
98 -- Pre-reqs :
99 -- Function :
100 -- Parameters :
101 --
102 -- Standard IN Parameters :
103 -- p_api_version NUMBER Required
104 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
105 -- p_commit VARCHAR2 Default FND_API.G_FALSE
106 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
107 -- p_default VARCHAR2 Default FND_API.G_TRUE
108 -- p_module_type VARCHAR2 Default NULL
109 --
110 -- Standard OUT Parameters :
111 -- x_return_status VARCHAR2 Required
112 -- x_msg_count NUMBER Required
113 -- x_msg_data VARCHAR2 Required
114 --
115 -- process_material_req IN parameters:
116 -- p_object_id NUMBER Required
117 -- p_association_type VARCHAR2 Required
118 --
119 -- process_material_req IN OUT parameters:
120 -- p_x_material_req_tbl material_req_tbl_type Required
121 --
122 -- process_material_req OUT parameters:
123 -- None.
124 --
125 --
126 -- Version :
127 -- Current version 1.0
128 --
129 -- End of Comments
130
131 PROCEDURE process_material_req
132 (
133 p_api_version IN NUMBER := '1.0',
134 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137 p_default IN VARCHAR2 := FND_API.G_FALSE,
138 p_module_type IN VARCHAR2 := NULL,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_x_material_req_tbl IN OUT NOCOPY material_req_tbl_type,
143 p_object_id IN NUMBER,
144 p_association_type IN VARCHAR2
145 );
146
147 -- Start of Comments
148 -- Procedure name : process_route_efct_
149 -- Type : Private
150 -- Pre-reqs :
151 -- Function :
152 -- Parameters :
153 --
154 -- Standard IN Parameters :
155 -- p_api_version NUMBER Required
156 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
157 -- p_commit VARCHAR2 Default FND_API.G_FALSE
158 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
159 -- p_default VARCHAR2 Default FND_API.G_TRUE
160 -- p_module_type VARCHAR2 Default NULL
161 --
162 -- Standard OUT Parameters :
163 -- x_return_status VARCHAR2 Required
164 -- x_msg_count NUMBER Required
165 -- x_msg_data VARCHAR2 Required
166 --
167 -- process_route_efct_ IN parameters:
168 -- p_object_id NUMBER Required
169 --
170 -- process_route_efct_ IN OUT parameters:
171 -- p_x_route_efct_tbl route_efct_tbl_type Required
172 --
173 -- process_route_efct OUT parameters:
174 -- None.
175 --
176 --
177 -- Version :
178 -- Current version 1.0
179 --
180 -- End of Comments
181
182 PROCEDURE process_route_efcts
183 (
184 p_api_version IN NUMBER := 1.0,
185 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
186 p_commit IN VARCHAR2 := FND_API.G_FALSE,
187 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188 p_default IN VARCHAR2 := FND_API.G_FALSE,
189 p_module_type IN VARCHAR2 := NULL,
190 p_object_id IN NUMBER,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_x_route_efct_tbl IN OUT NOCOPY route_efct_tbl_type
195 );
196
197
198 END AHL_RM_MATERIAL_AS_PVT;
199