[Home] [Help]
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(32767);
54:
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_SCORE_PUB;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT CREATE_SCORE_PUB;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)
103: --
104: -- End of API body
105: --
106:
107: -- Standard check for p_commit
108: IF FND_API.to_Boolean( p_commit )
109: THEN
110: COMMIT WORK;
111: END IF;
112:
113: -- Debug Message
114: iex_score_pvt.WriteLog('iexpscrb:CreateScore:End');
115:
116: -- Standard call to get message count and if count is 1, get message info.
117: FND_MSG_PUB.Count_And_Get
118: ( p_count => x_msg_count,
119: p_data => x_msg_data
120: );
168:
169: BEGIN
170:
171:
172: -- Standard Start of API savepoint
173: SAVEPOINT UPDATE_SCORE_PUB;
174:
175: -- Standard call to check for call compatibility.
176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171:
172: -- Standard Start of API savepoint
173: SAVEPOINT UPDATE_SCORE_PUB;
174:
175: -- Standard call to check for call compatibility.
176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
177: p_api_version,
178: l_api_name,
179: G_PKG_NAME)
224: --
225: -- End of API body.
226: --
227:
228: -- Standard check for p_commit
229: IF FND_API.to_Boolean( p_commit )
230: THEN
231: COMMIT WORK;
232: END IF;
233:
234: -- Debug Message
235: iex_score_pvt.WriteLog('iexpscrb:UpdateScore:End');
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count,
240: p_data => x_msg_data );
241:
286: l_msg_count NUMBER;
287: l_msg_data VARCHAR2(32767);
288:
289: BEGIN
290: -- Standard Start of API savepoint
291: SAVEPOINT DELETE_SCORE_PUB;
292:
293: -- Standard call to check for call compatibility.
294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
289: BEGIN
290: -- Standard Start of API savepoint
291: SAVEPOINT DELETE_SCORE_PUB;
292:
293: -- Standard call to check for call compatibility.
294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
295: p_api_version,
296: l_api_name,
297: G_PKG_NAME)
343: --
344: -- End of API body
345: --
346:
347: -- Standard check for p_commit
348: IF FND_API.to_Boolean( p_commit )
349: THEN
350: COMMIT WORK;
351: END IF;
401: l_msg_count NUMBER;
402: l_msg_data VARCHAR2(32767);
403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT CREATE_Score_Comp_PUB;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT CREATE_Score_Comp_PUB;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
410: p_api_version,
411: l_api_name,
412: G_PKG_NAME)
454: --
455: -- End of API body
456: --
457:
458: -- Standard check for p_commit
459: IF FND_API.to_Boolean( p_commit )
460: THEN
461: COMMIT WORK;
462: END IF;
464: -- Debug Message
465: iex_score_pvt.WriteLog('iexpscrb:CreateScoreComp: End');
466:
467:
468: -- Standard call to get message count and if count is 1, get message info.
469: FND_MSG_PUB.Count_And_Get
470: ( p_count => x_msg_count,
471: p_data => x_msg_data
472: );
519:
520: BEGIN
521:
522:
523: -- Standard Start of API savepoint
524: SAVEPOINT UPDATE_Score_Comp_PUB;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
522:
523: -- Standard Start of API savepoint
524: SAVEPOINT UPDATE_Score_Comp_PUB;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
528: p_api_version,
529: l_api_name,
530: G_PKG_NAME)
576: --
577: -- End of API body.
578: --
579:
580: -- Standard check for p_commit
581: IF FND_API.to_Boolean( p_commit )
582: THEN
583: COMMIT WORK;
584: END IF;
586: -- Debug Message
587: iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: End');
588:
589:
590: -- Standard call to get message count and if count is 1, get message info.
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data );
594:
639: l_msg_data VARCHAR2(32767);
640: l_score_comp_id NUMBER;
641:
642: BEGIN
643: -- Standard Start of API savepoint
644: SAVEPOINT DELETE_SCORE_COMP_PUB;
645:
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
642: BEGIN
643: -- Standard Start of API savepoint
644: SAVEPOINT DELETE_SCORE_COMP_PUB;
645:
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
648: p_api_version,
649: l_api_name,
650: G_PKG_NAME)
696: --
697: -- End of API body
698: --
699:
700: -- Standard check for p_commit
701: IF FND_API.to_Boolean( p_commit )
702: THEN
703: COMMIT WORK;
704: END IF;
758: l_msg_count NUMBER;
759: l_msg_data VARCHAR2(32767);
760:
761: BEGIN
762: -- Standard Start of API savepoint
763: SAVEPOINT CREATE_Score_Comp_Type_PUB;
764:
765: -- Standard call to check for call compatibility.
766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
761: BEGIN
762: -- Standard Start of API savepoint
763: SAVEPOINT CREATE_Score_Comp_Type_PUB;
764:
765: -- Standard call to check for call compatibility.
766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
767: p_api_version,
768: l_api_name,
769: G_PKG_NAME)
812: --
813: -- End of API body
814: --
815:
816: -- Standard check for p_commit
817: IF FND_API.to_Boolean( p_commit )
818: THEN
819: COMMIT WORK;
820: END IF;
822: -- Debug Message
823: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompType: End');
824:
825:
826: -- Standard call to get message count and if count is 1, get message info.
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data
830: );
878:
879: BEGIN
880:
881:
882: -- Standard Start of API savepoint
883: SAVEPOINT UPDATE_Score_Comp_TYPE_PUB;
884:
885: -- Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
881:
882: -- Standard Start of API savepoint
883: SAVEPOINT UPDATE_Score_Comp_TYPE_PUB;
884:
885: -- Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
887: p_api_version,
888: l_api_name,
889: G_PKG_NAME)
935: --
936: -- End of API body.
937: --
938:
939: -- Standard check for p_commit
940: IF FND_API.to_Boolean( p_commit )
941: THEN
942: COMMIT WORK;
943: END IF;
945: -- Debug Message
946: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');
947:
948:
949: -- Standard call to get message count and if count is 1, get message info.
950: FND_MSG_PUB.Count_And_Get
951: ( p_count => x_msg_count,
952: p_data => x_msg_data );
953:
999: l_msg_count NUMBER;
1000: l_msg_data VARCHAR2(32767);
1001:
1002: BEGIN
1003: -- Standard Start of API savepoint
1004: SAVEPOINT DELETE_SCORE_COMP_TYPE_PUB;
1005:
1006: -- Standard call to check for call compatibility.
1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1002: BEGIN
1003: -- Standard Start of API savepoint
1004: SAVEPOINT DELETE_SCORE_COMP_TYPE_PUB;
1005:
1006: -- Standard call to check for call compatibility.
1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1008: p_api_version,
1009: l_api_name,
1010: G_PKG_NAME)
1057: --
1058: -- End of API body
1059: --
1060:
1061: -- Standard check for p_commit
1062: IF FND_API.to_Boolean( p_commit )
1063: THEN
1064: COMMIT WORK;
1065: END IF;
1120: x_score_comp_det_id NUMBER;
1121:
1122:
1123: BEGIN
1124: -- Standard Start of API savepoint
1125: SAVEPOINT CREATE_Score_Comp_DET_PUB;
1126:
1127:
1128: -- Standard call to check for call compatibility.
1124: -- Standard Start of API savepoint
1125: SAVEPOINT CREATE_Score_Comp_DET_PUB;
1126:
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version,
1131: l_api_name,
1132: G_PKG_NAME)
1187: --
1188: -- End of API body
1189: --
1190:
1191: -- Standard check for p_commit
1192: IF FND_API.to_Boolean( p_commit )
1193: THEN
1194: COMMIT WORK;
1195: END IF;
1197: -- Debug Message
1198: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompDet: End');
1199:
1200:
1201: -- Standard call to get message count and if count is 1, get message info.
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1251: l_SCORE_COMP_Det_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_Type;
1252:
1253: BEGIN
1254:
1255: -- Standard Start of API savepoint
1256: SAVEPOINT UPDATE_Score_Comp_PUB_DET;
1257:
1258: -- Standard call to check for call compatibility.
1259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1254:
1255: -- Standard Start of API savepoint
1256: SAVEPOINT UPDATE_Score_Comp_PUB_DET;
1257:
1258: -- Standard call to check for call compatibility.
1259: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1260: p_api_version,
1261: l_api_name,
1262: G_PKG_NAME)
1306: --
1307: -- End of API body.
1308: --
1309:
1310: -- Standard check for p_commit
1311: IF FND_API.to_Boolean( p_commit )
1312: THEN
1313: COMMIT WORK;
1314: END IF;
1316: -- Debug Message
1317: iex_score_pvt.WriteLog('iexpscrb:UpdScrCompDet: End');
1318:
1319:
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:
1369: l_msg_data VARCHAR2(32767);
1370: l_score_Comp_det_id NUMBER;
1371:
1372: BEGIN
1373: -- Standard Start of API savepoint
1374: SAVEPOINT DELETE_SCORE_COMP_DET_PUB;
1375:
1376: -- Standard call to check for call compatibility.
1377: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1372: BEGIN
1373: -- Standard Start of API savepoint
1374: SAVEPOINT DELETE_SCORE_COMP_DET_PUB;
1375:
1376: -- Standard call to check for call compatibility.
1377: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1378: p_api_version,
1379: l_api_name,
1380: G_PKG_NAME)
1425: --
1426: -- End of API body
1427: --
1428:
1429: -- Standard check for p_commit
1430: IF FND_API.to_Boolean( p_commit )
1431: THEN
1432: COMMIT WORK;
1433: END IF;
1489: l_score_Comp_det_id NUMBER;
1490: l_msg VARCHAR2(50);
1491:
1492: BEGIN
1493: -- Standard Start of API savepoint
1494: SAVEPOINT COPY_SCORINGENGINE_PUB;
1495:
1496: -- Standard call to check for call compatibility.
1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1492: BEGIN
1493: -- Standard Start of API savepoint
1494: SAVEPOINT COPY_SCORINGENGINE_PUB;
1495:
1496: -- Standard call to check for call compatibility.
1497: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1498: p_api_version,
1499: l_api_name,
1500: G_PKG_NAME)
1548: --
1549: -- End of API body
1550: --
1551:
1552: -- Standard check for p_commit
1553: IF FND_API.to_Boolean( p_commit )
1554: THEN
1555: COMMIT WORK;
1556: END IF;
1606: l_msg_count NUMBER;
1607: l_msg_data VARCHAR2(32767);
1608:
1609: BEGIN
1610: -- Standard Start of API savepoint
1611: SAVEPOINT GET_SCORE_PUB;
1612:
1613: -- Standard call to check for call compatibility.
1614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1609: BEGIN
1610: -- Standard Start of API savepoint
1611: SAVEPOINT GET_SCORE_PUB;
1612:
1613: -- Standard call to check for call compatibility.
1614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1615: p_api_version,
1616: l_api_name,
1617: G_PKG_NAME)
1651: --
1652: -- End of API body
1653: --
1654:
1655: -- Standard check for p_commit
1656: IF FND_API.to_Boolean( p_commit )
1657: THEN
1658: COMMIT WORK;
1659: END IF;