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: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM

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: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
48: );

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: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
48: );
49: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;

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: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
48: );
49: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;
50: PROCEDURE Insert_Row(

Line 47: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM

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: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
48: );
49: user_hooks_rec CSP_REQUIREMENT_HEADERS_PKG.internal_user_hooks_rec ;
50: PROCEDURE Insert_Row(
51: px_REQUIREMENT_HEADER_ID IN OUT NOCOPY NUMBER,

Line 91: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,

87: p_SHIP_TO_CONTACT_ID NUMBER default NULL,
88: p_DML_MODE VARCHAR2 default NULL );
89:
90: PROCEDURE Update_Row(
91: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
92: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
93: p_CREATION_DATE DATE := fnd_api.g_miss_date,
94: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
95: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,

Line 92: p_CREATED_BY NUMBER := fnd_api.g_miss_num,

88: p_DML_MODE VARCHAR2 default NULL );
89:
90: PROCEDURE Update_Row(
91: p_REQUIREMENT_HEADER_ID NUMBER := fnd_api.g_miss_num,
92: p_CREATED_BY NUMBER := fnd_api.g_miss_num,
93: p_CREATION_DATE DATE := fnd_api.g_miss_date,
94: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,
95: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,
96: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,

Line 93: p_CREATION_DATE DATE := fnd_api.g_miss_date,

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

Line 94: p_LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num,

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

Line 95: p_LAST_UPDATE_DATE DATE := fnd_api.g_miss_date,

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

Line 96: p_LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num,

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

Line 97: p_OPEN_REQUIREMENT VARCHAR2 := fnd_api.g_miss_char,

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

Line 98: p_SHIP_TO_LOCATION_ID NUMBER := fnd_api.g_miss_num,

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

Line 99: p_TASK_ID NUMBER := fnd_api.g_miss_num,

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

Line 100: p_TASK_ASSIGNMENT_ID NUMBER := fnd_api.g_miss_num,

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

Line 101: p_SHIPPING_METHOD_CODE VARCHAR2 := fnd_api.g_miss_char,

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

Line 102: p_NEED_BY_DATE DATE := fnd_api.g_miss_date,

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

Line 103: p_DESTINATION_ORGANIZATION_ID NUMBER := fnd_api.g_miss_num,

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

Line 104: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,

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

Line 105: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,

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

Line 106: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,

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

Line 107: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,

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

Line 108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,

104: p_PARTS_DEFINED VARCHAR2 := fnd_api.g_miss_char,
105: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,

Line 109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,

105: p_ATTRIBUTE_CATEGORY VARCHAR2 := fnd_api.g_miss_char,
106: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,

Line 110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,

106: p_ATTRIBUTE1 VARCHAR2 := fnd_api.g_miss_char,
107: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,

Line 111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,

107: p_ATTRIBUTE2 VARCHAR2 := fnd_api.g_miss_char,
108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,

Line 112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,

108: p_ATTRIBUTE3 VARCHAR2 := fnd_api.g_miss_char,
109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,

Line 113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,

109: p_ATTRIBUTE4 VARCHAR2 := fnd_api.g_miss_char,
110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,

Line 114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,

110: p_ATTRIBUTE5 VARCHAR2 := fnd_api.g_miss_char,
111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
118: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,

Line 115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,

111: p_ATTRIBUTE6 VARCHAR2 := fnd_api.g_miss_char,
112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
118: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
119: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,

Line 116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,

112: p_ATTRIBUTE7 VARCHAR2 := fnd_api.g_miss_char,
113: p_ATTRIBUTE8 VARCHAR2 := fnd_api.g_miss_char,
114: p_ATTRIBUTE9 VARCHAR2 := fnd_api.g_miss_char,
115: p_ATTRIBUTE10 VARCHAR2 := fnd_api.g_miss_char,
116: p_ATTRIBUTE11 VARCHAR2 := fnd_api.g_miss_char,
117: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,
118: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
119: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
120: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,

Line 117: p_ATTRIBUTE12 VARCHAR2 := fnd_api.g_miss_char,

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

Line 118: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,

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

Line 119: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,

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

Line 120: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,

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

Line 121: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,

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

Line 122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,

118: p_ATTRIBUTE13 VARCHAR2 := fnd_api.g_miss_char,
119: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
120: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
121: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,

Line 123: p_resource_id NUMBER := fnd_api.g_miss_num,

119: p_ATTRIBUTE14 VARCHAR2 := fnd_api.g_miss_char,
120: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
121: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,
127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,

Line 124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,

120: p_ATTRIBUTE15 VARCHAR2 := fnd_api.g_miss_char,
121: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,
127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,
128: p_DML_MODE VARCHAR2 default NULL);

Line 125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,

121: p_ORDER_TYPE_ID NUMBER := fnd_api.g_miss_num,
122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,
127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,
128: p_DML_MODE VARCHAR2 default NULL);
129:

Line 126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,

122: p_ADDRESS_TYPE VARCHAR2 := fnd_api.g_miss_char,
123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,
127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,
128: p_DML_MODE VARCHAR2 default NULL);
129:
130: PROCEDURE Lock_Row(

Line 127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,

123: p_resource_id NUMBER := fnd_api.g_miss_num,
124: p_resource_type VARCHAR2 := fnd_api.g_miss_char,
125: p_TIMEZONE_ID NUMBER := fnd_api.g_miss_num,
126: P_DESTINATION_SUBINVENTORY VARCHAR2 := fnd_api.g_miss_char,
127: p_SHIP_TO_CONTACT_ID NUMBER := fnd_api.g_miss_num ,
128: p_DML_MODE VARCHAR2 default NULL);
129:
130: PROCEDURE Lock_Row(
131: p_REQUIREMENT_HEADER_ID NUMBER,