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 913: ,p_descflex_name => 'OTA_SUPPLIABLE_RESOURCES'

909: --
910:
911: hr_dflex_utility.ins_or_upd_descflex_attribs
912: (p_appl_short_name => 'OTA'
913: ,p_descflex_name => 'OTA_SUPPLIABLE_RESOURCES'
914: ,p_attribute_category => p_rec.tsr_information_category
915: ,p_attribute1_name => 'TSR_INFORMATION1'
916: ,p_attribute1_value => p_rec.tsr_information1
917: ,p_attribute2_name => 'TSR_INFORMATION2'

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

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

Line 1174: ota_suppliable_resources tsr

1170: --
1171: cursor csr_leg_code is
1172: select legislation_code
1173: from per_business_groups_perf pbg,
1174: ota_suppliable_resources tsr
1175: where pbg.business_group_id = tsr.business_group_id
1176: and tsr.supplied_resource_id = p_supplied_resource_id;
1177:
1178: