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: );

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: );
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: );
95:
96: G_MISS_REQUIREMENT_HEADER_REC REQUIREMENT_HEADER_Rec_Type;

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: );
95:
96: G_MISS_REQUIREMENT_HEADER_REC REQUIREMENT_HEADER_Rec_Type;
97: TYPE REQUIREMENT_HEADER_Tbl_Type IS TABLE OF REQUIREMENT_HEADER_Rec_Type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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