53: l_msg_data VARCHAR2(2000);
54:
55: BEGIN
56: --DBMS_OUTPUT.PUT_LINE('Update in progress');
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Seasonalities;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.compatible_api_call
61: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
55: BEGIN
56: --DBMS_OUTPUT.PUT_LINE('Update in progress');
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Seasonalities;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.compatible_api_call
61: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: -- End of API body.
118: << end_Update_Seasonalities >>
119: NULL;
120:
121: -- Standard check of p_commit.
122: IF FND_API.To_Boolean( p_commit ) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard call to get message count and if count is 1, get message info.
121: -- Standard check of p_commit.
122: IF FND_API.To_Boolean( p_commit ) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get
127: (
128: p_count => x_msg_count ,
129: p_data => x_msg_data ,
227: SELECT PCT_SEASONALITY FROM CN_SEASONALITIES
228: WHERE seas_schedule_id = p_seas_sch_id;
229: BEGIN
230: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
231: -- Standard Start of API savepoint
232: SAVEPOINT Validate_Seasonalities;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.compatible_api_call
235: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
229: BEGIN
230: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
231: -- Standard Start of API savepoint
232: SAVEPOINT Validate_Seasonalities;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.compatible_api_call
235: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
236: THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: -- End of API body.
282: << end_Validate_Seasonalities >>
283: NULL;
284:
285: -- Standard check of p_commit.
286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
285: -- Standard check of p_commit.
286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,