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

Line 60: -- * Standard Begins **

56: l_api_name CONSTANT VARCHAR2(30) := 'Save Query';
57:
58: BEGIN
59:
60: -- ******* Standard Begins ********
61:
62: -- Standard Start of API savepoint
63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;
64:

Line 62: -- Standard Start of API savepoint

58: BEGIN
59:
60: -- ******* Standard Begins ********
61:
62: -- Standard Start of API savepoint
63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;
64:
65: -- Standard call to check for call compatibility.
66: -- IF NOT FND_API.Compatible_API_Call (

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

61:
62: -- Standard Start of API savepoint
63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;
64:
65: -- Standard call to check for call compatibility.
66: -- IF NOT FND_API.Compatible_API_Call (
67: -- l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
68: -- THEN
69: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 104: -- Standard Ends ***

100: x_return_status,
101: x_msg_count,
102: x_msg_data
103: );
104: -- ******** Standard Ends ***********
105: --
106: -- End of API body.
107: --
108: -- 7. Commit the whole thing

Line 110: -- Standard check of p_commit.

106: -- End of API body.
107: --
108: -- 7. Commit the whole thing
109:
110: -- Standard check of p_commit.
111: IF Fnd_Api.To_Boolean ( p_commit )
112: THEN
113: COMMIT WORK;
114: END IF;

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

113: COMMIT WORK;
114: END IF;
115:
116: -- Debug Message
117: -- Standard call to get message count and if count is 1, get message info.
118: Fnd_Msg_Pub.Count_And_Get
119: (
120: p_count => x_msg_count,
121: p_data => x_msg_data

Line 208: -- * Standard Begins **

204: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
205:
206: BEGIN
207:
208: -- ******* Standard Begins ********
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;
212:

Line 210: -- Standard Start of API savepoint

206: BEGIN
207:
208: -- ******* Standard Begins ********
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;
212:
213: -- Standard call to check for call compatibility.
214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

209:
210: -- Standard Start of API savepoint
211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;
212:
213: -- Standard call to check for call compatibility.
214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
215: -- THEN
216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: -- END IF;

Line 249: -- Standard Ends ***

245: x_msg_count,
246: x_msg_data
247: );
248:
249: -- ******** Standard Ends ***********
250: --
251: -- End of API body.
252: --
253: -- 7. Commit the whole thing

Line 255: -- Standard check of p_commit.

251: -- End of API body.
252: --
253: -- 7. Commit the whole thing
254:
255: -- Standard check of p_commit.
256: IF Fnd_Api.To_Boolean ( p_commit )
257: THEN
258: COMMIT WORK;
259: END IF;

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

258: COMMIT WORK;
259: END IF;
260:
261: -- Debug Message
262: -- Standard call to get message count and if count is 1, get message info.
263: Fnd_Msg_Pub.Count_And_Get
264: (
265: p_count => x_msg_count,
266: p_data => x_msg_data

Line 353: -- * Standard Begins **

349: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
350:
351: BEGIN
352:
353: -- ******* Standard Begins ********
354:
355: -- Standard call to check for call compatibility.
356: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
357: -- THEN

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

351: BEGIN
352:
353: -- ******* Standard Begins ********
354:
355: -- Standard call to check for call compatibility.
356: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
357: -- THEN
358: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: -- END IF;

Line 397: -- Standard Ends ***

393: x_msg_count,
394: x_msg_data
395: );
396:
397: -- ******** Standard Ends ***********
398: --
399: -- End of API body.
400:
401: -- Debug Message

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

398: --
399: -- End of API body.
400:
401: -- Debug Message
402: -- Standard call to get message count and if count is 1, get message info.
403: Fnd_Msg_Pub.Count_And_Get
404: (
405: p_count => x_msg_count,
406: p_data => x_msg_data

Line 485: -- * Standard Begins **

481: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
482:
483: BEGIN
484:
485: -- ******* Standard Begins ********
486:
487: -- Standard call to check for call compatibility.
488: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
489: -- THEN

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

483: BEGIN
484:
485: -- ******* Standard Begins ********
486:
487: -- Standard call to check for call compatibility.
488: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
489: -- THEN
490: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: -- END IF;

Line 522: -- Standard Ends ***

518: x_msg_data
519: );
520:
521:
522: -- ******** Standard Ends ***********
523: --
524: -- End of API body.
525:
526: -- Debug Message

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

523: --
524: -- End of API body.
525:
526: -- Debug Message
527: -- Standard call to get message count and if count is 1, get message info.
528: Fnd_Msg_Pub.Count_And_Get
529: (
530: p_count => x_msg_count,
531: p_data => x_msg_data

Line 615: -- * Standard Begins **

611: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
612:
613: BEGIN
614:
615: -- ******* Standard Begins ********
616:
617: -- Standard Start of API savepoint
618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;
619:

Line 617: -- Standard Start of API savepoint

613: BEGIN
614:
615: -- ******* Standard Begins ********
616:
617: -- Standard Start of API savepoint
618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;
619:
620: -- Standard call to check for call compatibility.
621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

616:
617: -- Standard Start of API savepoint
618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;
619:
620: -- Standard call to check for call compatibility.
621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
622: -- THEN
623: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: -- END IF;

Line 656: -- Standard Ends ***

652: x_msg_data
653: );
654:
655:
656: -- ******** Standard Ends ***********
657: --
658: -- End of API body.
659: --
660: -- 7. Commit the whole thing

Line 662: -- Standard check of p_commit.

658: -- End of API body.
659: --
660: -- 7. Commit the whole thing
661:
662: -- Standard check of p_commit.
663: IF Fnd_Api.To_Boolean ( p_commit )
664: THEN
665: COMMIT WORK;
666: END IF;

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

665: COMMIT WORK;
666: END IF;
667:
668: -- Debug Message
669: -- Standard call to get message count and if count is 1, get message info.
670: Fnd_Msg_Pub.Count_And_Get
671: (
672: p_count => x_msg_count,
673: p_data => x_msg_data

Line 749: -- * Standard Begins **

745: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
746:
747: BEGIN
748:
749: -- ******* Standard Begins ********
750:
751: -- Standard Start of API savepoint
752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;
753:

Line 751: -- Standard Start of API savepoint

747: BEGIN
748:
749: -- ******* Standard Begins ********
750:
751: -- Standard Start of API savepoint
752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;
753:
754: -- Standard call to check for call compatibility.
755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

750:
751: -- Standard Start of API savepoint
752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;
753:
754: -- Standard call to check for call compatibility.
755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
756: -- THEN
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: -- END IF;

Line 782: -- Standard Ends ***

778: x_msg_data
779: );
780:
781:
782: -- ******** Standard Ends ***********
783: --
784: -- End of API body.
785: --
786: -- 7. Commit the whole thing

Line 788: -- Standard check of p_commit.

784: -- End of API body.
785: --
786: -- 7. Commit the whole thing
787:
788: -- Standard check of p_commit.
789: IF Fnd_Api.To_Boolean ( p_commit )
790: THEN
791: COMMIT WORK;
792: END IF;

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

791: COMMIT WORK;
792: END IF;
793:
794: -- Debug Message
795: -- Standard call to get message count and if count is 1, get message info.
796: Fnd_Msg_Pub.Count_And_Get
797: (
798: p_count => x_msg_count,
799: p_data => x_msg_data