DBA Data[Home] [Help]

APPS.CN_SEAS_SCHEDULES_PVT dependencies on STANDARD

Line 65: -- Standard Start of API savepoint

61:
62:
63: BEGIN
64: --DBMS_OUTPUT.PUT_LINE('Starting Create_Seas_Schedule ...');
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Seas_Schedule;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

Line 67: -- Standard call to check for call compatibility.

63: BEGIN
64: --DBMS_OUTPUT.PUT_LINE('Starting Create_Seas_Schedule ...');
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Seas_Schedule;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 182: -- Standard check of p_commit.

178: -- End of API body.
179: << end_Create_Seas_Schedule >>
180: NULL;
181:
182: -- Standard check of p_commit.
183: IF FND_API.To_Boolean( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: -- Standard call to get message count and if count is 1, get message info.

Line 186: -- Standard call to get message count and if count is 1, get message info.

182: -- Standard check of p_commit.
183: IF FND_API.To_Boolean( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: -- Standard call to get message count and if count is 1, get message info.
187: FND_MSG_PUB.Count_And_Get
188: (
189: p_count => x_msg_count ,
190: p_data => x_msg_data ,

Line 288: -- Standard Start of API savepoint

284: l_srp_count NUMBER;
285:
286: BEGIN
287: --DBMS_OUTPUT.PUT_LINE('Update in progress');
288: -- Standard Start of API savepoint
289: SAVEPOINT Update_Seas_Schedule;
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.compatible_api_call
292: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

Line 290: -- Standard call to check for call compatibility.

286: BEGIN
287: --DBMS_OUTPUT.PUT_LINE('Update in progress');
288: -- Standard Start of API savepoint
289: SAVEPOINT Update_Seas_Schedule;
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.compatible_api_call
292: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
293: THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 392: -- Standard check of p_commit.

388: -- End of API body.
389: << end_Update_Seas_Schedule >>
390: NULL;
391:
392: -- Standard check of p_commit.
393: IF FND_API.To_Boolean( p_commit ) THEN
394: COMMIT WORK;
395: END IF;
396: -- Standard call to get message count and if count is 1, get message info.

Line 396: -- Standard call to get message count and if count is 1, get message info.

392: -- Standard check of p_commit.
393: IF FND_API.To_Boolean( p_commit ) THEN
394: COMMIT WORK;
395: END IF;
396: -- Standard call to get message count and if count is 1, get message info.
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_count => x_msg_count ,
400: p_data => x_msg_data ,

Line 497: -- Standard Start of API savepoint

493: l_seas_sch_id NUMBER;
494: l_role_quota_cate_count NUMBER;
495: BEGIN
496: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
497: -- Standard Start of API savepoint
498: SAVEPOINT Delete_Seas_Schedule;
499: -- Standard call to check for call compatibility.
500: IF NOT FND_API.compatible_api_call
501: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

Line 499: -- Standard call to check for call compatibility.

495: BEGIN
496: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
497: -- Standard Start of API savepoint
498: SAVEPOINT Delete_Seas_Schedule;
499: -- Standard call to check for call compatibility.
500: IF NOT FND_API.compatible_api_call
501: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 540: -- Standard check of p_commit.

536: -- End of API body.
537: << end_Delete_Seas_Schedule >>
538: NULL;
539:
540: -- Standard check of p_commit.
541: IF FND_API.To_Boolean( p_commit ) THEN
542: COMMIT WORK;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info.

Line 544: -- Standard call to get message count and if count is 1, get message info.

540: -- Standard check of p_commit.
541: IF FND_API.To_Boolean( p_commit ) THEN
542: COMMIT WORK;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (
547: p_count => x_msg_count ,
548: p_data => x_msg_data ,

Line 643: -- Standard Start of API savepoint

639: l_seas_schedule_id NUMBER;
640: l_pct_seasonality NUMBER;
641:
642: BEGIN
643: -- Standard Start of API savepoint
644: SAVEPOINT Sum_Seas_Schedule;
645: -- Standard call to check for call compatibility.
646: IF NOT FND_API.compatible_api_call
647: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

Line 645: -- Standard call to check for call compatibility.

641:
642: BEGIN
643: -- Standard Start of API savepoint
644: SAVEPOINT Sum_Seas_Schedule;
645: -- Standard call to check for call compatibility.
646: IF NOT FND_API.compatible_api_call
647: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
648: THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 670: -- Standard check of p_commit.

666: -- End of API body.
667: << end_Delete_Seas_Schedule >>
668: NULL;
669:
670: -- Standard check of p_commit.
671: IF FND_API.To_Boolean( p_commit ) THEN
672: COMMIT WORK;
673: END IF;
674: -- Standard call to get message count and if count is 1, get message info.

Line 674: -- Standard call to get message count and if count is 1, get message info.

670: -- Standard check of p_commit.
671: IF FND_API.To_Boolean( p_commit ) THEN
672: COMMIT WORK;
673: END IF;
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count ,
678: p_data => x_msg_data ,