APPS.MRP_SOURCING_RULE_PUB dependencies on FND_API

Line 7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM

3:
4: -- Sourcing_Rule record type
5:
6: TYPE Sourcing_Rule_Rec_Type IS RECORD
7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

4: -- Sourcing_Rule record type
5:
6: TYPE Sourcing_Rule_Rec_Type IS RECORD
7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

5:
6: TYPE Sourcing_Rule_Rec_Type IS RECORD
7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

6: TYPE Sourcing_Rule_Rec_Type IS RECORD
7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

7: ( Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

8: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

9: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

10: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

11: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

12: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

13: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

14: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

15: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

16: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM

Line 21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

17: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE

Line 22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

18: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

19: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

Line 24: , Created_By NUMBER := FND_API.G_MISS_NUM

20: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE

Line 25: , Creation_Date DATE := FND_API.G_MISS_DATE

21: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

Line 26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR

22: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM

Line 27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

23: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM

Line 28: , Last_Update_Date DATE := FND_API.G_MISS_DATE

24: , Created_By NUMBER := FND_API.G_MISS_NUM
25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

Line 29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

25: , Creation_Date DATE := FND_API.G_MISS_DATE
26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM

Line 30: , Organization_Id NUMBER := FND_API.G_MISS_NUM

26: , Description VARCHAR2(80) := FND_API.G_MISS_CHAR
27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE

Line 31: , Planning_Active NUMBER := FND_API.G_MISS_NUM

27: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM

Line 32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

28: , Last_Update_Date DATE := FND_API.G_MISS_DATE
29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 33: , Program_Id NUMBER := FND_API.G_MISS_NUM

29: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM

Line 34: , Program_Update_Date DATE := FND_API.G_MISS_DATE

30: , Organization_Id NUMBER := FND_API.G_MISS_NUM
31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM

Line 35: , Request_Id NUMBER := FND_API.G_MISS_NUM

31: , Planning_Active NUMBER := FND_API.G_MISS_NUM
32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR

32: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM

33: , Program_Id NUMBER := FND_API.G_MISS_NUM
34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 38: , Status NUMBER := FND_API.G_MISS_NUM

34: , Program_Update_Date DATE := FND_API.G_MISS_DATE
35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
42: );

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

35: , Request_Id NUMBER := FND_API.G_MISS_NUM
36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
42: );
43:

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

36: , Sourcing_Rule_Name VARCHAR2(50) := FND_API.G_MISS_CHAR
37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
42: );
43:
44: TYPE Sourcing_Rule_Tbl_Type IS TABLE OF Sourcing_Rule_Rec_Type

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

37: , Sourcing_Rule_Type NUMBER := FND_API.G_MISS_NUM
38: , Status NUMBER := FND_API.G_MISS_NUM
39: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
40: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
42: );
43:
44: TYPE Sourcing_Rule_Tbl_Type IS TABLE OF Sourcing_Rule_Rec_Type
45: INDEX BY BINARY_INTEGER;

Line 59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM

55:
56: -- Receiving_Org record type
57:
58: TYPE Receiving_Org_Rec_Type IS RECORD
59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

56: -- Receiving_Org record type
57:
58: TYPE Receiving_Org_Rec_Type IS RECORD
59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

57:
58: TYPE Receiving_Org_Rec_Type IS RECORD
59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

58: TYPE Receiving_Org_Rec_Type IS RECORD
59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

59: ( Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

60: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

61: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

62: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

63: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

64: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

65: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

66: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

67: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

68: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM

Line 73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

69: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE

Line 74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

70: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE

Line 75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

71: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE

Line 76: , Created_By NUMBER := FND_API.G_MISS_NUM

72: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
80: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

Line 77: , Creation_Date DATE := FND_API.G_MISS_DATE

73: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
80: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
81: , Last_Update_Date DATE := FND_API.G_MISS_DATE

Line 78: , Disable_Date DATE := FND_API.G_MISS_DATE

74: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Effective_Date DATE := FND_API.G_MISS_DATE

75: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , Created_By NUMBER := FND_API.G_MISS_NUM
77: , Creation_Date DATE := FND_API.G_MISS_DATE
78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Program_Application_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: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_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: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE

Line 82: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

78: , Disable_Date DATE := FND_API.G_MISS_DATE
79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM

Line 83: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

79: , Effective_Date DATE := FND_API.G_MISS_DATE
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: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM

Line 84: , Program_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: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM

Line 85: , Program_Update_Date DATE := FND_API.G_MISS_DATE

81: , Last_Update_Date DATE := FND_API.G_MISS_DATE
82: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
83: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM

82: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
83: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 87: , Request_Id NUMBER := FND_API.G_MISS_NUM

83: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM

84: , Program_Id NUMBER := FND_API.G_MISS_NUM
85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
92: );

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

85: , Program_Update_Date DATE := FND_API.G_MISS_DATE
86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
92: );
93:

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

86: , Receipt_Organization_Id NUMBER := FND_API.G_MISS_NUM
87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
92: );
93:
94: TYPE Receiving_Org_Tbl_Type IS TABLE OF Receiving_Org_Rec_Type

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

87: , Request_Id NUMBER := FND_API.G_MISS_NUM
88: , Sourcing_Rule_Id NUMBER := FND_API.G_MISS_NUM
89: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
92: );
93:
94: TYPE Receiving_Org_Tbl_Type IS TABLE OF Receiving_Org_Rec_Type
95: INDEX BY BINARY_INTEGER;

Line 109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM

105:
106: -- Shipping_Org record type
107:
108: TYPE Shipping_Org_Rec_Type IS RECORD
109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM
110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM

106: -- Shipping_Org record type
107:
108: TYPE Shipping_Org_Rec_Type IS RECORD
109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM
110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

107:
108: TYPE Shipping_Org_Rec_Type IS RECORD
109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM
110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

108: TYPE Shipping_Org_Rec_Type IS RECORD
109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM
110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

109: ( Sr_Source_Id NUMBER := FND_API.G_MISS_NUM
110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

110: , Allocation_Percent NUMBER := FND_API.G_MISS_NUM
111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

111: , Attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

112: , Attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

113: , Attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

114: , Attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

115: , Attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

116: , Attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

117: , Attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

118: , Attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

119: , Attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM

Line 124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

120: , Attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE

Line 125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

121: , Attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

Line 126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR

122: , Attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE

Line 127: , Created_By NUMBER := FND_API.G_MISS_NUM

123: , Attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

Line 128: , Creation_Date DATE := FND_API.G_MISS_DATE

124: , Attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

Line 129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM

125: , Attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM

Line 130: , Last_Update_Date DATE := FND_API.G_MISS_DATE

126: , Attribute_Category VARCHAR2(30) := FND_API.G_MISS_CHAR
127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE

Line 131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM

127: , Created_By NUMBER := FND_API.G_MISS_NUM
128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM

Line 132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM

128: , Creation_Date DATE := FND_API.G_MISS_DATE
129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM

Line 133: , Program_Id NUMBER := FND_API.G_MISS_NUM

129: , Last_Updated_By NUMBER := FND_API.G_MISS_NUM
130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 134: , Program_Update_Date DATE := FND_API.G_MISS_DATE

130: , Last_Update_Date DATE := FND_API.G_MISS_DATE
131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 135: , Rank NUMBER := FND_API.G_MISS_NUM

131: , Last_Update_Login NUMBER := FND_API.G_MISS_NUM
132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM

Line 136: , Request_Id NUMBER := FND_API.G_MISS_NUM

132: , Program_Application_Id NUMBER := FND_API.G_MISS_NUM
133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM

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

133: , Program_Id NUMBER := FND_API.G_MISS_NUM
134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM

Line 138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR

134: , Program_Update_Date DATE := FND_API.G_MISS_DATE
135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM

Line 139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM

135: , Rank NUMBER := FND_API.G_MISS_NUM
136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM

Line 140: , Source_Type NUMBER := FND_API.G_MISS_NUM

136: , Request_Id NUMBER := FND_API.G_MISS_NUM
137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM

137: , Secondary_Inventory VARCHAR2(10) := FND_API.G_MISS_CHAR
138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM

138: , Ship_Method VARCHAR2(30) := FND_API.G_MISS_CHAR
139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM

139: , Source_Organization_Id NUMBER := FND_API.G_MISS_NUM
140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM

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

140: , Source_Type NUMBER := FND_API.G_MISS_NUM
141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM
148: );

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

141: , Sr_Receipt_Id NUMBER := FND_API.G_MISS_NUM
142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM
148: );
149:

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

142: , Vendor_Id NUMBER := FND_API.G_MISS_NUM
143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM
148: );
149:
150: TYPE Shipping_Org_Tbl_Type IS TABLE OF Shipping_Org_Rec_Type

Line 147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM

143: , Vendor_Site_Id NUMBER := FND_API.G_MISS_NUM
144: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147: , Receiving_Org_index NUMBER := FND_API.G_MISS_NUM
148: );
149:
150: TYPE Shipping_Org_Tbl_Type IS TABLE OF Shipping_Org_Rec_Type
151: INDEX BY BINARY_INTEGER;

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

191: -- End of Comments
192:
193: PROCEDURE Process_Sourcing_Rule
194: ( p_api_version_number IN NUMBER
195: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
196: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
197: , p_commit IN VARCHAR2 := FND_API.G_FALSE
198: , x_return_status OUT NOCOPY VARCHAR2
199: , x_msg_count OUT NOCOPY NUMBER

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

192:
193: PROCEDURE Process_Sourcing_Rule
194: ( p_api_version_number IN NUMBER
195: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
196: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
197: , p_commit IN VARCHAR2 := FND_API.G_FALSE
198: , x_return_status OUT NOCOPY VARCHAR2
199: , x_msg_count OUT NOCOPY NUMBER
200: , x_msg_data OUT NOCOPY VARCHAR2

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

193: PROCEDURE Process_Sourcing_Rule
194: ( p_api_version_number IN NUMBER
195: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
196: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
197: , p_commit IN VARCHAR2 := FND_API.G_FALSE
198: , x_return_status OUT NOCOPY VARCHAR2
199: , x_msg_count OUT NOCOPY NUMBER
200: , x_msg_data OUT NOCOPY VARCHAR2
201: , p_Sourcing_Rule_rec IN Sourcing_Rule_Rec_Type :=

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

235: -- End of Comments
236:
237: PROCEDURE Lock_Sourcing_Rule
238: ( p_api_version_number IN NUMBER
239: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
240: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
241: , x_return_status OUT NOCOPY VARCHAR2
242: , x_msg_count OUT NOCOPY NUMBER
243: , x_msg_data OUT NOCOPY VARCHAR2

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

236:
237: PROCEDURE Lock_Sourcing_Rule
238: ( p_api_version_number IN NUMBER
239: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
240: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
241: , x_return_status OUT NOCOPY VARCHAR2
242: , x_msg_count OUT NOCOPY NUMBER
243: , x_msg_data OUT NOCOPY VARCHAR2
244: , p_Sourcing_Rule_rec IN Sourcing_Rule_Rec_Type :=

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

278: -- End of Comments
279:
280: PROCEDURE Get_Sourcing_Rule
281: ( p_api_version_number IN NUMBER
282: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
283: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
284: , x_return_status OUT NOCOPY VARCHAR2
285: , x_msg_count OUT NOCOPY NUMBER
286: , x_msg_data OUT NOCOPY VARCHAR2

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

279:
280: PROCEDURE Get_Sourcing_Rule
281: ( p_api_version_number IN NUMBER
282: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
283: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
284: , x_return_status OUT NOCOPY VARCHAR2
285: , x_msg_count OUT NOCOPY NUMBER
286: , x_msg_data OUT NOCOPY VARCHAR2
287: , p_Sourcing_Rule_Id IN NUMBER :=

Line 288: FND_API.G_MISS_NUM

284: , x_return_status OUT NOCOPY VARCHAR2
285: , x_msg_count OUT NOCOPY NUMBER
286: , x_msg_data OUT NOCOPY VARCHAR2
287: , p_Sourcing_Rule_Id IN NUMBER :=
288: FND_API.G_MISS_NUM
289: , x_Sourcing_Rule_rec OUT NOCOPY Sourcing_Rule_Rec_Type
290: , x_Sourcing_Rule_val_rec OUT NOCOPY Sourcing_Rule_Val_Rec_Type
291: , x_Receiving_Org_tbl OUT NOCOPY Receiving_Org_Tbl_Type
292: , x_Receiving_Org_val_tbl OUT NOCOPY Receiving_Org_Val_Tbl_Type