DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PKG dependencies on FND_API

Line 11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

7: -- NOTE :
8: -- End of Comments
9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

8: -- End of Comments
9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 13: CREATION_DATE DATE := FND_API.G_MISS_DATE,

9: TYPE internal_user_hooks_rec IS RECORD
10: (
11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

10: (
11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

11: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

12: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

Line 17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

13: CREATION_DATE DATE := FND_API.G_MISS_DATE,
14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

14: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

Line 19: TASK_ID NUMBER := FND_API.G_MISS_NUM,

15: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

16: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

17: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

18: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

19: TASK_ID NUMBER := FND_API.G_MISS_NUM,
20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,

20: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

21: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

22: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

23: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

24: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

25: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

26: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

27: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

28: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

29: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

30: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

31: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

32: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

33: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

35: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

36: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

37: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

Line 42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

38: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

39: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
47: );

Line 44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

40: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
47: );
48: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;

Line 45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

41: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
47: );
48: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;
49: PROCEDURE Insert_Row(

Line 46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR

42: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
46: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
47: );
48: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;
49: PROCEDURE Insert_Row(
50: px_REQUIREMENT_HEADER_ID IN OUT NOCOPY NUMBER,

Line 88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,

84: p_TIMEZONE_ID NUMBER,
85: p_DESTINATION_SUBINVENTORY VARCHAR2);
86:
87: PROCEDURE Update_Row(
88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,

Line 89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,

85: p_DESTINATION_SUBINVENTORY VARCHAR2);
86:
87: PROCEDURE Update_Row(
88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,

Line 90: p_CREATION_DATE DATE := fnd_api.g_miss_date,

86:
87: PROCEDURE Update_Row(
88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,

Line 91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,

87: PROCEDURE Update_Row(
88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,

Line 92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,

88: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,

Line 93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,

89: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,

Line 94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,

90: p_CREATION_DATE DATE := fnd_api.g_miss_date,
91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,

Line 95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,

91: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,

Line 96: p_TASK_ID NUMBER := fnd_api.g_miss_num,

92: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,

Line 97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,

93: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,
94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,

Line 98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,

94: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,
95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,

Line 99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,

95: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,
96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,

Line 100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,

96: p_TASK_ID NUMBER := fnd_api.g_miss_num,
97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,

Line 101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,

97: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,
98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,

Line 102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,

98: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,
99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,

Line 103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,

99: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,
100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,

Line 104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,

100: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,
101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,

Line 105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,

101: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,

Line 106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,

102: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,

Line 107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,

103: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,

Line 108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,

104: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,

Line 109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,

105: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,

Line 110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,

106: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,

Line 111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,

107: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,

Line 112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,

108: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,

Line 113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,

109: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,

Line 114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,

110: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,

Line 115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,

111: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,

Line 116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,

112: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,

Line 117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,

113: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,

Line 118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,

114: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,

Line 119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,

115: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);

Line 120: p_resource_id NUMBER := fnd_api.g_miss_num,

116: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);
124:

Line 121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,

117: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);
124:
125: PROCEDURE Lock_Row(

Line 122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,

118: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);
124:
125: PROCEDURE Lock_Row(
126: p_REQUIREMENT_HEADER_ID NUMBER,

Line 123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);

119: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
120: p_resource_id NUMBER := fnd_api.g_miss_num,
121: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
122: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
123: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char);
124:
125: PROCEDURE Lock_Row(
126: p_REQUIREMENT_HEADER_ID NUMBER,
127: p_CREATED_BY NUMBER,