[Home] [Help]
18: select a.resource_list_member_id
19: into p_resource_list_member_id
20: from pa_resource_list_members a,
21: pa_resources b,
22: pa_resource_types c
23: where c.resource_type_code = 'UNCLASSIFIED'
24: and b.resource_type_id = c.resource_type_id
25: and a.resource_id = b.resource_id
26: and a.resource_list_id = p_resource_list_id
174:
175: /* -------------------------------- Bug reference : 3631208 -------------------+
176: -- Cursor modified as above
177: select distinct a.resource_type_code resource_type_code
178: from pa_resource_types a,
179: pa_resources b,
180: pa_resource_list_members c
181: where c.resource_list_id = x_resource_list_id
182: and b.resource_id = c.resource_id
197: b.name,
198: a.resource_type_code,
199: b.resource_type_id,
200: c.parent_member_id
201: from pa_resource_types a,
202: pa_resources b,
203: pa_resource_list_members c
204: where c.resource_list_id = x_resource_list_id
205: and b.resource_id = c.resource_id
214: b.name,
215: a.resource_type_code,
216: b.resource_type_id,
217: c.parent_member_id
218: from pa_resource_types a,
219: pa_resources b,
220: pa_resource_list_members c
221: where c.resource_list_id = x_resource_list_id
222: and b.resource_id = c.resource_id
287: If x_group_resource_type_id <> 0 then
288:
289: select prt.resource_type_code
290: into x_group_resource_type_name
291: from pa_resource_types prt
292: where prt.resource_type_id = x_group_resource_type_id;
293:
294: End if;
295:
1190:
1191: /* ------------------------------------------------ Bug reference : 3631208 -----------+
1192: -- Cursor modified as above ..
1193: select distinct a.resource_type_code resource_type_code
1194: from pa_resource_types a,
1195: pa_resources b,
1196: pa_resource_list_members c
1197: where c.resource_list_id = x_resource_list_id
1198: and b.resource_id = c.resource_id
1213: b.name,
1214: a.resource_type_code,
1215: b.resource_type_id,
1216: c.parent_member_id
1217: from pa_resource_types a,
1218: pa_resources b,
1219: pa_resource_list_members c
1220: where c.resource_list_id = x_resource_list_id
1221: and b.resource_id = c.resource_id
1230: b.name,
1231: a.resource_type_code,
1232: b.resource_type_id,
1233: c.parent_member_id
1234: from pa_resource_types a,
1235: pa_resources b,
1236: pa_resource_list_members c
1237: where c.resource_list_id = x_resource_list_id
1238: and b.resource_id = c.resource_id
1303: If x_group_resource_type_id <> 0 then
1304:
1305: select prt.resource_type_code
1306: into x_group_resource_type_name
1307: from pa_resource_types prt
1308: where prt.resource_type_id = x_group_resource_type_id;
1309:
1310: End if;
1311:
1391: select substrb(papf.full_name,1,100)
1392: into l_person_name
1393: from per_all_people_f papf,
1394: pa_resources pr,
1395: pa_resource_types prt
1396: where papf.person_id = x_person_id
1397: and papf.full_name = pr.name
1398: and prt.resource_type_id = pr.resource_type_id
1399: and prt.resource_type_code = 'EMPLOYEE'
2390: END get_resource_rank;
2391:
2392: -- This function returns the group resource_type_code for the given resoure list
2393: -- In case of 'None' Group Resource type, the table pa_resource_lists
2394: -- will not join to the pa_resource_types table
2395:
2396: FUNCTION get_group_resource_type_code
2397: (x_resource_list_id IN NUMBER)
2398: RETURN VARCHAR2
2406: rt.resource_type_code
2407: INTO
2408: x_group_resource_type_code
2409: FROM
2410: pa_resource_types rt,
2411: pa_resource_lists rl
2412: WHERE
2413: rl.resource_list_id = x_resource_list_id
2414: AND rl.group_resource_type_id = rt.resource_type_id;
2613: pa_resource_lists rl,
2614: pa_resource_list_members rlm,
2615: pa_resource_txn_attributes rta,
2616: pa_resources r,
2617: pa_resource_types rt,
2618: pa_resource_list_assignments rla
2619: WHERE
2620: rlm.resource_list_id = rl.resource_list_id
2621: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,
2671: pa_resource_list_assignments rla
2672: WHERE
2673: rlmc.resource_list_id = rl.resource_list_id
2674: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)