28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups pbg
32: , ota_suppliable_resources tsr
33: where tsr.supplied_resource_id = p_supplied_resource_id
34: and pbg.business_group_id = tsr.business_group_id;
35: --
36: -- Declare local variables
100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups pbg
104: , ota_suppliable_resources tsr
105: where tsr.supplied_resource_id = p_supplied_resource_id
106: and pbg.business_group_id = tsr.business_group_id;
107: --
108: -- Declare local variables
226: p_name varchar2,
227: p_resource_type varchar2 default null
228: ) is
229: ----------------
230: l_business_group_id ota_suppliable_resources.business_group_id%type ;
231: l_resource_type ota_suppliable_resources.resource_type%type ;
232:
233: cursor csr_tsr_bsg_type is
234: select business_group_id,resource_type
227: p_resource_type varchar2 default null
228: ) is
229: ----------------
230: l_business_group_id ota_suppliable_resources.business_group_id%type ;
231: l_resource_type ota_suppliable_resources.resource_type%type ;
232:
233: cursor csr_tsr_bsg_type is
234: select business_group_id,resource_type
235: from ota_suppliable_resources
231: l_resource_type ota_suppliable_resources.resource_type%type ;
232:
233: cursor csr_tsr_bsg_type is
234: select business_group_id,resource_type
235: from ota_suppliable_resources
236: where supplied_resource_id = p_supplied_resource_id ;
237:
238: cursor csr_tsr is
239: select tsr.supplied_resource_id
236: where supplied_resource_id = p_supplied_resource_id ;
237:
238: cursor csr_tsr is
239: select tsr.supplied_resource_id
240: from ota_suppliable_resources tsr, ota_suppliable_resources_tl srt
241: where tsr.business_group_id = l_business_group_id
242: and srt.supplied_resource_id = tsr.supplied_resource_id
243: and srt.language = p_language
244: and (p_supplied_resource_id is null or p_supplied_resource_id <> srt.supplied_resource_id)