APPS.OTA_TSR_BUS dependencies on OTA_SUPPLIABLE_RESOURCES

Line 56: , ota_suppliable_resources tsr

52: cursor csr_sec_grp is
53: select pbg.security_group_id,
54: pbg.legislation_code
55: from per_business_groups_perf pbg
56: , ota_suppliable_resources tsr
57: where tsr.supplied_resource_id = p_supplied_resource_id
58: and pbg.business_group_id = tsr.business_group_id;
59: --
60: -- Declare local variables

Line 246: from ota_suppliable_resources_vl

242: ) is
243: ----------------
244: cursor cur_tsr is
245: select 1
246: from ota_suppliable_resources_vl
247: where business_group_id = p_biz
248: and (p_suppres_id is null or p_suppres_id <> supplied_resource_id)
249: and name = p_name
250: and resource_type = p_resource_type;

Line 917: ,p_descflex_name => 'OTA_SUPPLIABLE_RESOURCES'

913: --
914:
915: hr_dflex_utility.ins_or_upd_descflex_attribs
916: (p_appl_short_name => 'OTA'
917: ,p_descflex_name => 'OTA_SUPPLIABLE_RESOURCES'
918: ,p_attribute_category => p_rec.tsr_information_category
919: ,p_attribute1_name => 'TSR_INFORMATION1'
920: ,p_attribute1_value => p_rec.tsr_information1
921: ,p_attribute2_name => 'TSR_INFORMATION2'

Line 1146: -- of by the user hooks of ota_suppliable_resources and

1142: -- {Start Of Comments}
1143: --
1144: -- Description:
1145: -- This function will be used by the user hooks. This will be used
1146: -- of by the user hooks of ota_suppliable_resources and
1147: -- ota_resource_booking row handler user hook business process.
1148: --
1149: -- Pre Conditions:
1150: -- This function will be called by the user hook packages.

Line 1178: ota_suppliable_resources tsr

1174: --
1175: cursor csr_leg_code is
1176: select legislation_code
1177: from per_business_groups_perf pbg,
1178: ota_suppliable_resources tsr
1179: where pbg.business_group_id = tsr.business_group_id
1180: and tsr.supplied_resource_id = p_supplied_resource_id;
1181:
1182: