[Home] [Help]
280: -- # Check whether resource list is grouped
281: -- # if list not grouped then Zero (0) is the value for group_resource_type_id
282: select prl.group_resource_type_id
283: into x_group_resource_type_id
284: from pa_resource_lists prl
285: where prl.resource_list_id = x_resource_list_id ;
286:
287: If x_group_resource_type_id <> 0 then
288:
1296: -- # Check whether resource list is grouped
1297: -- # if list not grouped then Zero (0) is the value for group_resource_type_id
1298: select prl.group_resource_type_id
1299: into x_group_resource_type_id
1300: from pa_resource_lists prl
1301: where prl.resource_list_id = x_resource_list_id;
1302:
1303: If x_group_resource_type_id <> 0 then
1304:
2389: RETURN NULL;
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)
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;
2415:
2609: rta.system_linkage_function,
2610: rta.resource_format_id,
2611: rt.resource_type_code
2612: FROM
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,
2660: NVL(rtac.system_linkage_function,rtap.system_linkage_function),
2661: rtac.resource_format_id,
2662: rtc.resource_type_code
2663: FROM
2664: pa_resource_lists rl,
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,