eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_REQUIREMENT_HEADERS_PVT dependencies on FND_API

Line 58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

54: -- End of Comments
55:
56: TYPE REQUIREMENT_HEADER_Rec_Type IS RECORD
57: (
58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

55:
56: TYPE REQUIREMENT_HEADER_Rec_Type IS RECORD
57: (
58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 60: CREATION_DATE DATE := FND_API.G_MISS_DATE,

56: TYPE REQUIREMENT_HEADER_Rec_Type IS RECORD
57: (
58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

57: (
58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

58: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

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

60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

Line 66: TASK_ID NUMBER := FND_API.G_MISS_NUM,

62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

64: OPEN_REQUIREMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,

65: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

66: TASK_ID NUMBER := FND_API.G_MISS_NUM,
67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

67: TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

68: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

69: NEED_BY_DATE DATE := FND_API.G_MISS_DATE,
70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

70: DESTINATION_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

71: PARTS_DEFINED VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

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

81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

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

83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

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

85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM

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

87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
95: );

Line 92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

88: ORDER_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
95: );
96:

Line 93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

89: ADDRESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
95: );
96:
97: G_MISS_REQUIREMENT_HEADER_REC REQUIREMENT_HEADER_Rec_Type;

Line 94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM

90: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
91: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
93: DESTINATION_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
95: );
96:
97: G_MISS_REQUIREMENT_HEADER_REC REQUIREMENT_HEADER_Rec_Type;
98: TYPE REQUIREMENT_HEADER_Tbl_Type IS TABLE OF REQUIREMENT_HEADER_Rec_Type

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

107: -- Pre-Req :
108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_admin_group_id IN NUMBER Required

Line 113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_admin_group_id IN NUMBER Required
117: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required

Line 114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_admin_group_id IN NUMBER Required
117: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
118: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116: -- p_admin_group_id IN NUMBER Required
117: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
118: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
119: --

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

128: -- End of Comments
129: --
130: PROCEDURE Create_requirement_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type := G_MISS_REQUIREMENT_HEADER_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

129: --
130: PROCEDURE Create_requirement_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type := G_MISS_REQUIREMENT_HEADER_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
137: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,

Line 134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

130: PROCEDURE Create_requirement_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type := G_MISS_REQUIREMENT_HEADER_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
137: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,
138: X_Return_Status OUT NOCOPY VARCHAR2,

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

148: -- Pre-Req :
149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required

Line 154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required

Line 156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_admin_group_id IN NUMBER Required
158: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
160: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

171: --
172: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173: PROCEDURE Update_requirement_headers(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,

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

172: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173: PROCEDURE Update_requirement_headers(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,

Line 177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

173: PROCEDURE Update_requirement_headers(
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
179: X_Return_Status OUT NOCOPY VARCHAR2,
180: X_Msg_Count OUT NOCOPY NUMBER,
181: X_Msg_Data OUT NOCOPY VARCHAR2

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

189: -- Pre-Req :
190: -- Parameters:
191: -- IN
192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

190: -- Parameters:
191: -- IN
192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_group_id IN NUMBER Required

Line 195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

191: -- IN
192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_group_id IN NUMBER Required
199: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_group_id IN NUMBER Required
199: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
200: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required

Line 197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198: -- p_admin_group_id IN NUMBER Required
199: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
200: -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
201: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

213: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
214: -- The Master delete procedure may not be needed depends on different business requirements.
215: PROCEDURE Delete_requirement_headers(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,

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

214: -- The Master delete procedure may not be needed depends on different business requirements.
215: PROCEDURE Delete_requirement_headers(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,

Line 219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

215: PROCEDURE Delete_requirement_headers(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,
223: X_Msg_Data OUT NOCOPY VARCHAR2