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.JTF_PERZ_PROFILE_PVT dependencies on STANDARD

Line 40: -- 11/04/99 SMATTEGU Changing the names to suite the standards and adding who columns

36: -- * where clause must use the profile id and attribute name instead of rowid
37: -- 09/30/99 SMATTEGU Updated the create_profile() to handle profile_id also.
38: -- Updated insert_row_jtf_perz_profile(), insert_row_profile_attrib().
39: --
40: -- 11/04/99 SMATTEGU Changing the names to suite the standards and adding who columns
41: --
42: -- End of Comments
43:
44: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_PROFILE_PVT';

Line 571: -- * Standard Begins **

567: l_is_duplicate VARCHAR2(1);
568: l_object_version_number NUMBER := NULL;
569:
570: BEGIN
571: -- ******* Standard Begins ********
572:
573: -- Standard Start of API savepoint
574: SAVEPOINT CREATE_PERZ_PROFILE_PVT;
575:

Line 573: -- Standard Start of API savepoint

569:
570: BEGIN
571: -- ******* Standard Begins ********
572:
573: -- Standard Start of API savepoint
574: SAVEPOINT CREATE_PERZ_PROFILE_PVT;
575:
576: --dbms_output.put_line('creating save point ');
577: /*

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

574: SAVEPOINT CREATE_PERZ_PROFILE_PVT;
575:
576: --dbms_output.put_line('creating save point ');
577: /*
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;

Line 662: -- Standard Ends ***

658: );
659:
660: END LOOP;
661:
662: -- ******** Standard Ends ***********
663: --
664: -- End of main API body.
665:
666: -- Standard check of p_commit.

Line 666: -- Standard check of p_commit.

662: -- ******** Standard Ends ***********
663: --
664: -- End of main API body.
665:
666: -- Standard check of p_commit.
667: IF (FND_API.To_Boolean(p_commit)) THEN
668: COMMIT WORK;
669: END IF;
670:

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

667: IF (FND_API.To_Boolean(p_commit)) THEN
668: COMMIT WORK;
669: END IF;
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
673: p_data => x_msg_data );
674:
675: EXCEPTION

Line 820: -- * Standard Begins **

816: curso_4proftype proftype4_curs%ROWTYPE;
817: curso_1profattr profid1attr_curs%ROWTYPE;
818:
819: BEGIN
820: -- ******* Standard Begins ********
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF FND_API.to_Boolean( p_init_msg_list )
824: THEN

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

956: --dbms_output.put_line('personalize');
957: null;
958: END IF;
959:
960: -- Standard call to get message count and if count is 1, get message info.
961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
962: p_data => x_msg_data );
963:
964: EXCEPTION

Line 1048: -- * Standard Begins **

1044: l_object_version_number NUMBER := NULL;
1045: l_attrib_obj_version_no NUMBER := NULL;
1046:
1047: BEGIN
1048: -- ******* Standard Begins ********
1049: -- Standard Start of API savepoint
1050: SAVEPOINT UPDATE_PERZ_PROFILE_PVT;
1051: /*
1052: -- Standard call to check for call compatibility.

Line 1049: -- Standard Start of API savepoint

1045: l_attrib_obj_version_no NUMBER := NULL;
1046:
1047: BEGIN
1048: -- ******* Standard Begins ********
1049: -- Standard Start of API savepoint
1050: SAVEPOINT UPDATE_PERZ_PROFILE_PVT;
1051: /*
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

1048: -- ******* Standard Begins ********
1049: -- Standard Start of API savepoint
1050: SAVEPOINT UPDATE_PERZ_PROFILE_PVT;
1051: /*
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1054: THEN
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;

Line 1186: -- Standard Ends ***

1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183: end if;
1184:
1185: END IF; -- for success check
1186: -- ******** Standard Ends ***********
1187: --
1188: -- End of main API body.
1189:
1190: -- Standard check of p_commit.

Line 1190: -- Standard check of p_commit.

1186: -- ******** Standard Ends ***********
1187: --
1188: -- End of main API body.
1189:
1190: -- Standard check of p_commit.
1191: IF (FND_API.To_Boolean(p_commit)) THEN
1192: COMMIT WORK;
1193: END IF;
1194:

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

1191: IF (FND_API.To_Boolean(p_commit)) THEN
1192: COMMIT WORK;
1193: END IF;
1194:
1195: -- Standard call to get message count and if count is 1, get message info.
1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1197: p_data => x_msg_data );
1198:
1199: EXCEPTION