APPS.BEN_CCT_BUS dependencies on BEN_CM_TYP_F

Line 59: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');

55: <> ben_cct_shd.g_old_rec.cm_typ_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');

65: if p_cm_typ_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_cct_shd.constraint_error('BEN_CM_TYP_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 112: from ben_cm_typ_f

108: l_proc varchar2(72) := g_package||'chk_name_unique';
109: l_dummy char(1);
110: cursor c1 is
111: select null
112: from ben_cm_typ_f
113: where name = p_name
114: and cm_typ_id <> nvl(p_cm_typ_id,-1)
115: and business_group_id = p_business_group_id;
116: --

Line 920: (p_base_table_name => 'ben_cm_typ_f',

916: --
917: hr_utility.set_location('*******b4 check min/max dates', 5);
918: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
919: NOT (dt_api.check_min_max_dates
920: (p_base_table_name => 'ben_cm_typ_f',
921: p_base_key_column => 'cm_typ_id',
922: p_base_key_value => p_cm_typ_id,
923: p_from_date => p_validation_start_date,
924: p_to_date => p_validation_end_date))) Then

Line 925: l_table_name := 'ben_cm_typ_f';

921: p_base_key_column => 'cm_typ_id',
922: p_base_key_value => p_cm_typ_id,
923: p_from_date => p_validation_start_date,
924: p_to_date => p_validation_end_date))) Then
925: l_table_name := 'ben_cm_typ_f';
926: Raise l_integrity_error;
927: End If;
928: hr_utility.set_location('*******after check min/max dates', 5);
929: --

Line 1032: (p_base_table_name => 'ben_cm_typ_f',

1028: p_argument_value => p_cm_typ_id);
1029: --
1030: hr_utility.set_location('*******b4 check rows exist', 5);
1031: If (dt_api.rows_exist
1032: (p_base_table_name => 'ben_cm_typ_f',
1033: p_base_key_column => 'parnt_cm_typ_id',
1034: p_base_key_value => p_cm_typ_id,
1035: p_from_date => p_validation_start_date,
1036: p_to_date => p_validation_end_date)) Then

Line 1037: l_table_name := 'ben_cm_typ_f';

1033: p_base_key_column => 'parnt_cm_typ_id',
1034: p_base_key_value => p_cm_typ_id,
1035: p_from_date => p_validation_start_date,
1036: p_to_date => p_validation_end_date)) Then
1037: l_table_name := 'ben_cm_typ_f';
1038: Raise l_rows_exist;
1039: End If;
1040: hr_utility.set_location('*******after check rows exist', 5);
1041: If (dt_api.rows_exist

Line 1332: ben_cm_typ_f b

1328: --
1329: cursor csr_leg_code is
1330: select a.legislation_code
1331: from per_business_groups a,
1332: ben_cm_typ_f b
1333: where b.cm_typ_id = p_cm_typ_id
1334: and a.business_group_id = b.business_group_id;
1335: --
1336: -- Declare local variables