DBA Data[Home] [Help]

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_ABR_SHD

Line 2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);

2463:
2464:
2465:
2466: if g_debug then
2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);
2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);
2469: end if;
2470:
2471: -- Cannot Change Status

Line 2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);

2464:
2465:
2466: if g_debug then
2467: hr_utility.set_location('Old Status : '||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,115);
2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);
2469: end if;
2470:
2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And

Line 2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And

2468: hr_utility.set_location('Old Activity : '||ben_abr_shd.g_old_rec.ACTY_TYP_CD,120);
2469: end if;
2470:
2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And
2473: ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD <> p_Acty_Base_RT_Stat_Cd) Then
2474: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_STATUS');
2475: hr_utility.raise_error;
2476: end if;

Line 2473: ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD <> p_Acty_Base_RT_Stat_Cd) Then

2469: end if;
2470:
2471: -- Cannot Change Status
2472: if ( ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD='A' And
2473: ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD <> p_Acty_Base_RT_Stat_Cd) Then
2474: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_STATUS');
2475: hr_utility.raise_error;
2476: end if;
2477:

Line 2479: if ( ben_abr_shd.g_old_rec.ACTY_TYP_CD <> p_acty_typ_cd ) Then

2475: hr_utility.raise_error;
2476: end if;
2477:
2478: -- Cannot Change Activity
2479: if ( ben_abr_shd.g_old_rec.ACTY_TYP_CD <> p_acty_typ_cd ) Then
2480: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_ABR_ACTIVITY');
2481: hr_utility.raise_error;
2482: end if;
2483:

Line 2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);

2555: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2556: hr_utility.set_location('p_pl_id'||p_pl_id,35);
2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;
2563:

Line 2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);

2557: hr_utility.set_location('p_opt_id'||p_opt_id,40);
2558: hr_utility.set_location('p_acty_typ_cd'||p_acty_typ_cd,45);
2559: hr_utility.set_location('Old acty_typ_cd'||ben_abr_shd.g_old_rec.ACTY_TYP_CD,46);
2560: hr_utility.set_location('p_Acty_Base_RT_Stat_Cd'||p_Acty_Base_RT_Stat_Cd,55);
2561: hr_utility.set_location('Old Acty_Base_RT_Stat_Cd'||ben_abr_shd.g_old_rec.ACTY_BASE_RT_STAT_CD,65);
2562: end if;
2563:
2564: -- Get Activity Type
2565: Open csr_activity_type;