APPS.OTA_CPE_BUS dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 31: , ota_cert_prd_enrollments cpe

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_cert_prd_enrollments cpe
32: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
33: and pbg.business_group_id = cpe.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_cert_prd_enrollments cpe

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_cert_prd_enrollments cpe
102: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
103: and pbg.business_group_id = cpe.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'OTA_CERT_PRD_ENROLLMENTS'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'OTA'
249: ,p_descflex_name => 'OTA_CERT_PRD_ENROLLMENTS'
250: ,p_attribute_category => p_rec.attribute_category
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 358: ,p_period_status_code IN ota_cert_prd_enrollments.period_status_code%TYPE

354: -- ----------------------------------------------------------------------------
355: --
356: PROCEDURE chk_period_status_code
357: (p_effective_date IN date
358: ,p_period_status_code IN ota_cert_prd_enrollments.period_status_code%TYPE
359: ) IS
360: --
361: l_proc varchar2(72) := g_package|| 'chk_period_status_code';
362: --

Line 391: p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.period_status_code') THEN

387: --MULTI MESSAGE SUPPORT
388: EXCEPTION
389: WHEN app_exception.application_exception THEN
390: IF hr_multi_message.exception_add(
391: p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.period_status_code') THEN
392: hr_utility.set_location(' Leaving:'||l_proc, 32);
393: RAISE;
394:
395: END IF;