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_OBJ_MAP

Line 56: -- 6. insert_jtf_perz_obj_map

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
57:
58: -- 7. update_jtf_perz_lf_obj_type
59: -- 8. update_jtf_perz_lf_value
60: -- 9. update_jtf_perz_lf_object

Line 180: PROCEDURE insert_jtf_perz_obj_map(

176: --
177: -- ****************************************************************************
178:
179:
180: PROCEDURE insert_jtf_perz_obj_map(
181: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
182: x_OBJ_MAP_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
183: x_TYPE_MAP_ID IN NUMBER,
184: x_OBJECT_ID IN NUMBER

Line 186: CURSOR C IS SELECT rowid FROM JTF_PERZ_OBJ_MAP

182: x_OBJ_MAP_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
183: x_TYPE_MAP_ID IN NUMBER,
184: x_OBJECT_ID IN NUMBER
185: ) IS
186: CURSOR C IS SELECT rowid FROM JTF_PERZ_OBJ_MAP
187: WHERE OBJ_MAP_ID = x_OBJ_MAP_ID;
188: CURSOR C2 IS SELECT JTF_PERZ_OBJ_MAP_s.nextval FROM sys.dual;
189: BEGIN
190: If (x_OBJ_MAP_ID IS NULL) then

Line 188: CURSOR C2 IS SELECT JTF_PERZ_OBJ_MAP_s.nextval FROM sys.dual;

184: x_OBJECT_ID IN NUMBER
185: ) IS
186: CURSOR C IS SELECT rowid FROM JTF_PERZ_OBJ_MAP
187: WHERE OBJ_MAP_ID = x_OBJ_MAP_ID;
188: CURSOR C2 IS SELECT JTF_PERZ_OBJ_MAP_s.nextval FROM sys.dual;
189: BEGIN
190: If (x_OBJ_MAP_ID IS NULL) then
191: OPEN C2;
192: FETCH C2 INTO x_OBJ_MAP_ID;

Line 195: INSERT INTO JTF_PERZ_OBJ_MAP(

191: OPEN C2;
192: FETCH C2 INTO x_OBJ_MAP_ID;
193: CLOSE C2;
194: End If;
195: INSERT INTO JTF_PERZ_OBJ_MAP(
196: OBJ_MAP_ID,
197: MAP_ID,
198: OBJECT_ID,
199: CREATED_BY,

Line 214: End insert_jtf_perz_obj_map;

210: If (C%NOTFOUND) then
211: CLOSE C;
212: RAISE NO_DATA_FOUND;
213: End If;
214: End insert_jtf_perz_obj_map;
215:
216:
217: -- -- ****************************************************************************
218: --

Line 1116: insert_jtf_perz_obj_map(

1112: end if;
1113:
1114: l_rowid := NULL;
1115: l_obj_map_id := NULL;
1116: insert_jtf_perz_obj_map(
1117: l_rowid,
1118: l_obj_map_id,
1119: l_type_map_id,
1120: l_object_id

Line 1552: from jtf_perz_lf_value d, jtf_perz_obj_map e,

1548: l_db_active_flag,
1549: l_db_attrib_value_tbl(l_curr_row).priority,
1550: l_obj_value_ver_no
1551:
1552: from jtf_perz_lf_value d, jtf_perz_obj_map e,
1553: jtf_perz_obj_type_map f
1554: where
1555: e.object_id = l_object_id
1556: and f.object_type_id = l_object_type_id

Line 1604: from jtf_perz_obj_map

1600: and object_type_id = l_object_type_id;
1601: -- SMATTEGU Bug#1098513 changes begin
1602: BEGIN
1603: select OBJ_MAP_ID into l_obj_map_id
1604: from jtf_perz_obj_map
1605: where MAP_ID = l_map_id
1606: and OBJECT_ID = l_object_id;
1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN

Line 1611: insert_jtf_perz_obj_map(

1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN
1609: l_rowid := NULL;
1610: l_obj_map_id := NULL;
1611: insert_jtf_perz_obj_map(
1612: l_rowid,
1613: l_obj_map_id,
1614: l_map_id,
1615: l_object_id

Line 2242: jtf_perz_obj_map e, jtf_perz_obj_type_map f

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
2245: and a.application_id = p_application_id
2246: and d.profile_id = p_profile_id

Line 2265: jtf_perz_obj_map e, jtf_perz_obj_type_map f,

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
2268: a.parent_id = p_object_id
2269: and a.application_id = p_application_id

Line 2289: jtf_perz_obj_map e, jtf_perz_obj_type_map f,

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
2292: o.object_name = p_object_name
2293: and o.object_id = a.parent_id

Line 2314: jtf_perz_obj_map e, jtf_perz_obj_type_map f,

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
2317: o.object_name = p_object_name
2318: and o.object_id = a.parent_id

Line 2338: jtf_perz_obj_map e, jtf_perz_obj_type_map f

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
2341: and a.application_id = p_application_id
2342: and d.profile_id = p_profile_id

Line 2360: jtf_perz_obj_map e, jtf_perz_obj_type_map f,

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
2363: a.object_id = p_object_id
2364: and a.application_id = p_application_id

Line 2384: jtf_perz_obj_map e, jtf_perz_obj_type_map f,

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
2387: a.object_name = p_object_name
2388: and a.application_id = p_application_id

Line 2409: jtf_perz_obj_map e, jtf_perz_obj_type_map f

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
2412: and a.application_id = p_application_id
2413: and d.profile_id = p_profile_id