[Home] [Help]
PACKAGE: APPS.MRP_SRC_ASSIGNMENT_PUB
Source
1 PACKAGE MRP_Src_Assignment_PUB AUTHID CURRENT_USER AS
2 /* $Header: MRPPASNS.pls 115.2 99/07/16 12:31:38 porting ship $ */
3
4 -- Assignment_Set record type
5
6 TYPE Assignment_Set_Rec_Type IS RECORD
7 ( Assignment_Set_Id NUMBER := FND_API.G_MISS_NUM
8 , Assignment_Set_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
9 , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10 , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11 , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12 , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13 , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14 , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15 , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16 , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17 , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18 , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19 , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20 , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21 , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22 , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23 , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24 , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
25 , Created_By NUMBER := FND_API.G_MISS_NUM
26 , Creation_Date DATE := FND_API.G_MISS_DATE
27 , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
28 , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
29 , Last_Update_Date DATE := FND_API.G_MISS_DATE
30 , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
31 , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
32 , Program_Id NUMBER := FND_API.G_MISS_NUM
33 , Program_Update_Date DATE := FND_API.G_MISS_DATE
34 , Request_Id NUMBER := FND_API.G_MISS_NUM
35 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
36 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
38 );
39
40 TYPE Assignment_Set_Tbl_Type IS TABLE OF Assignment_Set_Rec_Type
41 INDEX BY BINARY_INTEGER;
42
43 -- Assignment_Set value record type
44
45 TYPE Assignment_Set_Val_Rec_Type IS RECORD
46 ( null_element NUMBER := NULL
47 );
48
49 TYPE Assignment_Set_Val_Tbl_Type IS TABLE OF Assignment_Set_Val_Rec_Type
50 INDEX BY BINARY_INTEGER;
51
52 -- Assignment record type
53
54 TYPE Assignment_Rec_Type IS RECORD
55 ( Assignment_Id NUMBER := FND_API.G_MISS_NUM
56 , Assignment_Set_Id NUMBER := FND_API.G_MISS_NUM
57 , Assignment_Type NUMBER := FND_API.G_MISS_NUM
58 , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
59 , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
60 , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
61 , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
62 , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
63 , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
64 , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
65 , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
66 , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
67 , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
68 , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
69 , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
70 , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
71 , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
72 , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
73 , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
74 , Category_Id NUMBER := FND_API.G_MISS_NUM
75 , Category_Set_Id NUMBER := FND_API.G_MISS_NUM
76 , Created_By NUMBER := FND_API.G_MISS_NUM
77 , Creation_Date DATE := FND_API.G_MISS_DATE
78 , Customer_Id NUMBER := FND_API.G_MISS_NUM
79 , Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
80 , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
81 , Last_Update_Date DATE := FND_API.G_MISS_DATE
82 , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
83 , Organization_Id NUMBER := FND_API.G_MISS_NUM
84 , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
85 , Program_Id NUMBER := FND_API.G_MISS_NUM
86 , Program_Update_Date DATE := FND_API.G_MISS_DATE
87 , Request_Id NUMBER := FND_API.G_MISS_NUM
88 , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
89 , Ship_To_Site_Id NUMBER := FND_API.G_MISS_NUM
90 , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
91 , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
92 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
93 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
95 );
96
97 TYPE Assignment_Tbl_Type IS TABLE OF Assignment_Rec_Type
98 INDEX BY BINARY_INTEGER;
99
100 -- Assignment value record type
101
102 TYPE Assignment_Val_Rec_Type IS RECORD
103 ( null_element NUMBER := NULL
104 );
105
106 TYPE Assignment_Val_Tbl_Type IS TABLE OF Assignment_Val_Rec_Type
107 INDEX BY BINARY_INTEGER;
108
109 -- Variables representing missing records and tables
110
111 G_MISS_ASSIGNMENT_SET_REC Assignment_Set_Rec_Type;
112 G_MISS_ASSIGNMENT_SET_VAL_REC Assignment_Set_Val_Rec_Type;
113 G_MISS_ASSIGNMENT_SET_TBL Assignment_Set_Tbl_Type;
114 G_MISS_ASSIGNMENT_SET_VAL_TBL Assignment_Set_Val_Tbl_Type;
115 G_MISS_ASSIGNMENT_REC Assignment_Rec_Type;
116 G_MISS_ASSIGNMENT_VAL_REC Assignment_Val_Rec_Type;
117 G_MISS_ASSIGNMENT_TBL Assignment_Tbl_Type;
118 G_MISS_ASSIGNMENT_VAL_TBL Assignment_Val_Tbl_Type;
119
120 -- Start of Comments
121 -- API name Process_Assignment
122 -- Type Public
123 -- Function
124 --
125 -- Pre-reqs
126 --
127 -- Parameters
128 --
129 -- Version Current version = 1.0
130 -- Initial version = 1.0
131 --
132 -- Notes
133 --
134 -- End of Comments
135
136 PROCEDURE Process_Assignment
137 ( p_api_version_number IN NUMBER
138 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
139 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
140 , p_commit IN VARCHAR2 := FND_API.G_FALSE
141 , x_return_status OUT VARCHAR2
142 , x_msg_count OUT NUMBER
143 , x_msg_data OUT VARCHAR2
144 , p_Assignment_Set_rec IN Assignment_Set_Rec_Type :=
145 G_MISS_ASSIGNMENT_SET_REC
146 , p_Assignment_Set_val_rec IN Assignment_Set_Val_Rec_Type :=
147 G_MISS_ASSIGNMENT_SET_VAL_REC
148 , p_Assignment_tbl IN Assignment_Tbl_Type :=
149 G_MISS_ASSIGNMENT_TBL
150 , p_Assignment_val_tbl IN Assignment_Val_Tbl_Type :=
151 G_MISS_ASSIGNMENT_VAL_TBL
152 , x_Assignment_Set_rec OUT Assignment_Set_Rec_Type
153 , x_Assignment_Set_val_rec OUT Assignment_Set_Val_Rec_Type
154 , x_Assignment_tbl OUT Assignment_Tbl_Type
155 , x_Assignment_val_tbl OUT Assignment_Val_Tbl_Type
156 );
157
158 -- Start of Comments
159 -- API name Lock_Assignment
160 -- Type Public
161 -- Function
162 --
163 -- Pre-reqs
164 --
165 -- Parameters
166 --
167 -- Version Current version = 1.0
168 -- Initial version = 1.0
169 --
170 -- Notes
171 --
172 -- End of Comments
173
174 PROCEDURE Lock_Assignment
175 ( p_api_version_number IN NUMBER
176 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
178 , x_return_status OUT VARCHAR2
179 , x_msg_count OUT NUMBER
180 , x_msg_data OUT VARCHAR2
181 , p_Assignment_Set_rec IN Assignment_Set_Rec_Type :=
182 G_MISS_ASSIGNMENT_SET_REC
183 , p_Assignment_Set_val_rec IN Assignment_Set_Val_Rec_Type :=
184 G_MISS_ASSIGNMENT_SET_VAL_REC
185 , p_Assignment_tbl IN Assignment_Tbl_Type :=
186 G_MISS_ASSIGNMENT_TBL
187 , p_Assignment_val_tbl IN Assignment_Val_Tbl_Type :=
188 G_MISS_ASSIGNMENT_VAL_TBL
189 , x_Assignment_Set_rec OUT Assignment_Set_Rec_Type
190 , x_Assignment_Set_val_rec OUT Assignment_Set_Val_Rec_Type
191 , x_Assignment_tbl OUT Assignment_Tbl_Type
192 , x_Assignment_val_tbl OUT Assignment_Val_Tbl_Type
193 );
194
195 -- Start of Comments
196 -- API name Get_Assignment
197 -- Type Public
198 -- Function
199 --
200 -- Pre-reqs
201 --
202 -- Parameters
203 --
204 -- Version Current version = 1.0
205 -- Initial version = 1.0
206 --
207 -- Notes
208 --
209 -- End of Comments
210
211 PROCEDURE Get_Assignment
212 ( p_api_version_number IN NUMBER
213 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
215 , x_return_status OUT VARCHAR2
216 , x_msg_count OUT NUMBER
217 , x_msg_data OUT VARCHAR2
218 , p_Assignment_Set_Id IN NUMBER :=
219 FND_API.G_MISS_NUM
220 , x_Assignment_Set_rec OUT Assignment_Set_Rec_Type
221 , x_Assignment_Set_val_rec OUT Assignment_Set_Val_Rec_Type
222 , x_Assignment_tbl OUT Assignment_Tbl_Type
223 , x_Assignment_val_tbl OUT Assignment_Val_Tbl_Type
224 );
225
226 END MRP_Src_Assignment_PUB;