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_ATTRIB

Line 51: -- 1. insert_jtf_perz_lf_attrib

47: -- TABLE HANDLERS
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

Line 309: PROCEDURE update_row_jtf_perz_lf_attrib(

305:
306:
307: -- ****************************************************************************
308: /*
309: PROCEDURE update_row_jtf_perz_lf_attrib(
310: x_Rowid IN OUT VARCHAR2,
311: x_ATTRIBUTE_ID IN NUMBER,
312: x_ATTRIBUTE_NAME IN VARCHAR2,
313: x_ATTRIBUTE_TYPE IN VARCHAR2

Line 316: Update JTF_PERZ_LF_ATTRIB

312: x_ATTRIBUTE_NAME IN VARCHAR2,
313: x_ATTRIBUTE_TYPE IN VARCHAR2
314: ) IS
315: BEGIN
316: Update JTF_PERZ_LF_ATTRIB
317: SET
318: ATTRIBUTE_ID = decode( x_ATTRIBUTE_ID, FND_API.G_MISS_NUM,ATTRIBUTE_ID,x_ATTRIBUTE_ID),
319: ATTRIBUTE_NAME = decode( x_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR,ATTRIBUTE_NAME,x_ATTRIBUTE_NAME),
320: ATTRIBUTE_TYPE = decode( x_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR,ATTRIBUTE_TYPE,x_ATTRIBUTE_TYPE)

Line 326: END update_row_jtf_perz_lf_attrib;

322:
323: If (SQL%NOTFOUND) then
324: RAISE NO_DATA_FOUND;
325: End If;
326: END update_row_jtf_perz_lf_attrib;
327: */
328:
329: -- ****************************************************************************
330: PROCEDURE insert_jtf_perz_lf_attrib(

Line 330: PROCEDURE insert_jtf_perz_lf_attrib(

326: END update_row_jtf_perz_lf_attrib;
327: */
328:
329: -- ****************************************************************************
330: PROCEDURE insert_jtf_perz_lf_attrib(
331: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
332: x_ATTRIBUTE_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
333: x_ATTRIBUTE_NAME IN VARCHAR2,
334: x_ATTRIBUTE_TYPE IN VARCHAR2

Line 337: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_ATTRIB

333: x_ATTRIBUTE_NAME IN VARCHAR2,
334: x_ATTRIBUTE_TYPE IN VARCHAR2
335: ) IS
336:
337: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_ATTRIB
338: WHERE ATTRIBUTE_ID = x_ATTRIBUTE_ID;
339:
340: CURSOR C2 IS SELECT JTF_PERZ_LF_ATTRIB_s.nextval FROM sys.dual;
341:

Line 340: CURSOR C2 IS SELECT JTF_PERZ_LF_ATTRIB_s.nextval FROM sys.dual;

336:
337: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_ATTRIB
338: WHERE ATTRIBUTE_ID = x_ATTRIBUTE_ID;
339:
340: CURSOR C2 IS SELECT JTF_PERZ_LF_ATTRIB_s.nextval FROM sys.dual;
341:
342: BEGIN
343:
344: If (x_ATTRIBUTE_ID IS NULL) then

Line 350: INSERT INTO JTF_PERZ_LF_ATTRIB(

346: FETCH C2 INTO x_ATTRIBUTE_ID;
347: CLOSE C2;
348: End If;
349:
350: INSERT INTO JTF_PERZ_LF_ATTRIB(
351: ATTRIBUTE_ID,
352: ATTRIBUTE_NAME,
353: ATTRIBUTE_TYPE,
354: OBJECT_VERSION_NUMBER,

Line 373: End insert_jtf_perz_lf_attrib;

369: If (C%NOTFOUND) then
370: CLOSE C;
371: RAISE NO_DATA_FOUND;
372: End If;
373: End insert_jtf_perz_lf_attrib;
374: -- ****************************************************************************
375:
376: PROCEDURE Insert_jtf_perz_lf_obj_type(
377: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 518: from jtf_perz_lf_attrib

514:
515: if (l_attribute_id is null) then
516: select rowid, attribute_id
517: into x_rowid, x_attribute_id
518: from jtf_perz_lf_attrib
519: where attribute_name = p_attribute_name
520: and attribute_type = p_attribute_type;
521:
522: if (x_rowid is not null) then

Line 530: from jtf_perz_lf_attrib

526: end if;
527: else
528: select rowid, attribute_id
529: into x_rowid, x_attribute_id
530: from jtf_perz_lf_attrib
531: where attribute_id = l_attribute_id;
532:
533: if (x_rowid is not null) then
534: x_return_status := FND_API.G_TRUE;

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 1503: insert_jtf_perz_lf_attrib(

1499: -- insert row into the attribute table
1500: -- Enhancement 1097254 Begins
1501: l_rowid := NULL;
1502: l_attribute_id := NULL;
1503: insert_jtf_perz_lf_attrib(
1504: l_rowid,
1505: l_attribute_id,
1506: l_attrib_value_tbl(l_curr_row).attribute_name,
1507: l_attrib_value_tbl(l_curr_row).attribute_type

Line 2241: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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

Line 2264: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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
2268: a.parent_id = p_object_id

Line 2288: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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
2292: o.object_name = p_object_name

Line 2313: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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
2317: o.object_name = p_object_name

Line 2337: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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

Line 2359: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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
2363: a.object_id = p_object_id

Line 2383: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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
2387: a.object_name = p_object_name

Line 2408: jtf_perz_lf_attrib c, jtf_perz_lf_value d,

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

Line 3174: insert_jtf_perz_lf_attrib(

3170: -- Create the attribute
3171:
3172: l_rowid := NULL;
3173: l_attribute_id := NULL;
3174: insert_jtf_perz_lf_attrib(
3175: l_rowid,
3176: l_attribute_id,
3177: l_attrib_rec_tbl(l_curr_row).attribute_name,
3178: l_attrib_rec_tbl(l_curr_row).attribute_type

Line 3269: FROM JTF_PERZ_LF_ATTRIB

3265:
3266: FOR l_curr_row in 1..l_count LOOP
3267: BEGIN
3268: SELECT attribute_id INTO l_attribute_id
3269: FROM JTF_PERZ_LF_ATTRIB
3270: WHERE attribute_name = p_attrib_rec_tbl(l_curr_row).ATTRIBUTE_NAME and
3271: attribute_type = p_attrib_rec_tbl(l_curr_row).ATTRIBUTE_TYPE;
3272: EXCEPTION
3273: WHEN NO_DATA_FOUND THEN

Line 3277: insert_jtf_perz_lf_attrib(

3273: WHEN NO_DATA_FOUND THEN
3274: -- insert row into the attribute table
3275: l_rowid := NULL;
3276: l_attribute_id := NULL;
3277: insert_jtf_perz_lf_attrib(
3278: l_rowid,
3279: l_attribute_id,
3280: l_attrib_rec_tbl(l_curr_row).attribute_name,
3281: l_attrib_rec_tbl(l_curr_row).attribute_type