APPS.BEN_LDC_BUS dependencies on BEN_PGM_F

Line 667: -- This procedure is used to check that the dpnt_dsgn_cd on ben_pgm_f has a

663: -- |------< chk_dpnt_dsgn_cd >------|
664: -- ----------------------------------------------------------------------------
665: --
666: -- Description
667: -- This procedure is used to check that the dpnt_dsgn_cd on ben_pgm_f has a
668: -- value of 'O' 'R'. If not, signal error, and disallow the insert/update.
669: --
670: -- Pre Conditions
671: -- None.

Line 698: -- ben_pgm_f.dpnt_dsgn_cd must = 'R' or 'O' in order to insert/update.

694: l_proc varchar2(72) := g_package||'chk_dpnt_dsgn_cd';
695: l_api_updating boolean;
696: l_exists varchar2(1);
697: --
698: -- ben_pgm_f.dpnt_dsgn_cd must = 'R' or 'O' in order to insert/update.
699: --
700: cursor chk_dpnt_dsgn is
701: select null
702: from ben_pgm_f

Line 702: from ben_pgm_f

698: -- ben_pgm_f.dpnt_dsgn_cd must = 'R' or 'O' in order to insert/update.
699: --
700: cursor chk_dpnt_dsgn is
701: select null
702: from ben_pgm_f
703: where pgm_id = p_pgm_id
704: and dpnt_dsgn_cd in ('R','O')
705: and business_group_id + 0 = p_business_group_id
706: and p_effective_date

Line 1200: (p_base_table_name => 'ben_pgm_f',

1196: Raise l_integrity_error;
1197: End If;
1198: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1199: NOT (dt_api.check_min_max_dates
1200: (p_base_table_name => 'ben_pgm_f',
1201: p_base_key_column => 'pgm_id',
1202: p_base_key_value => p_pgm_id,
1203: p_from_date => p_validation_start_date,
1204: p_to_date => p_validation_end_date))) Then

Line 1205: l_table_name := 'ben_pgm_f';

1201: p_base_key_column => 'pgm_id',
1202: p_base_key_value => p_pgm_id,
1203: p_from_date => p_validation_start_date,
1204: p_to_date => p_validation_end_date))) Then
1205: l_table_name := 'ben_pgm_f';
1206: Raise l_integrity_error;
1207: End If;
1208: --
1209: End If;