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

Line 57: -- Save_Perz_Data local variable for standards **

53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
54: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55: )IS
56:
57: --******** Save_Perz_Data local variable for standards **********
58: l_api_name CONSTANT VARCHAR2(30) := 'Save PerzData';
59: l_api_version_number NUMBER := p_api_version_number;
60: BEGIN
61: -- ******* Standard Begins ********

Line 61: -- * Standard Begins **

57: --******** Save_Perz_Data local variable for standards **********
58: l_api_name CONSTANT VARCHAR2(30) := 'Save PerzData';
59: l_api_version_number NUMBER := p_api_version_number;
60: BEGIN
61: -- ******* Standard Begins ********
62:
63: -- Standard Start of API savepoint
64: SAVEPOINT SAVE_PERZ_DATA_PUB;
65:

Line 63: -- Standard Start of API savepoint

59: l_api_version_number NUMBER := p_api_version_number;
60: BEGIN
61: -- ******* Standard Begins ********
62:
63: -- Standard Start of API savepoint
64: SAVEPOINT SAVE_PERZ_DATA_PUB;
65:
66: -- -- Standard call to check for call compatibility.
67: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

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

Line 108: -- Standard Ends ***

104: x_msg_data
105: );
106:
107:
108: -- ******** Standard Ends ***********
109: --
110: -- End of main API body.
111:
112: -- Standard check of p_commit.

Line 112: -- Standard check of p_commit.

108: -- ******** Standard Ends ***********
109: --
110: -- End of main API body.
111:
112: -- Standard check of p_commit.
113: IF (FND_API.To_Boolean(p_commit)) THEN
114: COMMIT WORK;
115: END IF;
116:

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

113: IF (FND_API.To_Boolean(p_commit)) THEN
114: COMMIT WORK;
115: END IF;
116:
117: -- Standard call to get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
119: p_data => x_msg_data );
120:
121: EXCEPTION

Line 181: -- Save_Perz_Data local variable for standards **

177: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
178: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179: )IS
180:
181: --******** Save_Perz_Data local variable for standards **********
182: l_api_name CONSTANT VARCHAR2(30) := 'Save PerzData';
183: l_api_version_number NUMBER := p_api_version_number;
184: BEGIN
185: -- ******* Standard Begins ********

Line 185: -- * Standard Begins **

181: --******** Save_Perz_Data local variable for standards **********
182: l_api_name CONSTANT VARCHAR2(30) := 'Save PerzData';
183: l_api_version_number NUMBER := p_api_version_number;
184: BEGIN
185: -- ******* Standard Begins ********
186:
187: -- Standard Start of API savepoint
188: SAVEPOINT CREATE_PERZ_DATA_PUB;
189:

Line 187: -- Standard Start of API savepoint

183: l_api_version_number NUMBER := p_api_version_number;
184: BEGIN
185: -- ******* Standard Begins ********
186:
187: -- Standard Start of API savepoint
188: SAVEPOINT CREATE_PERZ_DATA_PUB;
189:
190: -- -- Standard call to check for call compatibility.
191: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

186:
187: -- Standard Start of API savepoint
188: SAVEPOINT CREATE_PERZ_DATA_PUB;
189:
190: -- -- Standard call to check for call compatibility.
191: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
192: -- THEN
193: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: -- END IF;

Line 230: -- Standard Ends ***

226: x_msg_data
227: );
228:
229:
230: -- ******** Standard Ends ***********
231: --
232: -- End of main API body.
233:
234: -- Standard check of p_commit.

Line 234: -- Standard check of p_commit.

230: -- ******** Standard Ends ***********
231: --
232: -- End of main API body.
233:
234: -- Standard check of p_commit.
235: IF (FND_API.To_Boolean(p_commit)) THEN
236: COMMIT WORK;
237: END IF;
238:

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

235: IF (FND_API.To_Boolean(p_commit)) THEN
236: COMMIT WORK;
237: END IF;
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
241: p_data => x_msg_data );
242:
243: EXCEPTION

Line 306: -- Get_Perz_Data_Summary local variable for standards **

302: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: )IS
304:
305:
306: --******** Get_Perz_Data_Summary local variable for standards **********
307: l_api_name CONSTANT VARCHAR2(30) := 'Get PerzData';
308: l_api_version_number NUMBER := p_api_version_number;
309:
310: -- ******* Get_Perz_Data_Summary Local Variables ********

Line 313: -- * Standard Begins **

309:
310: -- ******* Get_Perz_Data_Summary Local Variables ********
311:
312: BEGIN
313: -- ******* Standard Begins ********
314:
315: -- -- Standard call to check for call compatibility.
316: -- IF NOT FND_API.Compatible_API_Call
317: -- ( l_api_version_number,

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

311:
312: BEGIN
313: -- ******* Standard Begins ********
314:
315: -- -- Standard call to check for call compatibility.
316: -- IF NOT FND_API.Compatible_API_Call
317: -- ( l_api_version_number,
318: -- p_api_version_number, l_api_name, G_PKG_NAME)
319: -- THEN

Line 357: -- Standard Ends ***

353: x_msg_data
354: );
355:
356:
357: -- ******** Standard Ends ***********
358: -- Standard call to get message count and if count is 1, get message info.
359: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
360: p_data => x_msg_data );
361:

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

354: );
355:
356:
357: -- ******** Standard Ends ***********
358: -- Standard call to get message count and if count is 1, get message info.
359: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
360: p_data => x_msg_data );
361:
362: EXCEPTION

Line 412: -- Get_Perz_Data_Summary local variable for standards **

408: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
409: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
410: )IS
411:
412: --******** Get_Perz_Data_Summary local variable for standards **********
413: l_api_name CONSTANT VARCHAR2(30) := 'Get PerzData Summary';
414: l_api_version_number NUMBER := p_api_version_number;
415:
416: BEGIN

Line 417: -- * Standard Begins **

413: l_api_name CONSTANT VARCHAR2(30) := 'Get PerzData Summary';
414: l_api_version_number NUMBER := p_api_version_number;
415:
416: BEGIN
417: -- ******* Standard Begins ********
418:
419: -- -- Standard call to check for call compatibility.
420: -- IF NOT FND_API.Compatible_API_Call
421: -- ( l_api_version_number,

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

415:
416: BEGIN
417: -- ******* Standard Begins ********
418:
419: -- -- Standard call to check for call compatibility.
420: -- IF NOT FND_API.Compatible_API_Call
421: -- ( l_api_version_number,
422: -- p_api_version_number, l_api_name, G_PKG_NAME)
423: -- THEN

Line 455: -- Standard Ends ***

451: x_msg_count,
452: x_msg_data
453: );
454:
455: -- ******** Standard Ends ***********
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
458: p_data => x_msg_data );
459:

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

452: x_msg_data
453: );
454:
455: -- ******** Standard Ends ***********
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
458: p_data => x_msg_data );
459:
460: EXCEPTION

Line 514: -- Update_Perz_Data local variable for standards **

510: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511: )
512: IS
513:
514: --******** Update_Perz_Data local variable for standards **********
515: l_api_name CONSTANT VARCHAR2(30) := 'Update_Perz_Data';
516: l_api_version_number NUMBER := p_api_version_number;
517: BEGIN
518: -- ******* Standard Begins ********

Line 518: -- * Standard Begins **

514: --******** Update_Perz_Data local variable for standards **********
515: l_api_name CONSTANT VARCHAR2(30) := 'Update_Perz_Data';
516: l_api_version_number NUMBER := p_api_version_number;
517: BEGIN
518: -- ******* Standard Begins ********
519:
520: -- Standard Start of API savepoint
521: SAVEPOINT UPDATE_PERZ_DATA_PUB;
522:

Line 520: -- Standard Start of API savepoint

516: l_api_version_number NUMBER := p_api_version_number;
517: BEGIN
518: -- ******* Standard Begins ********
519:
520: -- Standard Start of API savepoint
521: SAVEPOINT UPDATE_PERZ_DATA_PUB;
522:
523: -- -- Standard call to check for call compatibility.
524: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

519:
520: -- Standard Start of API savepoint
521: SAVEPOINT UPDATE_PERZ_DATA_PUB;
522:
523: -- -- Standard call to check for call compatibility.
524: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
525: -- THEN
526: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: -- END IF;

Line 560: -- Standard Ends ***

556: x_msg_count,
557: x_msg_data
558: );
559:
560: -- ******** Standard Ends ***********
561: --
562: -- End of main API body.
563:
564: -- Standard check of p_commit.

Line 564: -- Standard check of p_commit.

560: -- ******** Standard Ends ***********
561: --
562: -- End of main API body.
563:
564: -- Standard check of p_commit.
565: IF (FND_API.To_Boolean(p_commit)) THEN
566: COMMIT WORK;
567: END IF;
568:

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

565: IF (FND_API.To_Boolean(p_commit)) THEN
566: COMMIT WORK;
567: END IF;
568:
569: -- Standard call to get message count and if count is 1, get message info.
570: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
571: p_data => x_msg_data );
572:
573: EXCEPTION

Line 627: -- Delete_Perz_Data local variable for standards **

623: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
624: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
625: )IS
626:
627: --******** Delete_Perz_Data local variable for standards **********
628: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Perz_Data';
629: l_api_version_number NUMBER := p_api_version_number;
630: BEGIN
631: -- ******* Standard Begins ********

Line 631: -- * Standard Begins **

627: --******** Delete_Perz_Data local variable for standards **********
628: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Perz_Data';
629: l_api_version_number NUMBER := p_api_version_number;
630: BEGIN
631: -- ******* Standard Begins ********
632:
633: -- Standard Start of API savepoint
634: SAVEPOINT DELETE_PERZ_DATA_PUB;
635:

Line 633: -- Standard Start of API savepoint

629: l_api_version_number NUMBER := p_api_version_number;
630: BEGIN
631: -- ******* Standard Begins ********
632:
633: -- Standard Start of API savepoint
634: SAVEPOINT DELETE_PERZ_DATA_PUB;
635:
636: -- -- Standard call to check for call compatibility.
637: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

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

632:
633: -- Standard Start of API savepoint
634: SAVEPOINT DELETE_PERZ_DATA_PUB;
635:
636: -- -- Standard call to check for call compatibility.
637: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
638: -- THEN
639: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: -- END IF;

Line 668: -- Standard Ends ***

664: x_msg_data
665: );
666:
667:
668: -- ******** Standard Ends ***********
669: --
670: -- End of main API body.
671:
672: -- Standard check of p_commit.

Line 672: -- Standard check of p_commit.

668: -- ******** Standard Ends ***********
669: --
670: -- End of main API body.
671:
672: -- Standard check of p_commit.
673: IF (FND_API.To_Boolean(p_commit)) THEN
674: COMMIT WORK;
675: END IF;
676:

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

673: IF (FND_API.To_Boolean(p_commit)) THEN
674: COMMIT WORK;
675: END IF;
676:
677: -- Standard call to get message count and if count is 1, get message info.
678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
679: p_data => x_msg_data );
680:
681: EXCEPTION

APPS.JTF_PERZ_DATA_PUB dependencies on STANDARD

Line 57: --******** Save_Perz_Data local variable for standards **********

Line 61: -- ******* Standard Begins ********