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

Line 1: PACKAGE BODY JTF_PERZ_PROFILE_PUB as

1: PACKAGE BODY JTF_PERZ_PROFILE_PUB as
2: /* $Header: jtfzppfb.pls 120.2 2005/11/02 04:20:20 skothe ship $ */
3: --
4: --
5: -- Start of Comments

Line 8: -- JTF_PERZ_PROFILE_PUB

4: --
5: -- Start of Comments
6: --
7: -- NAME
8: -- JTF_PERZ_PROFILE_PUB
9: --
10: -- PURPOSE
11: -- Public API for
12: --

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_PROFILE_PUB';

24: -- End of Comments
25:
26: --******************************************************************************
27: --******************************************************************************
28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_PROFILE_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpppfb.pls';
30: --******************************************************************************
31: --
32: -- API name : Create_Profile

Line 46: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

42: -- p_profile_id IN NUMBER
43: -- p_profile_name IN VARCHAR2
44: -- p_profile_type IN VARCHAR2
45: -- p_profile_desc IN VARCHAR2
46: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
47: --
48: -- OUT :
49: -- x_return_status OUT VARCHAR2(1)
50: -- x_msg_count OUT NUMBER

Line 81: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

77: p_profile_id IN NUMBER,
78: p_profile_name IN VARCHAR2 := NULL,
79: p_profile_type IN VARCHAR2 := NULL,
80: p_profile_desc IN VARCHAR2 := NULL,
81: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
82: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
83:
84: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 82: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

78: p_profile_name IN VARCHAR2 := NULL,
79: p_profile_type IN VARCHAR2 := NULL,
80: p_profile_desc IN VARCHAR2 := NULL,
81: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
82: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
83:
84: x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
85: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
86: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 100: SAVEPOINT CREATE_JTF_PERZ_PROFILE_PUB;

96:
97: -- ******* Standard Begins ********
98:
99: -- Standard Start of API savepoint
100: SAVEPOINT CREATE_JTF_PERZ_PROFILE_PUB;
101:
102: -- Standard call to check for call compatibility.
103: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
104: -- THEN

Line 157: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;

153: EXCEPTION
154:
155: WHEN FND_API.G_EXC_ERROR THEN
156:
157: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data

Line 171: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;

167: END IF;
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170:
171: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: ( p_count => x_msg_count,
175: p_data => x_msg_data

Line 185: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;

181: END IF;
182:
183: WHEN OTHERS THEN
184:
185: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data

Line 220: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

216: -- p_profile_id IN NUMBER Optional
217: -- p_profile_name IN VARCHAR2 Optional
218: -- p_profile_type IN VARCHAR2
219: -- p_profile_desc IN VARCHAR2
220: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
221: --
222: -- OUT :
223: -- x_Profile_Tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,
224: -- x_return_status OUT VARCHAR2(1)

Line 223: -- x_Profile_Tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,

219: -- p_profile_desc IN VARCHAR2
220: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
221: --
222: -- OUT :
223: -- x_Profile_Tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,
224: -- x_return_status OUT VARCHAR2(1)
225: -- x_msg_count OUT NUMBER
226: -- x_msg_data OUT VARCHAR2(2000)
227: --

Line 252: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

248: p_profile_name IN VARCHAR2,
249: p_profile_type IN VARCHAR2,
250: p_profile_desc IN VARCHAR2,
251: p_active_flag IN VARCHAR2,
252: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
253: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
254: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
255: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
256: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 253: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

249: p_profile_type IN VARCHAR2,
250: p_profile_desc IN VARCHAR2,
251: p_active_flag IN VARCHAR2,
252: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
253: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
254: x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
255: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
256: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
257: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 270: SAVEPOINT UPDATE_JTF_PERZ_PROFILE_PUB;

266:
267: -- ******* Standard Begins ********
268:
269: -- Standard Start of API savepoint
270: SAVEPOINT UPDATE_JTF_PERZ_PROFILE_PUB;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 330: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;

326: EXCEPTION
327:
328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count,
334: p_data => x_msg_data

Line 344: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;

340: END IF;
341:
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343:
344: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: FND_MSG_PUB.Count_And_Get
348: ( p_count => x_msg_count,

Line 359: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;

355: END IF;
356:
357: WHEN OTHERS THEN
358:
359: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361:
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,

Line 389: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,

385: -- p_profile_id IN NUMBER Optional
386: -- p_profile_name IN VARCHAR2 Optional
387: -- p_profile_type IN VARCHAR2
388: -- p_profile_desc IN VARCHAR2
389: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
390: --
391: -- OUT :
392: -- x_profile_tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,
393: -- x_return_status OUT VARCHAR2(1)

Line 392: -- x_profile_tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,

388: -- p_profile_desc IN VARCHAR2
389: -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE,
390: --
391: -- OUT :
392: -- x_profile_tbl OUT JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL,
393: -- x_return_status OUT VARCHAR2(1)
394: -- x_msg_count OUT NUMBER
395: -- x_msg_data OUT VARCHAR2(2000)
396: --

Line 414: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

410:
411: p_profile_id IN NUMBER,
412: p_profile_name IN VARCHAR2,
413: p_profile_type IN VARCHAR2,
414: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
415: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
416:
417: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
418: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 415: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,

411: p_profile_id IN NUMBER,
412: p_profile_name IN VARCHAR2,
413: p_profile_type IN VARCHAR2,
414: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
415: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
416:
417: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
418: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
419: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 417: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,

413: p_profile_type IN VARCHAR2,
414: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
415: := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
416:
417: x_profile_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL_TYPE,
418: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
419: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
420: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421: )IS

Line 478: END JTF_PERZ_PROFILE_PUB ;

474: -- x_profile_tbl(1).attribute_value := 'attribval1';
475: end Get_Profile;
476: --******************************************************************************
477: --******************************************************************************
478: END JTF_PERZ_PROFILE_PUB ;