DBA Data[Home] [Help]

APPS.BEN_AGF_SHD dependencies on BEN_UTILITY

Line 47: ben_utility.child_exists_error(p_table_name => 'BEN_AGE_RT_F');

43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'BEN_AGE_RT_F_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_AGE_RT_F');
48: ElsIf (p_constraint_name = 'BEN_CMBN_AGE_LOS_FCTR_FK1') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LOS_FCTR');
50: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_CVG_F_FK3') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');

Line 49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LOS_FCTR');

45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'BEN_AGE_RT_F_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_AGE_RT_F');
48: ElsIf (p_constraint_name = 'BEN_CMBN_AGE_LOS_FCTR_FK1') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LOS_FCTR');
50: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_CVG_F_FK3') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');
52: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_PRTE_F_FK2') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_PRTE_F');

Line 51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');

47: ben_utility.child_exists_error(p_table_name => 'BEN_AGE_RT_F');
48: ElsIf (p_constraint_name = 'BEN_CMBN_AGE_LOS_FCTR_FK1') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LOS_FCTR');
50: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_CVG_F_FK3') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');
52: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_PRTE_F_FK2') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_PRTE_F');
54: ElsIf (p_constraint_name = 'BEN_VSTG_AGE_RQMT_FK1') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_AGE_RQMT_FK1');

Line 53: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_PRTE_F');

49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LOS_FCTR');
50: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_CVG_F_FK3') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');
52: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_PRTE_F_FK2') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_PRTE_F');
54: ElsIf (p_constraint_name = 'BEN_VSTG_AGE_RQMT_FK1') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_AGE_RQMT_FK1');
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 55: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_AGE_RQMT_FK1');

51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_CVG_F');
52: ElsIf (p_constraint_name = 'BEN_ELIG_AGE_PRTE_F_FK2') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_AGE_PRTE_F');
54: ElsIf (p_constraint_name = 'BEN_VSTG_AGE_RQMT_FK1') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_AGE_RQMT_FK1');
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);