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_VALUE

Line 55: -- 5. Insert_jtf_perz_lf_value

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
59: -- 8. update_jtf_perz_lf_value

Line 59: -- 8. update_jtf_perz_lf_value

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
61:
62: -- ****************************************************************************
63: PROCEDURE update_jtf_perz_lf_object (

Line 135: PROCEDURE update_jtf_perz_lf_value(

131: RAISE NO_DATA_FOUND;
132: End If;
133: END update_jtf_perz_lf_obj_type;
134: -- ****************************************************************************
135: PROCEDURE update_jtf_perz_lf_value(
136: x_Rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
137: x_value_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
138: x_PROFILE_ID IN NUMBER,
139: x_MAP_ID IN NUMBER,

Line 146: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE

142: x_PRIORITY IN NUMBER,
143: p_OBJECT_VERSION_NUMBER IN NUMBER
144: ) IS
145:
146: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE
147: WHERE PERZ_LF_VALUE_ID = x_VALUE_ID;
148:
149: BEGIN
150:

Line 151: Update JTF_PERZ_LF_VALUE

147: WHERE PERZ_LF_VALUE_ID = x_VALUE_ID;
148:
149: BEGIN
150:
151: Update JTF_PERZ_LF_VALUE
152: SET
153: PROFILE_ID = decode( x_PROFILE_ID, FND_API.G_MISS_NUM,PROFILE_ID,x_PROFILE_ID),
154: OBJ_MAP_ID = decode( x_MAP_ID, FND_API.G_MISS_NUM,OBJ_MAP_ID,x_MAP_ID),
155: ATTRIBUTE_VALUE = decode( x_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR,ATTRIBUTE_VALUE,x_ATTRIBUTE_VALUE),

Line 175: END update_jtf_perz_lf_value;

171: CLOSE C;
172: RAISE NO_DATA_FOUND;
173: End If;
174:
175: END update_jtf_perz_lf_value;
176: --
177: -- ****************************************************************************
178:
179:

Line 219: PROCEDURE Insert_jtf_perz_lf_value(

215:
216:
217: -- -- ****************************************************************************
218: --
219: PROCEDURE Insert_jtf_perz_lf_value(
220: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
221: x_VALUE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
222: x_PROFILE_ID IN NUMBER,
223: x_MAP_ID IN NUMBER,

Line 228: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE

224: x_ATTRIBUTE_VALUE IN VARCHAR2,
225: x_ACTIVE_FLAG IN VARCHAR2,
226: x_PRIORITY IN NUMBER
227: ) IS
228: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE
229: WHERE PERZ_LF_VALUE_ID = x_VALUE_ID;
230: CURSOR C2 IS SELECT JTF_PERZ_LF_VALUE_s.nextval FROM sys.dual;
231:
232:

Line 230: CURSOR C2 IS SELECT JTF_PERZ_LF_VALUE_s.nextval FROM sys.dual;

226: x_PRIORITY IN NUMBER
227: ) IS
228: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE
229: WHERE PERZ_LF_VALUE_ID = x_VALUE_ID;
230: CURSOR C2 IS SELECT JTF_PERZ_LF_VALUE_s.nextval FROM sys.dual;
231:
232:
233: BEGIN
234:

Line 240: INSERT INTO JTF_PERZ_LF_VALUE(

236: OPEN C2;
237: FETCH C2 INTO x_VALUE_ID;
238: CLOSE C2;
239: End If;
240: INSERT INTO JTF_PERZ_LF_VALUE(
241: PERZ_LF_VALUE_ID,
242: PROFILE_ID,
243: OBJ_MAP_ID,
244: ATTRIBUTE_VALUE,

Line 266: End Insert_jtf_perz_lf_value;

262: If (C%NOTFOUND) then
263: CLOSE C;
264: RAISE NO_DATA_FOUND;
265: End If;
266: End Insert_jtf_perz_lf_value;
267:
268: -- ****************************************************************************
269:
270: PROCEDURE insert_jtf_perz_obj_type_map(

Line 1131: insert_jtf_perz_lf_value(

1127:
1128: l_rowid := NULL;
1129: l_value_id := NULL;
1130: --dbms_output.put_line('l_obj_map_id '||l_obj_map_id);
1131: insert_jtf_perz_lf_value(
1132: l_rowid,
1133: l_value_id,
1134: l_profile_id,
1135: l_obj_map_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 1569: update_jtf_perz_lf_value

1565: ( l_db_active_flag <> l_active_flag) OR
1566: ( l_db_attrib_value_tbl(l_curr_row).priority <>
1567: l_attrib_value_tbl(l_curr_row).priority))
1568: THEN
1569: update_jtf_perz_lf_value
1570: ( l_rowid,
1571: l_value_id,
1572: l_profile_id,
1573: l_obj_map_id,

Line 1591: -- pass the obj_map_id to insert_jtf_perz_lf_value()

1587: -- Check if the attribute - object type map exists
1588: -- if yes
1589: -- call the table handler for object map
1590: -- with appropriate map id
1591: -- pass the obj_map_id to insert_jtf_perz_lf_value()
1592: -- if not raise error
1593:
1594: -- Checking the attribute - object type map
1595: BEGIN

Line 1627: insert_jtf_perz_lf_value(

1623:
1624: l_rowid := NULL;
1625: l_value_id := NULL;
1626: --dbms_output.put_line('l_obj_map_id '||l_obj_map_id);
1627: insert_jtf_perz_lf_value(
1628: l_rowid,
1629: l_value_id,
1630: l_profile_id,
1631: l_obj_map_id,

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