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_QUERY_PVT dependencies on STANDARD

Line 462: -- * Standard Begins **

458: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;
459: l_object_version_number NUMBER :=NULL;
460:
461: BEGIN
462: -- ******* Standard Begins ********
463:
464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_PERZ_QUERY_PVT;
466:

Line 464: -- Standard Start of API savepoint

460:
461: BEGIN
462: -- ******* Standard Begins ********
463:
464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_PERZ_QUERY_PVT;
466:
467: -- -- Standard call to check for call compatibility.
468: -- IF NOT FND_API.Compatible_API_Call (

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

463:
464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_PERZ_QUERY_PVT;
466:
467: -- -- Standard call to check for call compatibility.
468: -- IF NOT FND_API.Compatible_API_Call (
469: -- l_api_version_number,
470: -- p_api_version_number,
471: -- l_api_name,

Line 597: -- Standard Ends ***

593:
594: -- copying ID to output.
595: x_query_id := l_query_id;
596:
597: -- ******** Standard Ends ***********
598: --
599: -- End of main API body.
600:
601: -- Standard check of p_commit.

Line 601: -- Standard check of p_commit.

597: -- ******** Standard Ends ***********
598: --
599: -- End of main API body.
600:
601: -- Standard check of p_commit.
602: IF (Fnd_Api.To_Boolean(p_commit)) THEN
603: COMMIT WORK;
604: END IF;
605:

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

602: IF (Fnd_Api.To_Boolean(p_commit)) THEN
603: COMMIT WORK;
604: END IF;
605:
606: -- Standard call to get message count and if count is 1, get message info.
607: Fnd_Msg_Pub.Count_And_Get(
608: p_count => x_msg_count,
609: p_data => x_msg_data );
610:

Line 707: -- * Standard Begins **

703: l_profile_name VARCHAR2(30) := NULL;
704: l_object_version_number NUMBER :=NULL;
705:
706: BEGIN
707: -- ******* Standard Begins ********
708: -- Standard Start of API savepoint
709: SAVEPOINT UPDATE_PERZ_QUERY_PVT;
710:
711: -- -- Standard call to check for call compatibility.

Line 708: -- Standard Start of API savepoint

704: l_object_version_number NUMBER :=NULL;
705:
706: BEGIN
707: -- ******* Standard Begins ********
708: -- Standard Start of API savepoint
709: SAVEPOINT UPDATE_PERZ_QUERY_PVT;
710:
711: -- -- Standard call to check for call compatibility.
712: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

707: -- ******* Standard Begins ********
708: -- Standard Start of API savepoint
709: SAVEPOINT UPDATE_PERZ_QUERY_PVT;
710:
711: -- -- Standard call to check for call compatibility.
712: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
713: -- THEN
714: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: -- END IF;

Line 886: -- Standard Start of API savepoint

882:
883: l_query_id NUMBER;
884: l_api_name CONSTANT VARCHAR2(30) := 'Delete Profile';
885: BEGIN
886: -- Standard Start of API savepoint
887: SAVEPOINT DELETE_PERZ_QUERY_PVT;
888:
889: -- -- Standard call to check for call compatibility.
890: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

885: BEGIN
886: -- Standard Start of API savepoint
887: SAVEPOINT DELETE_PERZ_QUERY_PVT;
888:
889: -- -- Standard call to check for call compatibility.
890: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
891: -- THEN
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: -- END IF;

Line 1068: -- * Standard Begins **

1064: FROM JTF_PERZ_QUERY
1065: WHERE query_name = p_query_name AND Profile_ID = p_profile_id AND Application_ID = p_application_id;
1066:
1067: BEGIN
1068: -- ******* Standard Begins ********
1069:
1070: -- -- Standard call to check for call compatibility.
1071: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1072: -- THEN

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

1066:
1067: BEGIN
1068: -- ******* Standard Begins ********
1069:
1070: -- -- Standard call to check for call compatibility.
1071: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1072: -- THEN
1073: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: -- END IF;

Line 1324: -- * Get_Perz_Query Local Variables - Standards **

1320: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1321: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1322: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1323: )IS
1324: -- ******* Get_Perz_Query Local Variables - Standards ********
1325: l_api_name VARCHAR2(60) := 'Get_Perz_Query';
1326: l_api_version_number NUMBER := p_api_version_number;
1327:
1328: -- ******* Get_Perz_Query Local Variables ********

Line 1367: -- * Standard Begins **

1363: FROM JTF_PERZ_QUERY_ORDER_BY
1364: WHERE QUERY_ID = p_query_id
1365: ORDER BY PARAMETER_SEQUENCE;
1366: BEGIN
1367: -- ******* Standard Begins ********
1368:
1369: -- -- Standard call to check for call compatibility.
1370: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1371: -- THEN

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

1365: ORDER BY PARAMETER_SEQUENCE;
1366: BEGIN
1367: -- ******* Standard Begins ********
1368:
1369: -- -- Standard call to check for call compatibility.
1370: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1371: -- THEN
1372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: -- END IF;

Line 1596: -- * Save_Perz_Query Local Variables - Standards **

1592: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1593: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1594: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1595: )IS
1596: -- ******* Save_Perz_Query Local Variables - Standards ********
1597: l_api_name VARCHAR2(60) := 'Save_Perz_Query';
1598: l_api_version_number NUMBER := p_api_version_number;
1599:
1600: -- ******* Save_Perz_Query Local Variables ********

Line 1618: -- * Standard Begins **

1614:
1615:
1616:
1617: BEGIN
1618: -- ******* Standard Begins ********
1619:
1620: -- Standard Start of API savepoint
1621: SAVEPOINT SAVE_PERZ_QUERY_PVT;
1622:

Line 1620: -- Standard Start of API savepoint

1616:
1617: BEGIN
1618: -- ******* Standard Begins ********
1619:
1620: -- Standard Start of API savepoint
1621: SAVEPOINT SAVE_PERZ_QUERY_PVT;
1622:
1623: -- -- Standard call to check for call compatibility.
1624: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

1619:
1620: -- Standard Start of API savepoint
1621: SAVEPOINT SAVE_PERZ_QUERY_PVT;
1622:
1623: -- -- Standard call to check for call compatibility.
1624: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1625: -- THEN
1626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: -- END IF;

Line 1761: -- Standard Ends ***

1757: x_msg_data
1758: );
1759: --dbms_output.put_line('query id is'||x_query_id);
1760: END IF;
1761: -- ******** Standard Ends ***********
1762: --
1763: -- End of main API body.
1764:
1765: -- Standard check of p_commit.

Line 1765: -- Standard check of p_commit.

1761: -- ******** Standard Ends ***********
1762: --
1763: -- End of main API body.
1764:
1765: -- Standard check of p_commit.
1766: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1767: COMMIT WORK;
1768: END IF;
1769:

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

1766: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1767: COMMIT WORK;
1768: END IF;
1769:
1770: -- Standard call to get message count and if count is 1, get message info.
1771: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1772: p_data => x_msg_data );
1773:
1774: EXCEPTION