APPS.CSD_FLWSTS_TRAN_MILES_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_Flwsts_Tran_Mile;
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_Flwsts_Tran_Mile;
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 122: -- Standard check of p_commit.

118: end if;
119:
120: -- Api body ends here
121:
122: -- Standard check of p_commit.
123: IF FND_API.To_Boolean( p_commit ) THEN
124: COMMIT WORK;
125: END IF;
126:

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

123: IF FND_API.To_Boolean( p_commit ) THEN
124: COMMIT WORK;
125: END IF;
126:
127: -- Standard call to get message count and IF count is get message info.
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count,
130: p_data => x_msg_data );
131:

Line 266: -- Standard Start of API savepoint

262: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
263: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
264:
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Update_Flwsts_Tran_Mile;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Update_Flwsts_Tran_Mile;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (lc_api_version,
271: p_api_version,
272: lc_api_name ,
273: G_PKG_NAME )

Line 344: -- Standard check of p_commit.

340: end if;
341:
342: -- Api body ends here
343:
344: -- Standard check of p_commit.
345: IF FND_API.To_Boolean( p_commit ) THEN
346: COMMIT WORK;
347: END IF;
348:

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

345: IF FND_API.To_Boolean( p_commit ) THEN
346: COMMIT WORK;
347: END IF;
348:
349: -- Standard call to get message count and IF count is get message info.
350: FND_MSG_PUB.Count_And_Get
351: (p_count => x_msg_count,
352: p_data => x_msg_data );
353:

Line 476: -- Standard Start of API savepoint

472: l_msg_data VARCHAR2(100);
473: l_msg_index NUMBER;
474:
475: BEGIN
476: -- Standard Start of API savepoint
477: SAVEPOINT Delete_Flwsts_Tran_Mile;
478:
479: -- Standard call to check for call compatibility.
480: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

475: BEGIN
476: -- Standard Start of API savepoint
477: SAVEPOINT Delete_Flwsts_Tran_Mile;
478:
479: -- Standard call to check for call compatibility.
480: IF NOT FND_API.Compatible_API_Call (lc_api_version,
481: p_api_version,
482: lc_api_name ,
483: G_PKG_NAME )

Line 536: -- Standard check of p_commit.

532: end if;
533:
534: -- Api body ends here
535:
536: -- Standard check of p_commit.
537: IF FND_API.To_Boolean( p_commit ) THEN
538: COMMIT WORK;
539: END IF;
540:

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

537: IF FND_API.To_Boolean( p_commit ) THEN
538: COMMIT WORK;
539: END IF;
540:
541: -- Standard call to get message count and IF count is get message info.
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data );
545:

Line 656: -- Standard Start of API savepoint

652: l_msg_index NUMBER;
653: l_rowid ROWID;
654:
655: BEGIN
656: -- Standard Start of API savepoint
657: SAVEPOINT Lock_Flwsts_Tran_Mile;
658:
659: -- Standard call to check for call compatibility.
660: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

655: BEGIN
656: -- Standard Start of API savepoint
657: SAVEPOINT Lock_Flwsts_Tran_Mile;
658:
659: -- Standard call to check for call compatibility.
660: IF NOT FND_API.Compatible_API_Call (lc_api_version,
661: p_api_version,
662: lc_api_name ,
663: G_PKG_NAME )

Line 724: -- Standard check of p_commit.

720: end if;
721:
722: -- Api body ends here
723:
724: -- Standard check of p_commit.
725: IF FND_API.To_Boolean( p_commit ) THEN
726: COMMIT WORK;
727: END IF;
728:

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

725: IF FND_API.To_Boolean( p_commit ) THEN
726: COMMIT WORK;
727: END IF;
728:
729: -- Standard call to get message count and IF count is get message info.
730: FND_MSG_PUB.Count_And_Get
731: (p_count => x_msg_count,
732: p_data => x_msg_data );
733: