DBA Data[Home] [Help]

APPS.CSD_FLOW_STATUSES_PVT dependencies on STANDARD

Line 47: -- Standard Start of API savepoint

43: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
44: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
45:
46: BEGIN
47: -- Standard Start of API savepoint
48: SAVEPOINT Create_Flow_Status;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

46: BEGIN
47: -- Standard Start of API savepoint
48: SAVEPOINT Create_Flow_Status;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (lc_api_version,
52: p_api_version,
53: lc_api_name ,
54: G_PKG_NAME )

Line 140: -- Standard check of p_commit.

136: end if;
137:
138: -- Api body ends here
139:
140: -- Standard check of p_commit.
141: IF FND_API.To_Boolean( p_commit ) THEN
142: COMMIT WORK;
143: END IF;
144:

Line 145: -- Standard call to get message count and IF count is get message info.

141: IF FND_API.To_Boolean( p_commit ) THEN
142: COMMIT WORK;
143: END IF;
144:
145: -- Standard call to get message count and IF count is get message info.
146: FND_MSG_PUB.Count_And_Get
147: (p_count => x_msg_count,
148: p_data => x_msg_data );
149:

Line 285: -- Standard Start of API savepoint

281: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
282: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
283:
284: BEGIN
285: -- Standard Start of API savepoint
286: SAVEPOINT Update_Flow_Status;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

284: BEGIN
285: -- Standard Start of API savepoint
286: SAVEPOINT Update_Flow_Status;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (lc_api_version,
290: p_api_version,
291: lc_api_name ,
292: G_PKG_NAME )

Line 384: -- Standard check of p_commit.

380: end if;
381:
382: -- Api body ends here
383:
384: -- Standard check of p_commit.
385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388:

Line 389: -- Standard call to get message count and IF count is get message info.

385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388:
389: -- Standard call to get message count and IF count is get message info.
390: FND_MSG_PUB.Count_And_Get
391: (p_count => x_msg_count,
392: p_data => x_msg_data );
393:

Line 516: -- Standard Start of API savepoint

512: l_msg_data VARCHAR2(100);
513: l_msg_index NUMBER;
514:
515: BEGIN
516: -- Standard Start of API savepoint
517: SAVEPOINT Delete_Flow_Status;
518:
519: -- Standard call to check for call compatibility.
520: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

515: BEGIN
516: -- Standard Start of API savepoint
517: SAVEPOINT Delete_Flow_Status;
518:
519: -- Standard call to check for call compatibility.
520: IF NOT FND_API.Compatible_API_Call (lc_api_version,
521: p_api_version,
522: lc_api_name ,
523: G_PKG_NAME )

Line 576: -- Standard check of p_commit.

572: end if;
573:
574: -- Api body ends here
575:
576: -- Standard check of p_commit.
577: IF FND_API.To_Boolean( p_commit ) THEN
578: COMMIT WORK;
579: END IF;
580:

Line 581: -- Standard call to get message count and IF count is get message info.

577: IF FND_API.To_Boolean( p_commit ) THEN
578: COMMIT WORK;
579: END IF;
580:
581: -- Standard call to get message count and IF count is get message info.
582: FND_MSG_PUB.Count_And_Get
583: (p_count => x_msg_count,
584: p_data => x_msg_data );
585:

Line 696: -- Standard Start of API savepoint

692: l_msg_index NUMBER;
693: l_rowid ROWID;
694:
695: BEGIN
696: -- Standard Start of API savepoint
697: SAVEPOINT Lock_Flow_Status;
698:
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

695: BEGIN
696: -- Standard Start of API savepoint
697: SAVEPOINT Lock_Flow_Status;
698:
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call (lc_api_version,
701: p_api_version,
702: lc_api_name ,
703: G_PKG_NAME )

Line 765: -- Standard check of p_commit.

761: end if;
762:
763: -- Api body ends here
764:
765: -- Standard check of p_commit.
766: IF FND_API.To_Boolean( p_commit ) THEN
767: COMMIT WORK;
768: END IF;
769:

Line 770: -- Standard call to get message count and IF count is get message info.

766: IF FND_API.To_Boolean( p_commit ) THEN
767: COMMIT WORK;
768: END IF;
769:
770: -- Standard call to get message count and IF count is get message info.
771: FND_MSG_PUB.Count_And_Get
772: (p_count => x_msg_count,
773: p_data => x_msg_data );
774: