DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on STANDARD

Line 335: -- Standard Start of API savepoint

331: l_note_msg VARCHAR2(240);
332: l_note_id NUMBER;
333:
334: BEGIN
335: -- Standard Start of API savepoint
336: SAVEPOINT Create_Schedule;
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call
339: (l_api_version ,

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

333:
334: BEGIN
335: -- Standard Start of API savepoint
336: SAVEPOINT Create_Schedule;
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call
339: (l_api_version ,
340: p_api_version ,
341: l_api_name ,

Line 428: -- Standard check of p_commit.

424: */
425:
426: -- End of API body.
427:
428: -- Standard check of p_commit.
429: IF FND_API.To_Boolean( p_commit ) THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.

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

428: -- Standard check of p_commit.
429: IF FND_API.To_Boolean( p_commit ) THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: (p_count => x_msg_count ,
435: p_data => x_msg_data ,
436: p_encoded => FND_API.G_FALSE );

Line 552: -- Standard Start of API savepoint

548: SELECT rate_sch_dim_id
549: FROM cn_rate_sch_dims
550: WHERE rate_schedule_id = p_rate_schedule_id;
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT Update_Schedule;
554: -- Standard call to check for call compatibility.
555: IF NOT FND_API.Compatible_API_Call
556: (l_api_version ,

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

550: WHERE rate_schedule_id = p_rate_schedule_id;
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT Update_Schedule;
554: -- Standard call to check for call compatibility.
555: IF NOT FND_API.Compatible_API_Call
556: (l_api_version ,
557: p_api_version ,
558: l_api_name ,

Line 735: -- Standard check of p_commit.

731: -- *********************************************************************
732:
733: -- End of API body.
734:
735: -- Standard check of p_commit.
736: IF FND_API.To_Boolean( p_commit ) THEN
737: COMMIT WORK;
738: END IF;
739: -- Standard call to get message count and if count is 1, get message info.

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

735: -- Standard check of p_commit.
736: IF FND_API.To_Boolean( p_commit ) THEN
737: COMMIT WORK;
738: END IF;
739: -- Standard call to get message count and if count is 1, get message info.
740: FND_MSG_PUB.count_and_get
741: (p_count => x_msg_count ,
742: p_data => x_msg_data ,
743: p_encoded => FND_API.G_FALSE );

Line 826: -- Standard Start of API savepoint

822: l_note_msg VARCHAR2(240);
823: l_note_id NUMBER;
824:
825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT Delete_Schedule;
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call
830: (l_api_version ,

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

824:
825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT Delete_Schedule;
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call
830: (l_api_version ,
831: p_api_version ,
832: l_api_name ,

Line 897: -- Standard check of p_commit.

893: -- *********************************************************************
894:
895: -- End of API body.
896:
897: -- Standard check of p_commit.
898: IF FND_API.To_Boolean( p_commit ) THEN
899: COMMIT WORK;
900: END IF;
901: -- Standard call to get message count and if count is 1, get message info.

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

897: -- Standard check of p_commit.
898: IF FND_API.To_Boolean( p_commit ) THEN
899: COMMIT WORK;
900: END IF;
901: -- Standard call to get message count and if count is 1, get message info.
902: FND_MSG_PUB.count_and_get
903: (p_count => x_msg_count ,
904: p_data => x_msg_data ,
905: p_encoded => FND_API.G_FALSE );

Line 996: -- Standard Start of API savepoint

992: l_note_id NUMBER;
993: l_dimension_id NUMBER;
994:
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT Delete_Dimension_Assign;
998: -- Standard call to check for call compatibility.
999: IF NOT FND_API.Compatible_API_Call
1000: (l_api_version ,

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

994:
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT Delete_Dimension_Assign;
998: -- Standard call to check for call compatibility.
999: IF NOT FND_API.Compatible_API_Call
1000: (l_api_version ,
1001: p_api_version ,
1002: l_api_name ,

Line 1103: -- Standard check of p_commit.

1099: -- and rate_dim_sequence >= l_rate_dim_sequence;
1100:
1101: -- End of API body.
1102:
1103: -- Standard check of p_commit.
1104: IF FND_API.To_Boolean( p_commit ) THEN
1105: COMMIT WORK;
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.

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

1103: -- Standard check of p_commit.
1104: IF FND_API.To_Boolean( p_commit ) THEN
1105: COMMIT WORK;
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count ,
1110: p_data => x_msg_data ,
1111: p_encoded => FND_API.G_FALSE );

Line 1220: -- Standard Start of API savepoint

1216: SELECT number_tier
1217: FROM cn_rate_dimensions
1218: WHERE rate_dimension_id = p_rate_dimension_id;
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT Update_Dimension_Assign;
1222: -- Standard call to check for call compatibility.
1223: IF NOT FND_API.Compatible_API_Call
1224: (l_api_version ,

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

1218: WHERE rate_dimension_id = p_rate_dimension_id;
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT Update_Dimension_Assign;
1222: -- Standard call to check for call compatibility.
1223: IF NOT FND_API.Compatible_API_Call
1224: (l_api_version ,
1225: p_api_version ,
1226: l_api_name ,

Line 1351: -- Standard check of p_commit.

1347: -- ************ End - R12 Notes History ********************************
1348: -- *********************************************************************
1349: -- End of API body.
1350:
1351: -- Standard check of p_commit.
1352: IF FND_API.To_Boolean( p_commit ) THEN
1353: COMMIT WORK;
1354: END IF;
1355: -- Standard call to get message count and if count is 1, get message info.

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

1351: -- Standard check of p_commit.
1352: IF FND_API.To_Boolean( p_commit ) THEN
1353: COMMIT WORK;
1354: END IF;
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: (p_count => x_msg_count ,
1358: p_data => x_msg_data ,
1359: p_encoded => FND_API.G_FALSE );

Line 1458: -- Standard Start of API savepoint

1454: CURSOR tier_exist IS
1455: SELECT count(1) from cn_rate_tiers
1456: WHERE rate_schedule_id = p_rate_schedule_id;
1457: BEGIN
1458: -- Standard Start of API savepoint
1459: SAVEPOINT Create_Dimension_Assign;
1460: -- Standard call to check for call compatibility.
1461: IF NOT FND_API.Compatible_API_Call
1462: (l_api_version ,

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

1456: WHERE rate_schedule_id = p_rate_schedule_id;
1457: BEGIN
1458: -- Standard Start of API savepoint
1459: SAVEPOINT Create_Dimension_Assign;
1460: -- Standard call to check for call compatibility.
1461: IF NOT FND_API.Compatible_API_Call
1462: (l_api_version ,
1463: p_api_version ,
1464: l_api_name ,

Line 1585: -- Standard check of p_commit.

1581: END IF;
1582:
1583: -- End of API body.
1584:
1585: -- Standard check of p_commit.
1586: IF FND_API.To_Boolean( p_commit ) THEN
1587: COMMIT WORK;
1588: END IF;
1589: -- Standard call to get message count and if count is 1, get message info.

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

1585: -- Standard check of p_commit.
1586: IF FND_API.To_Boolean( p_commit ) THEN
1587: COMMIT WORK;
1588: END IF;
1589: -- Standard call to get message count and if count is 1, get message info.
1590: FND_MSG_PUB.Count_And_Get
1591: (p_count => x_msg_count ,
1592: p_data => x_msg_data ,
1593: p_encoded => FND_API.G_FALSE );