[Home] [Help]
PACKAGE: APPS.AHL_RM_MATERIAL_AS_PVT
Source
1 PACKAGE AHL_RM_MATERIAL_AS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMTLS.pls 120.1.12020000.2 2012/12/07 00:48:16 sareepar 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 --sukhwsin: Added attributes for SB Effectivity Starts
48 MC_NAME VARCHAR2(80),
49 MC_ID NUMBER,
50 MC_POSITION VARCHAR2(80),
51 MC_POSITION_KEY NUMBER
52 --sukhwsin: Added attributes for SB Effectivity ends
53 );
54 TYPE material_req_tbl_type IS TABLE OF material_req_rec_type INDEX BY BINARY_INTEGER;
55 TYPE route_efct_rec_type IS RECORD
56 (
57 ROUTE_EFFECTIVITY_ID NUMBER
58 , ROUTE_NO VARCHAR2(30)
59 , INVENTORY_ITEM_ID NUMBER
60 , INVENTORY_MASTER_ORG_ID NUMBER
61 , ITEM_NUMBER VARCHAR2(40)
62 , DESCRIPTION VARCHAR2(240)
63 , ORGANIZATION_CODE VARCHAR2(3)
64 , MC_ID NUMBER
65 , MC_NAME VARCHAR2(80)
66 , MC_VERSION_NUMBER NUMBER
67 , MC_REVISION VARCHAR2(30)
68 , MC_DESCRIPTION VARCHAR2(240)
69 , MC_HEADER_ID NUMBER
70 , LAST_UPDATE_DATE DATE
71 , LAST_UPDATED_BY NUMBER(15)
72 , CREATION_DATE DATE
73 , CREATED_BY NUMBER(15)
74 , LAST_UPDATE_LOGIN NUMBER(15)
75 , OBJECT_VERSION_NUMBER NUMBER
76 , SECURITY_GROUP_ID NUMBER
77 , ATTRIBUTE_CATEGORY VARCHAR2(30)
78 , ATTRIBUTE1 VARCHAR2(150)
79 , ATTRIBUTE2 VARCHAR2(150)
80 , ATTRIBUTE3 VARCHAR2(150)
81 , ATTRIBUTE4 VARCHAR2(150)
82 , ATTRIBUTE5 VARCHAR2(150)
83 , ATTRIBUTE6 VARCHAR2(150)
84 , ATTRIBUTE7 VARCHAR2(150)
85 , ATTRIBUTE8 VARCHAR2(150)
86 , ATTRIBUTE9 VARCHAR2(150)
87 , ATTRIBUTE10 VARCHAR2(150)
88 , ATTRIBUTE11 VARCHAR2(150)
89 , ATTRIBUTE12 VARCHAR2(150)
90 , ATTRIBUTE13 VARCHAR2(150)
91 , ATTRIBUTE14 VARCHAR2(150)
92 , ATTRIBUTE15 VARCHAR2(150)
93 , DML_OPERATION VARCHAR2(1)
94 )
95 ;
96 TYPE route_efct_tbl_type IS TABLE OF route_efct_rec_type INDEX BY BINARY_INTEGER;
97 -- Start of Comments
98 -- Procedure name : process_material_req
99 -- Type : Private
100 -- Pre-reqs :
101 -- Function :
102 -- Parameters :
103 --
104 -- Standard IN Parameters :
105 -- p_api_version NUMBER Required
106 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
107 -- p_commit VARCHAR2 Default FND_API.G_FALSE
108 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
109 -- p_default VARCHAR2 Default FND_API.G_TRUE
110 -- p_module_type VARCHAR2 Default NULL
111 --
112 -- Standard OUT Parameters :
113 -- x_return_status VARCHAR2 Required
114 -- x_msg_count NUMBER Required
115 -- x_msg_data VARCHAR2 Required
116 --
117 -- process_material_req IN parameters:
118 -- p_object_id NUMBER Required
119 -- p_association_type VARCHAR2 Required
120 --
121 -- process_material_req IN OUT parameters:
122 -- p_x_material_req_tbl material_req_tbl_type Required
123 --
124 -- process_material_req OUT parameters:
125 -- None.
126 --
127 --
128 -- Version :
129 -- Current version 1.0
130 --
131 -- End of Comments
132 PROCEDURE process_material_req
133 (
134 p_api_version IN NUMBER := '1.0',
135 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138 p_default IN VARCHAR2 := FND_API.G_FALSE,
139 p_module_type IN VARCHAR2 := NULL,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_x_material_req_tbl IN OUT NOCOPY material_req_tbl_type,
144 p_object_id IN NUMBER,
145 p_association_type IN VARCHAR2
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 PROCEDURE process_route_efcts
182 (
183 p_api_version IN NUMBER := 1.0,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_default IN VARCHAR2 := FND_API.G_FALSE,
188 p_module_type IN VARCHAR2 := NULL,
189 p_object_id IN NUMBER,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_x_route_efct_tbl IN OUT NOCOPY route_efct_tbl_type
194 );
195 END AHL_RM_MATERIAL_AS_PVT;