DBA Data[Home] [Help]

APPS.OTA_TSP_BUS dependencies on OTA_SKILL_PROVISIONS

Line 101: ,p_descflex_name => 'OTA_SKILL_PROVISIONS'

97: -- b) During insert.
98: --
99: hr_dflex_utility.ins_or_upd_descflex_attribs
100: (p_appl_short_name => 'OTA'
101: ,p_descflex_name => 'OTA_SKILL_PROVISIONS'
102: ,p_attribute_category => p_rec.tsp_information_category
103: ,p_attribute1_name => 'TSP_INFORMATION1'
104: ,p_attribute1_value => p_rec.tsp_information1
105: ,p_attribute2_name => 'TSP_INFORMATION2'

Line 266: , ota_skill_provisions tsp

262: cursor csr_sec_grp is
263: select pbg.security_group_id,
264: pbg.legislation_code
265: from per_business_groups_perf pbg
266: , ota_skill_provisions tsp
267: ,ota_activity_versions tav
268: where tav.activity_version_id = tsp.activity_version_id
269: and pbg.business_group_id = tav.business_group_id
270: and tsp.skill_provision_id = p_skill_provision_id;

Line 333: -- of by the user hooks of ota_skill_provisions usiness process.

329: -- {Start Of Comments}
330: --
331: -- Description:
332: -- This function will be used by the user hooks. This will be used
333: -- of by the user hooks of ota_skill_provisions usiness process.
334: --
335: -- Pre Conditions:
336: -- This function will be called by the user hook packages.
337: --

Line 365: , ota_skill_provisions tsp

361: --
362: cursor csr_leg_code is
363: select pbg.legislation_code
364: from per_business_groups_perf pbg
365: , ota_skill_provisions tsp
366: ,ota_activity_versions tav
367: where tav.activity_version_id = tsp.activity_version_id
368: and pbg.business_group_id = tav.business_group_id
369: and tsp.skill_provision_id = p_skill_provision_id;