67: --
68: -- NOTES
69: -- 1. object_version_number will be set to 1.
70: -- 5. If a flag column is not passed in, default it to 'Y'.
71: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
72: ---------------------------------------------------------------------
73: PROCEDURE Create_task_group (
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
72: ---------------------------------------------------------------------
73: PROCEDURE Create_task_group (
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
77: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78:
79: ,x_return_status OUT NOCOPY VARCHAR2
72: ---------------------------------------------------------------------
73: PROCEDURE Create_task_group (
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
77: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78:
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_data OUT NOCOPY VARCHAR2
73: PROCEDURE Create_task_group (
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
77: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
78:
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_data OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
94: -- p_task_group : the record with new items.
95: --
96: -- NOTES
97: -- 1. Raise exception if the object_version_number doesn't match.
98: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
99: -- that column won't be updated.
100: ----------------------------------------------------------------------
101: PROCEDURE Update_task_group (
102: p_api_version IN NUMBER
99: -- that column won't be updated.
100: ----------------------------------------------------------------------
101: PROCEDURE Update_task_group (
102: p_api_version IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
100: ----------------------------------------------------------------------
101: PROCEDURE Update_task_group (
102: p_api_version IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_data OUT NOCOPY VARCHAR2
101: PROCEDURE Update_task_group (
102: p_api_version IN NUMBER
103: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106:
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
126: -- 1. Raise exception if the object_version_number doesn't match.
127: ----------------------------------------------------------------------
128: PROCEDURE Delete_task_group (
129: p_api_version IN NUMBER
130: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
131: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
132: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
133:
134: ,x_return_status OUT NOCOPY VARCHAR2
127: ----------------------------------------------------------------------
128: PROCEDURE Delete_task_group (
129: p_api_version IN NUMBER
130: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
131: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
132: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
133:
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_data OUT NOCOPY VARCHAR2
128: PROCEDURE Delete_task_group (
129: p_api_version IN NUMBER
130: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
131: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
132: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
133:
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_data OUT NOCOPY VARCHAR2
136: ,x_msg_count OUT NOCOPY NUMBER
153: -- 1. Raise exception if the object_version_number doesn't match.
154: ----------------------------------------------------------------------
155: PROCEDURE Get_task_group (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159:
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
154: ----------------------------------------------------------------------
155: PROCEDURE Get_task_group (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
159:
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
185: --
186: ----------------------------------------------------------------------
187: PROCEDURE Validate_task_group (
188: p_api_version IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
191: ,x_return_status OUT NOCOPY VARCHAR2
192: ,x_msg_count OUT NOCOPY NUMBER
193: ,x_msg_data OUT NOCOPY VARCHAR2
186: ----------------------------------------------------------------------
187: PROCEDURE Validate_task_group (
188: p_api_version IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
191: ,x_return_status OUT NOCOPY VARCHAR2
192: ,x_msg_count OUT NOCOPY NUMBER
193: ,x_msg_data OUT NOCOPY VARCHAR2
194: ,p_task_group IN task_group_rec_type
217: -- Check the record level business rules.
218: --
219: -- PARAMETERS
220: -- p_task_group_rec : the record to be validated; may contain attributes
221: -- as FND_API.g_miss_char/num/date
222: -- p_complete_rec: the complete record after all "g_miss" items have
223: -- been replaced by current database values
224: ---------------------------------------------------------------------
225: PROCEDURE Check_task_group_Record(
231: -- PROCEDURE
232: -- Init_task_group_Rec
233: --
234: -- PURPOSE
235: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
236: ---------------------------------------------------------------------
237: PROCEDURE Init_task_group_Rec (
238: x_task_group_rec OUT NOCOPY task_group_rec_type
239: );
242: -- Complete_task_group_Rec
243: --
244: -- PURPOSE
245: -- For Update_task_group, some attributes may be passed in as
246: -- FND_API.g_miss_char/num/date if the user doesn't want to
247: -- update those attributes. This procedure will replace the
248: -- "g_miss" attributes with current database values.
249: --
250: -- PARAMETERS
248: -- "g_miss" attributes with current database values.
249: --
250: -- PARAMETERS
251: -- p_task_group_rec : the record which may contain attributes as
252: -- FND_API.g_miss_char/num/date
253: -- x_complete_rec: the complete record after all "g_miss" items
254: -- have been replaced by current database values
255: ---------------------------------------------------------------------
256: PROCEDURE Complete_task_group_Rec (