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_TYPE_MAP

Line 54: -- 4. insert_jtf_perz_obj_type_map

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
57:
58: -- 7. update_jtf_perz_lf_obj_type

Line 270: PROCEDURE insert_jtf_perz_obj_type_map(

266: End Insert_jtf_perz_lf_value;
267:
268: -- ****************************************************************************
269:
270: PROCEDURE insert_jtf_perz_obj_type_map(
271: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
272: x_MAP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
273: x_OBJECT_TYPE_ID IN NUMBER,
274: x_ATTRIBUTE_ID IN NUMBER

Line 276: CURSOR C IS SELECT rowid FROM jtf_perz_obj_type_map

272: x_MAP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
273: x_OBJECT_TYPE_ID IN NUMBER,
274: x_ATTRIBUTE_ID IN NUMBER
275: ) IS
276: CURSOR C IS SELECT rowid FROM jtf_perz_obj_type_map
277: WHERE obj_type_map_id = x_MAP_ID;
278: CURSOR C2 IS SELECT jtf_perz_obj_type_map_s.nextval FROM sys.dual;
279: BEGIN
280: If (x_MAP_ID IS NULL) then

Line 278: CURSOR C2 IS SELECT jtf_perz_obj_type_map_s.nextval FROM sys.dual;

274: x_ATTRIBUTE_ID IN NUMBER
275: ) IS
276: CURSOR C IS SELECT rowid FROM jtf_perz_obj_type_map
277: WHERE obj_type_map_id = x_MAP_ID;
278: CURSOR C2 IS SELECT jtf_perz_obj_type_map_s.nextval FROM sys.dual;
279: BEGIN
280: If (x_MAP_ID IS NULL) then
281: OPEN C2;
282: FETCH C2 INTO x_MAP_ID;

Line 285: INSERT INTO jtf_perz_obj_type_map(

281: OPEN C2;
282: FETCH C2 INTO x_MAP_ID;
283: CLOSE C2;
284: End If;
285: INSERT INTO jtf_perz_obj_type_map(
286: obj_type_map_id,
287: OBJECT_TYPE_ID,
288: ATTRIBUTE_ID,
289: CREATED_BY,

Line 304: End insert_jtf_perz_obj_type_map;

300: If (C%NOTFOUND) then
301: CLOSE C;
302: RAISE NO_DATA_FOUND;
303: End If;
304: End insert_jtf_perz_obj_type_map;
305:
306:
307: -- ****************************************************************************
308: /*

Line 760: from jtf_perz_obj_type_map a, jtf_perz_lf_attrib b

756: l_attribute_type VARCHAR2(30);
757:
758: CURSOR C_GET_ATTRIBUTES (p_Object_type_Id NUMBER) IS
759: SELECT a.attribute_id, b.attribute_name, b.attribute_type
760: from jtf_perz_obj_type_map a, jtf_perz_lf_attrib b
761: where a.object_type_id = p_object_type_id
762: and a.attribute_id = b.attribute_id;
763: BEGIN
764:

Line 1079: from jtf_perz_obj_type_map a, jtf_perz_lf_attrib b

1075: then
1076: begin
1077: select a.obj_type_map_id
1078: into l_type_map_id
1079: from jtf_perz_obj_type_map a, jtf_perz_lf_attrib b
1080: where object_type_id = l_object_type_id
1081: and attribute_name = l_attrib_value_tbl(l_curr_row).attribute_name
1082: and attribute_type = l_attrib_value_tbl(l_curr_row).attribute_type
1083: and a.attribute_id = b.attribute_id

Line 1099: from jtf_perz_obj_type_map a

1095: else
1096: begin
1097: select a.obj_type_map_id
1098: into l_type_map_id
1099: from jtf_perz_obj_type_map a
1100: where a.object_type_id = l_object_type_id
1101: and a.attribute_id = l_attrib_value_tbl(l_curr_row).attribute_id;
1102:
1103: EXCEPTION

Line 1514: -- jtf_perz_obj_type_map table

1510: -- raising the error if unable to insert the attribute record
1511: RAISE FND_API.G_EXC_ERROR;
1512: end if;
1513: -- create a map entry object_type - attribute in
1514: -- jtf_perz_obj_type_map table
1515: l_map_id := null;
1516: l_rowid := NULL;
1517: insert_jtf_perz_obj_type_map(
1518: l_rowid,

Line 1517: insert_jtf_perz_obj_type_map(

1513: -- create a map entry object_type - attribute in
1514: -- jtf_perz_obj_type_map table
1515: l_map_id := null;
1516: l_rowid := NULL;
1517: insert_jtf_perz_obj_type_map(
1518: l_rowid,
1519: l_map_id,
1520: l_object_type_id,
1521: l_attribute_id

Line 1553: jtf_perz_obj_type_map f

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
1557: and f.attribute_id = l_attribute_id

Line 1598: from jtf_perz_obj_type_map

1594: -- Checking the attribute - object type map
1595: BEGIN
1596: l_map_id := NULL;
1597: select obj_type_map_id into l_map_id
1598: from jtf_perz_obj_type_map
1599: where attribute_id = l_attribute_id
1600: and object_type_id = l_object_type_id;
1601: -- SMATTEGU Bug#1098513 changes begin
1602: BEGIN

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

Line 3196: from jtf_perz_obj_type_map

3192: -- For a given object type Check if the attribute map exists or not
3193:
3194: BEGIN
3195: select obj_type_map_id into x_obj_type_map_tbl(l_inserted_map).TYPE_MAP_ID
3196: from jtf_perz_obj_type_map
3197: where object_type_id = l_object_type_id
3198: and attribute_id = l_attribute_id;
3199: l_inserted_map := l_inserted_map + 1;
3200:

Line 3207: insert_jtf_perz_obj_type_map(

3203: -- There is no map for the given object type and attribute
3204: -- Create the map
3205: l_map_id := null;
3206: l_rowid := NULL;
3207: insert_jtf_perz_obj_type_map(
3208: l_rowid,
3209: l_map_id,
3210: l_object_type_id,
3211: l_attribute_id

Line 3289: -- jtf_perz_obj_type_map table

3285: RAISE FND_API.G_EXC_ERROR;
3286: end if;
3287: END;
3288: -- create a map entry object_type - attribute in
3289: -- jtf_perz_obj_type_map table
3290: l_map_id := null;
3291: l_rowid := NULL;
3292: insert_jtf_perz_obj_type_map(
3293: l_rowid,

Line 3292: insert_jtf_perz_obj_type_map(

3288: -- create a map entry object_type - attribute in
3289: -- jtf_perz_obj_type_map table
3290: l_map_id := null;
3291: l_rowid := NULL;
3292: insert_jtf_perz_obj_type_map(
3293: l_rowid,
3294: l_map_id,
3295: l_object_type_id,
3296: l_attribute_id