75: l_plan_text_id NUMBER;
76: l_temp_count NUMBER;
77:
78: BEGIN
79: -- Standard Start of API savepoint
80: SAVEPOINT Create_Plan_Text;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call
83: (l_api_version ,
77:
78: BEGIN
79: -- Standard Start of API savepoint
80: SAVEPOINT Create_Plan_Text;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call
83: (l_api_version ,
84: p_api_version ,
85: l_api_name ,
156: P_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
157: );
158:
159: -- End of API body.
160: -- Standard check of p_commit.
161: IF FND_API.To_Boolean( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164: -- Standard call to get message count and if count is 1, get message info.
160: -- Standard check of p_commit.
161: IF FND_API.To_Boolean( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164: -- Standard call to get message count and if count is 1, get message info.
165: FND_MSG_PUB.Count_And_Get
166: (p_count => x_msg_count ,
167: p_data => x_msg_data ,
168: p_encoded => FND_API.G_FALSE );
265: l_dummy NUMBER ;
266:
267:
268: BEGIN
269: -- Standard Start of API savepoint
270: SAVEPOINT Update_Plan_Text;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (l_api_version ,
267:
268: BEGIN
269: -- Standard Start of API savepoint
270: SAVEPOINT Update_Plan_Text;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (l_api_version ,
274: p_api_version ,
275: l_api_name ,
380: P_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
381: );
382:
383: -- End of API body.
384: -- Standard check of p_commit.
385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388: -- Standard call to get message count and if count is 1, get message info.
384: -- Standard check of p_commit.
385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388: -- Standard call to get message count and if count is 1, get message info.
389: FND_MSG_PUB.Count_And_Get
390: (p_count => x_msg_count ,
391: p_data => x_msg_data ,
392: p_encoded => FND_API.G_FALSE );
459: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Plan_Text';
460: l_api_version CONSTANT NUMBER := 1.0;
461:
462: BEGIN
463: -- Standard Start of API savepoint
464: SAVEPOINT Delete_Plan_Text;
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.Compatible_API_Call
467: (l_api_version ,
461:
462: BEGIN
463: -- Standard Start of API savepoint
464: SAVEPOINT Delete_Plan_Text;
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.Compatible_API_Call
467: (l_api_version ,
468: p_api_version ,
469: l_api_name ,
481:
482: CN_PLAN_TEXTS_PKG.Delete_Row(p_plan_text.plan_text_id);
483:
484: -- End of API body.
485: -- Standard check of p_commit.
486: IF FND_API.To_Boolean( p_commit ) THEN
487: COMMIT WORK;
488: END IF;
489: -- Standard call to get message count and if count is 1, get message info.
485: -- Standard check of p_commit.
486: IF FND_API.To_Boolean( p_commit ) THEN
487: COMMIT WORK;
488: END IF;
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get
491: (p_count => x_msg_count ,
492: p_data => x_msg_data ,
493: p_encoded => FND_API.G_FALSE );
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;
602:
603: BEGIN
604: -- Standard Start of API savepoint
605: SAVEPOINT Get_Plan_Texts;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call
608: (l_api_version ,
602:
603: BEGIN
604: -- Standard Start of API savepoint
605: SAVEPOINT Get_Plan_Texts;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call
608: (l_api_version ,
609: p_api_version ,
610: l_api_name ,
704:
705: CLOSE l_spt_cr;
706:
707: -- End of API body.
708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: (p_count => x_msg_count ,
715: p_data => x_msg_data ,
716: p_encoded => FND_API.G_FALSE );
801:
802: l_quota_cate l_qcs_cr%ROWTYPE;
803:
804: BEGIN
805: -- Standard Start of API savepoint
806: SAVEPOINT Get_Fixed_Quota_Cates;
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call
809: (l_api_version ,
803:
804: BEGIN
805: -- Standard Start of API savepoint
806: SAVEPOINT Get_Fixed_Quota_Cates;
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call
809: (l_api_version ,
810: p_api_version ,
811: l_api_name ,
840:
841: CLOSE l_qcs_cr;
842:
843: -- End of API body.
844: -- Standard check of p_commit.
845: IF FND_API.To_Boolean( p_commit ) THEN
846: COMMIT WORK;
847: END IF;
848: -- Standard call to get message count and if count is 1, get message info.
844: -- Standard check of p_commit.
845: IF FND_API.To_Boolean( p_commit ) THEN
846: COMMIT WORK;
847: END IF;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count ,
851: p_data => x_msg_data ,
852: p_encoded => FND_API.G_FALSE );
937:
938: l_quota_cate l_qcs_cr%ROWTYPE;
939:
940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT Get_Var_Quota_Cates;
943: -- Standard call to check for call compatibility.
944: IF NOT FND_API.Compatible_API_Call
945: (l_api_version ,
939:
940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT Get_Var_Quota_Cates;
943: -- Standard call to check for call compatibility.
944: IF NOT FND_API.Compatible_API_Call
945: (l_api_version ,
946: p_api_version ,
947: l_api_name ,
985:
986: CLOSE l_qcs_cr;
987:
988: -- End of API body.
989: -- Standard check of p_commit.
990: IF FND_API.To_Boolean( p_commit ) THEN
991: COMMIT WORK;
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
989: -- Standard check of p_commit.
990: IF FND_API.To_Boolean( p_commit ) THEN
991: COMMIT WORK;
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: (p_count => x_msg_count ,
996: p_data => x_msg_data ,
997: p_encoded => FND_API.G_FALSE );
1086: l_quota_cate l_qcs_cr%ROWTYPE;
1087: l_quota_type VARCHAR2(2000) ;
1088:
1089: BEGIN
1090: -- Standard Start of API savepoint
1091: SAVEPOINT Get_Quota_Cates;
1092: -- Standard call to check for call compatibility.
1093: IF NOT FND_API.Compatible_API_Call
1094: (l_api_version ,
1088:
1089: BEGIN
1090: -- Standard Start of API savepoint
1091: SAVEPOINT Get_Quota_Cates;
1092: -- Standard call to check for call compatibility.
1093: IF NOT FND_API.Compatible_API_Call
1094: (l_api_version ,
1095: p_api_version ,
1096: l_api_name ,
1136:
1137: CLOSE l_qcs_cr;
1138:
1139: -- End of API body.
1140: -- Standard check of p_commit.
1141: IF FND_API.To_Boolean( p_commit ) THEN
1142: COMMIT WORK;
1143: END IF;
1144: -- Standard call to get message count and if count is 1, get message info.
1140: -- Standard check of p_commit.
1141: IF FND_API.To_Boolean( p_commit ) THEN
1142: COMMIT WORK;
1143: END IF;
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: (p_count => x_msg_count ,
1147: p_data => x_msg_data ,
1148: p_encoded => FND_API.G_FALSE );
1217: l_api_name CONSTANT VARCHAR2(30) := 'Get_Role_Name';
1218: l_api_version CONSTANT NUMBER := 1.0;
1219:
1220: BEGIN
1221: -- Standard Start of API savepoint
1222: SAVEPOINT Get_Role_Name;
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call
1225: (l_api_version ,
1219:
1220: BEGIN
1221: -- Standard Start of API savepoint
1222: SAVEPOINT Get_Role_Name;
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call
1225: (l_api_version ,
1226: p_api_version ,
1227: l_api_name ,
1247: WHERE role_model_id = P_ROLE_MODEL_ID;
1248: END IF;
1249:
1250: -- End of API body.
1251: -- Standard check of p_commit.
1252: IF FND_API.To_Boolean( p_commit ) THEN
1253: COMMIT WORK;
1254: END IF;
1255: -- Standard call to get message count and if count is 1, get message info.
1251: -- Standard check of p_commit.
1252: IF FND_API.To_Boolean( p_commit ) THEN
1253: COMMIT WORK;
1254: END IF;
1255: -- Standard call to get message count and if count is 1, get message info.
1256: FND_MSG_PUB.Count_And_Get
1257: (p_count => x_msg_count ,
1258: p_data => x_msg_data ,
1259: p_encoded => FND_API.G_FALSE );