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_LF_PVT dependencies on JTF_PERZ_LF_OBJECT

Line 52: -- 2. Insert_Row_jtf_perz_lf_object

48: --
49: -- The following are the table handlers
50: --
51: -- 1. insert_jtf_perz_lf_attrib
52: -- 2. Insert_Row_jtf_perz_lf_object
53: -- 3. insert_jtf_perz_lf_obj_type
54: -- 4. insert_jtf_perz_obj_type_map
55: -- 5. Insert_jtf_perz_lf_value
56: -- 6. insert_jtf_perz_obj_map

Line 60: -- 9. update_jtf_perz_lf_object

56: -- 6. insert_jtf_perz_obj_map
57:
58: -- 7. update_jtf_perz_lf_obj_type
59: -- 8. update_jtf_perz_lf_value
60: -- 9. update_jtf_perz_lf_object
61:
62: -- ****************************************************************************
63: PROCEDURE update_jtf_perz_lf_object (
64: x_object_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 63: PROCEDURE update_jtf_perz_lf_object (

59: -- 8. update_jtf_perz_lf_value
60: -- 9. update_jtf_perz_lf_object
61:
62: -- ****************************************************************************
63: PROCEDURE update_jtf_perz_lf_object (
64: x_object_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
65: x_parent_id IN NUMBER,
66: x_application_id IN NUMBER,
67: x_object_description IN VARCHAR2,

Line 71: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT

67: x_object_description IN VARCHAR2,
68: x_rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69: p_OBJECT_VERSION_NUMBER IN NUMBER
70: ) IS
71: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT
72: WHERE object_id = x_object_id;
73: BEGIN
74: update JTF_PERZ_LF_OBJECT
75: set parent_id = decode( x_parent_id, FND_API.G_MISS_NUM,parent_id,

Line 74: update JTF_PERZ_LF_OBJECT

70: ) IS
71: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT
72: WHERE object_id = x_object_id;
73: BEGIN
74: update JTF_PERZ_LF_OBJECT
75: set parent_id = decode( x_parent_id, FND_API.G_MISS_NUM,parent_id,
76: NULL, parent_id, x_parent_id),
77: object_description = decode( x_object_description, FND_API.G_MISS_CHAR,
78: object_description, NULL, object_description, x_object_description),

Line 98: end update_jtf_perz_lf_object;

94: CLOSE C;
95: RAISE NO_DATA_FOUND;
96: End If;
97:
98: end update_jtf_perz_lf_object;
99: -- ****************************************************************************
100: PROCEDURE update_jtf_perz_lf_obj_type (
101: x_object_type_desc IN VARCHAR2,
102: x_object_type_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 107: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE

103: x_rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: p_OBJECT_VERSION_NUMBER IN NUMBER
105: )IS
106:
107: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE
108: where object_type_id = x_object_type_id;
109: BEGIN
110: Update JTF_PERZ_LF_OBJECT_TYPE
111: SET

Line 110: Update JTF_PERZ_LF_OBJECT_TYPE

106:
107: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE
108: where object_type_id = x_object_type_id;
109: BEGIN
110: Update JTF_PERZ_LF_OBJECT_TYPE
111: SET
112: OBJECT_TYPE_DESC =
113: decode( x_object_type_desc, FND_API.G_MISS_CHAR,
114: OBJECT_TYPE_DESC,x_object_type_desc),

Line 383: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE

379: x_OBJECT_TYPE IN VARCHAR2,
380: x_OBJECT_TYPE_DESC IN VARCHAR2
381: ) IS
382:
383: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE
384: WHERE OBJECT_TYPE_ID = x_OBJECT_TYPE_ID;
385: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJ_TYPE_s.nextval FROM sys.dual;
386:
387: BEGIN

Line 396: INSERT INTO JTF_PERZ_LF_OBJECT_TYPE(

392: CLOSE C2;
393: End If;
394:
395:
396: INSERT INTO JTF_PERZ_LF_OBJECT_TYPE(
397: OBJECT_TYPE_ID,
398: OBJECT_TYPE_NAME,
399: OBJECT_TYPE_DESC,
400: OBJECT_VERSION_NUMBER,

Line 424: PROCEDURE Insert_jtf_perz_lf_object(

420: End Insert_jtf_perz_lf_obj_type;
421:
422: -- ****************************************************************************
423:
424: PROCEDURE Insert_jtf_perz_lf_object(
425: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
426: x_OBJECT_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
427: x_PARENT_ID IN NUMBER,
428: x_APPLICATION_ID IN NUMBER,

Line 433: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT

429: x_OBJECT_NAME IN VARCHAR2,
430: x_OBJECT_DESCRIPTION IN VARCHAR2
431: ) IS
432:
433: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT
434: WHERE OBJECT_ID = x_OBJECT_ID;
435: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJECT_s.nextval FROM sys.dual;
436:
437: BEGIN

Line 435: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJECT_s.nextval FROM sys.dual;

431: ) IS
432:
433: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT
434: WHERE OBJECT_ID = x_OBJECT_ID;
435: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJECT_s.nextval FROM sys.dual;
436:
437: BEGIN
438:
439: If (x_OBJECT_ID IS NULL) then

Line 445: INSERT INTO JTF_PERZ_LF_OBJECT(

441: FETCH C2 INTO x_OBJECT_ID;
442: CLOSE C2;
443: End If;
444:
445: INSERT INTO JTF_PERZ_LF_OBJECT(
446: OBJECT_ID,
447: PARENT_ID,
448: APPLICATION_ID,
449: OBJECT_NAME,

Line 473: End Insert_jtf_perz_lf_object;

469: CLOSE C;
470: RAISE NO_DATA_FOUND;
471: End If;
472:
473: End Insert_jtf_perz_lf_object;
474:
475: -- ***************************************************************************
476: -- ***************************************************************************
477: --

Line 585: from jtf_perz_lf_object_type

581: (x_object_type_id = FND_API.G_MISS_NUM))
582: then
583: select object_type_id, object_version_number
584: into l_object_type_id, x_object_version_number
585: from jtf_perz_lf_object_type
586: where object_type_name = p_object_type;
587:
588: x_object_type_id := l_object_type_id;
589: x_return_status := FND_API.G_TRUE;

Line 599: from jtf_perz_lf_object_type

595: then
596:
597: select object_type_id, object_version_number
598: into l_object_type_id, x_object_version_number
599: from jtf_perz_lf_object_type
600: where object_type_id = x_object_type_id ;
601:
602: x_object_type_id := l_object_type_id;
603: x_return_status := FND_API.G_TRUE;

Line 612: from jtf_perz_lf_object_type

608: (x_object_type_id <> FND_API.G_MISS_NUM))
609: then
610: select object_type_id, object_version_number
611: into l_object_type_id, x_object_version_number
612: from jtf_perz_lf_object_type
613: where object_type_id = x_object_type_id;
614: --and object_type_name = upper(p_object_type);
615:
616: x_object_type_id := l_object_type_id;

Line 670: from jtf_perz_lf_object

666: and ((x_object_id is null) OR (x_object_id = FND_API.G_MISS_NUM))) then
667:
668: select object_id, object_version_number
669: into l_object_id, x_object_version_number
670: from jtf_perz_lf_object
671: where object_name = p_object_name
672: and application_id = p_application_id;
673:
674: x_object_id := l_object_id;

Line 683: from jtf_perz_lf_object

679: and ((x_object_id is not null) OR (x_object_id <> FND_API.G_MISS_NUM))) then
680:
681: select object_id, object_version_number
682: into l_object_id, x_object_version_number
683: from jtf_perz_lf_object
684: where object_id = x_object_id
685: and application_id = p_application_id;
686:
687: x_object_id := l_object_id;

Line 696: from jtf_perz_lf_object

692: and ((x_object_id is not null) OR (x_object_id <> FND_API.G_MISS_NUM))) then
693:
694: select object_id, object_version_number
695: into l_object_id, x_object_version_number
696: from jtf_perz_lf_object
697: where object_id = x_object_id and
698: object_name = p_object_name
699: and application_id = p_application_id;
700:

Line 770: from jtf_perz_lf_object_type

766: (p_object_type_id <> FND_API.G_MISS_NUM)) then
767:
768: select object_type_id, object_type_desc
769: into l_object_type_id, x_object_type_desc
770: from jtf_perz_lf_object_type
771: where object_type_id = p_object_type_id;
772: x_return_status := FND_API.G_TRUE;
773:
774: elsif (( p_object_type is not null) OR

Line 779: from jtf_perz_lf_object_type

775: ( p_object_type <> FND_API.G_MISS_CHAR)) then
776:
777: select object_type_id, object_type_desc
778: into l_object_type_id, x_object_type_desc
779: from jtf_perz_lf_object_type
780: where object_type_name = p_object_type;
781: x_return_status := FND_API.G_TRUE;
782:
783: else

Line 1049: Insert_jtf_perz_lf_object(

1045: l_object_name := p_object_name ;
1046: l_object_id := p_object_id;
1047: -- Object_description is not a parameter in public and pvt spec. hence
1048: -- passing null to the table handler - Srikanth 9-3-99
1049: Insert_jtf_perz_lf_object(
1050: l_rowid,
1051: l_object_id,
1052: p_parent_id,
1053: p_application_id,

Line 1439: update_jtf_perz_lf_object (

1435: -- parent id does not exist
1436: RAISE FND_API.G_EXC_ERROR;
1437: else
1438: -- Update the object with the parent id
1439: update_jtf_perz_lf_object (
1440: l_object_id,
1441: l_parent_id,
1442: p_application_id,
1443: l_object_description,

Line 2240: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2236: d.perz_lf_value_id, a.parent_id, a.object_id, a.application_id, a.object_name,
2237: a.object_description, b.object_type_id, b.object_type_name,
2238: c.attribute_id, c.attribute_name, c.attribute_type,
2239: d.attribute_value, d.active_flag, d.priority
2240: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2241: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2242: jtf_perz_obj_map e, jtf_perz_obj_type_map f
2243: where
2244: a.parent_id = p_object_id

Line 2263: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2259: d.perz_lf_value_id, a.parent_id, a.object_id, a.application_id, a.object_name,
2260: a.object_description, b.object_type_id, b.object_type_name,
2261: c.attribute_id, c.attribute_name, c.attribute_type,
2262: d.attribute_value, d.active_flag, d.priority
2263: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2264: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2265: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2266: jtf_perz_profile p
2267: where

Line 2287: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2283: select d.perz_lf_value_id, a.parent_id, a.object_id, a.application_id, a.object_name,
2284: a.object_description, b.object_type_id, b.object_type_name,
2285: c.attribute_id, c.attribute_name, c.attribute_type,
2286: d.attribute_value, d.active_flag, d.priority
2287: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2288: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2289: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2290: jtf_perz_lf_object o, jtf_perz_profile p
2291: where

Line 2290: jtf_perz_lf_object o, jtf_perz_profile p

2286: d.attribute_value, d.active_flag, d.priority
2287: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2288: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2289: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2290: jtf_perz_lf_object o, jtf_perz_profile p
2291: where
2292: o.object_name = p_object_name
2293: and o.object_id = a.parent_id
2294: and a.application_id = p_application_id

Line 2312: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2308: select d.perz_lf_value_id, a.parent_id, a.object_id, a.application_id, a.object_name,
2309: a.object_description, b.object_type_id, b.object_type_name,
2310: c.attribute_id, c.attribute_name, c.attribute_type,
2311: d.attribute_value, d.active_flag, d.priority
2312: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2313: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2314: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2315: jtf_perz_lf_object o
2316: where

Line 2315: jtf_perz_lf_object o

2311: d.attribute_value, d.active_flag, d.priority
2312: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2313: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2314: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2315: jtf_perz_lf_object o
2316: where
2317: o.object_name = p_object_name
2318: and o.object_id = a.parent_id
2319: and a.application_id = p_application_id

Line 2336: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2332: a.application_id, a.object_name,
2333: a.object_description, b.object_type_id, b.object_type_name,
2334: c.attribute_id, c.attribute_name, c.attribute_type,
2335: d.attribute_value, d.active_flag, d.priority
2336: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2337: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2338: jtf_perz_obj_map e, jtf_perz_obj_type_map f
2339: where
2340: a.object_id = p_object_id

Line 2358: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2354: a.application_id, a.object_name,
2355: a.object_description, b.object_type_id, b.object_type_name,
2356: c.attribute_id, c.attribute_name, c.attribute_type,
2357: d.attribute_value, d.active_flag, d.priority
2358: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2359: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2360: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2361: jtf_perz_profile p
2362: where

Line 2382: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2378: a.application_id, a.object_name,
2379: a.object_description, b.object_type_id, b.object_type_name,
2380: c.attribute_id, c.attribute_name, c.attribute_type,
2381: d.attribute_value, d.active_flag, d.priority
2382: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2383: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2384: jtf_perz_obj_map e, jtf_perz_obj_type_map f,
2385: jtf_perz_profile p
2386: where

Line 2407: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,

2403: a.application_id, a.object_name,
2404: a.object_description, b.object_type_id, b.object_type_name,
2405: c.attribute_id, c.attribute_name, c.attribute_type,
2406: d.attribute_value, d.active_flag, d.priority
2407: from jtf_perz_lf_object a, jtf_perz_lf_object_type b,
2408: jtf_perz_lf_attrib c, jtf_perz_lf_value d,
2409: jtf_perz_obj_map e, jtf_perz_obj_type_map f
2410: where
2411: a.object_name = p_object_name