[Home] [Help]
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
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),
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
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,
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;
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;
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;
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
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
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
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
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
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
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
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
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
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