APPS.MRP_SRC_ASSIGNMENT_PUB dependencies on FND_API

Line 7: ( Assignment_Set_Id NUMBER := FND_API.G_MISS_NUM

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

Line 8: , Assignment_Set_Name VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 9: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 10: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 11: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 12: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 13: , Attribute13 VARCHAR2(150) := 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

Line 14: , Attribute14 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

Line 15: , Attribute15 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

Line 16: , Attribute2 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

Line 17: , Attribute3 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

Line 18: , Attribute4 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

Line 19: , Attribute5 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

Line 20: , Attribute6 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

Line 21: , Attribute7 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

Line 22: , Attribute8 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

Line 23: , Attribute9 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

Line 24: , Attribute_Category VARCHAR2(30) := 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

Line 25: , Created_By NUMBER := FND_API.G_MISS_NUM

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

Line 26: , Creation_Date DATE := FND_API.G_MISS_DATE

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

Line 27: , Description VARCHAR2(80) := 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

Line 28: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

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

Line 29: , Last_Update_Date DATE := FND_API.G_MISS_DATE

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

Line 30: , Last_Update_Login 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

Line 31: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

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

Line 32: , Program_Id NUMBER := FND_API.G_MISS_NUM

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

Line 33: , Program_Update_Date DATE := FND_API.G_MISS_DATE

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

Line 34: , Request_Id NUMBER := FND_API.G_MISS_NUM

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: );

Line 35: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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:

Line 36: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 37: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

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;

Line 55: ( Assignment_Id NUMBER := FND_API.G_MISS_NUM

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

Line 56: , Assignment_Set_Id NUMBER := FND_API.G_MISS_NUM

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

Line 57: , Assignment_Type NUMBER := FND_API.G_MISS_NUM

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

Line 58: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 59: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 60: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 61: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 62: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

Line 63: , Attribute14 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

Line 64: , Attribute15 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

Line 65: , Attribute2 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

Line 66: , Attribute3 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

Line 67: , Attribute4 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

Line 68: , Attribute5 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

Line 69: , Attribute6 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

Line 70: , Attribute7 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

Line 71: , Attribute8 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

Line 72: , Attribute9 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

Line 73: , Attribute_Category VARCHAR2(30) := 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

Line 74: , Category_Id NUMBER := FND_API.G_MISS_NUM

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

Line 75: , Category_Set_Id NUMBER := FND_API.G_MISS_NUM

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

Line 76: , Created_By NUMBER := FND_API.G_MISS_NUM

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

Line 77: , Creation_Date DATE := FND_API.G_MISS_DATE

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

Line 78: , Customer_Id NUMBER := FND_API.G_MISS_NUM

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

Line 79: , Inventory_Item_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

Line 80: , Last_Updated_By 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

Line 81: , Last_Update_Date DATE := FND_API.G_MISS_DATE

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

Line 82: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

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

Line 83: , Organization_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

Line 84: , Program_Application_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

Line 85: , Program_Id 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

Line 86: , Program_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

Line 87: , Request_Id 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

Line 88: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR

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

Line 89: , Ship_To_Site_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

Line 90: , Sourcing_Rule_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

Line 91: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM

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: );

Line 92: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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:

Line 93: , db_flag VARCHAR2(1) := 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

Line 94: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

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;

Line 138: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 139: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

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

Line 140: , p_commit IN VARCHAR2 := FND_API.G_FALSE

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 :=

Line 176: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 177: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

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 :=

Line 213: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 214: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

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 :=

Line 219: FND_API.G_MISS_NUM

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