eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLAN_TEXTS_PVT dependencies on STANDARD

Line 79: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 160: -- Standard check of p_commit.

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.

Line 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 );

Line 269: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 384: -- Standard check of p_commit.

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.

Line 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 );

Line 463: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 485: -- Standard check of p_commit.

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.

Line 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 );

Line 604: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 708: -- Standard check of p_commit.

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.

Line 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 );

Line 805: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 844: -- Standard check of p_commit.

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.

Line 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 );

Line 941: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 989: -- Standard check of p_commit.

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.

Line 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 );

Line 1090: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 1140: -- Standard check of p_commit.

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.

Line 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 );

Line 1221: -- Standard Start of API savepoint

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 ,

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

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 ,

Line 1251: -- Standard check of p_commit.

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.

Line 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 );