APPS.GHR_SF52_UPDATE dependencies on GHR_UTILITY

Line 1347: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' and p_imm_pa_request_rec.noa_family_code IN ('CONV_APP') THEN

1343: );
1344: --
1345: -- Start of Bug # 5195518 modified related to handling of Conversion to Appointment
1346: l_temp_appt := 'N';
1347: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' and p_imm_pa_request_rec.noa_family_code IN ('CONV_APP') THEN
1348: IF l_imm_health_benefits.health_plan IS NOT NULL THEN
1349: IF l_imm_health_benefits.health_plan <> 'ZZ' AND l_imm_health_benefits.enrollment NOT IN ('W','X','Y','Z') THEN
1350:
1351: for enr in get_current_enrollment (p_asg_id => p_imm_pa_request_rec.employee_assignment_id,

Line 1378: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN

1374: -- to maintain history
1375: -- Call Benefits processing Bug 4582970
1376: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP','SEPARATION') THEN
1377: -- l_temp_appt := 'N';
1378: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN
1379: -- Will be uncommented later
1380: IF p_imm_pa_request_rec.noa_family_code in ('SEPARATION') THEN
1381: --Added this code to validate whether HB is already enrolled before processing separation life event
1382: -- Get Program ID

Line 1445: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE

1441: );
1442: END IF;
1443: END IF;
1444: END IF;
1445: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1446:
1447: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1448: IF l_imm_thrift_saving_plan.amount > 0 THEN
1449: l_amount_or_rate := 'Amount';

Line 1447: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN

1443: END IF;
1444: END IF;
1445: END IF; -- IF ghr_utility.is_ghr_ben_fehb = 'TRUE
1446:
1447: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
1448: IF l_imm_thrift_saving_plan.amount > 0 THEN
1449: l_amount_or_rate := 'Amount';
1450: l_opt_val := l_imm_thrift_saving_plan.amount;
1451: ELSIF l_imm_thrift_saving_plan.rate > 0 THEN

Line 1471: END IF; -- IF ghr_utility.is_ghr_ben_tsp = 'TRUE' T

1467: p_opt_name => l_amount_or_rate,
1468: p_opt_val => l_opt_val
1469: );
1470: END IF;
1471: END IF; -- IF ghr_utility.is_ghr_ben_tsp = 'TRUE' T
1472:
1473: --Bug # 4122470 FEGLI
1474:
1475: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP') THEN

Line 1477: IF ghr_utility.is_ghr_ben_fegli = 'TRUE' THEN

1473: --Bug # 4122470 FEGLI
1474:
1475: IF p_imm_pa_request_rec.noa_family_code in ('APP','CONV_APP') THEN
1476: IF l_session.noa_id_correct is null THEN
1477: IF ghr_utility.is_ghr_ben_fegli = 'TRUE' THEN
1478: IF p_imm_pa_request_rec.fegli <> 'A0' THEN
1479: ghr_benefits_eit.ghr_benefits_fegli
1480: (errbuf => l_errbuf,
1481: retcode => l_retcode,

Line 1490: END IF; -- IF ghr_utility.is_ghr_ben_FEGLI = 'TRUE'

1486: p_opt_code => p_imm_pa_request_rec.fegli,
1487: p_assignment_id => p_imm_pa_request_rec.employee_assignment_id
1488: );
1489: END IF;
1490: END IF; -- IF ghr_utility.is_ghr_ben_FEGLI = 'TRUE'
1491: END IF;
1492: END IF;
1493:
1494: END IF; -- IF p_imm_pa_request_rec.noa_family_code = 'APP'