APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on FND_API

Line 26: ROW_ID ROWID := FND_API.G_MISS_CHAR,

22: -- End of Comments
23:
24: TYPE RQH_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

23:
24: TYPE RQH_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

24: TYPE RQH_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 29: CREATION_DATE DATE := FND_API.G_MISS_DATE,

25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

27: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

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

29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,

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

30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

Line 36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 37: TASK_ID NUMBER := FND_API.G_MISS_NUM,

33: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,

34: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

35: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

36: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,

37: TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

Line 42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

38: TASK_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,

39: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

40: RESOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

41: RESOURCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

42: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

43: RESOURCE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

44: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

45: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

46: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

47: DESTINATION_ORGANIZATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

48: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

49: ORDER_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

50: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

51: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

52: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

53: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

54: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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,

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

55: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

56: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE9 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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

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

60: ATTRIBUTE9 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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68: DESTINATION_SUBINVENTORY VARCHAR2(30) := 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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );

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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );
70:

Line 67: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );
70:
71: G_MISS_RQH_REC RQH_Rec_Type;

Line 68: DESTINATION_SUBINVENTORY VARCHAR2(30) := 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: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
68: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: );
70:
71: G_MISS_RQH_REC RQH_Rec_Type;
72: TYPE RQH_Tbl_Type IS TABLE OF RQH_Rec_Type

Line 91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

87: -- Pre-Req :
88: -- Parameters:
89: -- IN
90: -- p_api_version_number IN NUMBER Required
91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93: -- P_RQH_Rec IN RQH_Rec_Type Required
94: --
95: -- OUT:

Line 92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

88: -- Parameters:
89: -- IN
90: -- p_api_version_number IN NUMBER Required
91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93: -- P_RQH_Rec IN RQH_Rec_Type Required
94: --
95: -- OUT:
96: -- x_return_status OUT NOCOPY VARCHAR2

Line 107: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

103: -- End of Comments
104: --
105: PROCEDURE Create_requirement_headers(
106: P_Api_Version_Number IN NUMBER,
107: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
108: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
109: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
110: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
111: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,

Line 108: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

104: --
105: PROCEDURE Create_requirement_headers(
106: P_Api_Version_Number IN NUMBER,
107: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
108: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
109: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
110: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
111: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,
112: X_Return_Status OUT NOCOPY VARCHAR2,

Line 126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

122: -- Pre-Req :
123: -- Parameters:
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- P_RQH_Rec IN RQH_Rec_Type Required
129: --
130: -- OUT:

Line 127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

123: -- Parameters:
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- P_RQH_Rec IN RQH_Rec_Type Required
129: --
130: -- OUT:
131: -- x_return_status OUT NOCOPY VARCHAR2

Line 143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

139: --
140: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141: PROCEDURE Update_requirement_headers(
142: P_Api_Version_Number IN NUMBER,
143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,

Line 144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

140: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141: PROCEDURE Update_requirement_headers(
142: P_Api_Version_Number IN NUMBER,
143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,
148: X_Msg_Data OUT NOCOPY VARCHAR2

Line 160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

156: -- Pre-Req :
157: -- Parameters:
158: -- IN
159: -- p_api_version_number IN NUMBER Required
160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162: -- P_RQH_Rec IN RQH_Rec_Type Required
163: --
164: -- OUT:

Line 161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

157: -- Parameters:
158: -- IN
159: -- p_api_version_number IN NUMBER Required
160: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
161: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
162: -- P_RQH_Rec IN RQH_Rec_Type Required
163: --
164: -- OUT:
165: -- x_return_status OUT NOCOPY VARCHAR2

Line 178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

174: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
175: -- The Master delete procedure may not be needed depends on different business requirements.
176: PROCEDURE Delete_requirement_headers(
177: P_Api_Version_Number IN NUMBER,
178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180: P_RQH_Rec IN RQH_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,

Line 179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

175: -- The Master delete procedure may not be needed depends on different business requirements.
176: PROCEDURE Delete_requirement_headers(
177: P_Api_Version_Number IN NUMBER,
178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180: P_RQH_Rec IN RQH_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,
183: X_Msg_Data OUT NOCOPY VARCHAR2