APPS.JTF_PERZ_PROFILE_PVT dependencies on JTF_PERZ_PROFILE_PVT

Line 1: PACKAGE BODY JTF_PERZ_PROFILE_PVT as

1: PACKAGE BODY JTF_PERZ_PROFILE_PVT as
2: /* $Header: jtfzvpfb.pls 120.2 2005/11/02 22:47:33 skothe ship $ */
3: --
4: --
5: -- Start of Comments

Line 9: -- JTF_PERZ_PROFILE_PVT

5: -- Start of Comments
6: --
7: -- NAME
8: --
9: -- JTF_PERZ_PROFILE_PVT
10: --
11: -- PURPOSE
12: -- Private API for managing common functionality across the personalization
13: -- framework.

Line 44: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_PROFILE_PVT';

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';
45: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvzpfb.pls';
46:
47:
48: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 319: -- dbms_output.put_line('JTF_PERZ_PROFILE_PVT Define columns');

315: BEGIN
316:
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
318: THEN
319: -- dbms_output.put_line('JTF_PERZ_PROFILE_PVT Define columns');
320: null;
321: END IF;
322:
323: dbms_sql.define_column(p_cur_profile, 1, p_profile_attrib_rec.PROFILE_ID);

Line 339: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Get column values');

335:
336: PROCEDURE Get_Columns_Profile(p_cur_profile IN NUMBER,
337: p_profile_attrib_rec OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_OUT_REC_TYPE ) IS
338: BEGIN
339: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Get column values');
340:
341: dbms_sql.column_value(p_cur_profile, 1, p_profile_attrib_rec.PROFILE_ID);
342: dbms_sql.column_value(p_cur_profile, 2, p_profile_attrib_rec.PROFILE_NAME);
343: dbms_sql.column_value(p_cur_profile, 3, p_profile_attrib_rec.PROFILE_TYPE);

Line 370: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Bind variables');

366: -- Only those that are not NULL
367:
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
369: THEN
370: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Bind variables');
371: null;
372: END IF;
373:
374: If (p_profile_name IS NOT NULL) Then

Line 421: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Generate Where');

417: BEGIN
418:
419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
420: THEN
421: --dbms_output.put_line('JTF_PERZ_PROFILE_PVT Generate Where');
422: null;
423: END IF;
424:
425:

Line 1230: END JTF_PERZ_PROFILE_PVT;

1226: END Update_Profile;
1227: -- ****************************************************************************
1228: -- ****************************************************************************
1229:
1230: END JTF_PERZ_PROFILE_PVT;