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 ,
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 ,
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.
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 );
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 ,
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 ,
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.
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 );
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 ,
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 ,
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.
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 );
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 ,
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 ,
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.
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 );
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 ,
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 ,
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.
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 );
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 ,
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 ,
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.
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 );