DBA Data[Home] [Help]

APPS.PAY_LIV_BUS dependencies on PAY_LIV_SHD

Line 186: ,p_rec in pay_liv_shd.g_rec_type

182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure chk_non_updateable_args
185: (p_effective_date in date
186: ,p_rec in pay_liv_shd.g_rec_type
187: ) IS
188: --
189: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
190: l_error exception;

Line 199: IF NOT pay_liv_shd.api_updating

195: --
196: -- Only proceed with the validation if a row exists for the current
197: -- record in the HR Schema.
198: --
199: IF NOT pay_liv_shd.api_updating
200: (p_link_input_value_id => p_rec.link_input_value_id
201: ,p_effective_date => p_effective_date
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN

Line 211: nvl(pay_liv_shd.g_old_rec.element_link_id, hr_api.g_number)

207: fnd_message.raise_error;
208: END IF;
209: --
210: IF nvl(p_rec.element_link_id, hr_api.g_number) <>
211: nvl(pay_liv_shd.g_old_rec.element_link_id, hr_api.g_number)
212: THEN
213: l_argument := 'p_element_link_id';
214: RAISE l_error;
215: END IF;

Line 218: nvl(pay_liv_shd.g_old_rec.input_value_id, hr_api.g_number)

214: RAISE l_error;
215: END IF;
216:
217: IF nvl(p_rec.input_value_id, hr_api.g_number) <>
218: nvl(pay_liv_shd.g_old_rec.input_value_id, hr_api.g_number)
219: THEN
220: l_argument := 'p_input_value_id';
221: RAISE l_error;
222: END IF;

Line 312: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.INPUT_VALUE_ID');

308: ,p_to_date => p_validation_end_date))) Then
309: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
310: fnd_message.set_token('TABLE_NAME','input values');
311: hr_multi_message.add
312: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.INPUT_VALUE_ID');
313: End If;
314: If ((nvl(p_element_link_id, hr_api.g_number) <> hr_api.g_number) and
315: NOT (dt_api.check_min_max_dates
316: (p_base_table_name => 'pay_element_links_f'

Line 324: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.ELEMENT_LINK_ID');

320: ,p_to_date => p_validation_end_date))) Then
321: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
322: fnd_message.set_token('TABLE_NAME','element links');
323: hr_multi_message.add
324: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.ELEMENT_LINK_ID');
325: End If;
326: --
327: Exception
328: When Others Then

Line 645: If nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'W'

641: hr_utility.set_location('l_min_max_failure '||l_min_max_failure,30);
642:
643: If l_min_max_failure = 'F' Then
644: --
645: If nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'W'
646: then
647: p_default_range_warning := True;
648: Elsif nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'E'
649: then

Line 648: Elsif nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'E'

644: --
645: If nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'W'
646: then
647: p_default_range_warning := True;
648: Elsif nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'E'
649: then
650: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');
651: fnd_message.raise_error;
652: End if;

Line 854: and pay_liv_shd.g_old_rec.default_value is not null

850: Fetch c_hot_default_flag into l_hot_default_flag, l_element_type_id;
851: Close c_hot_default_flag;
852:
853: If (l_hot_default_flag = 'Y'
854: and pay_liv_shd.g_old_rec.default_value is not null
855: and p_default_value is null) Then
856: Open c_element_entry(l_element_type_id);
857: Loop
858: Fetch c_element_entry into l_exists;

Line 875: (p_rec in pay_liv_shd.g_rec_type

871: -- ----------------------------------------------------------------------------
872: -- |---------------------------< insert_validate >----------------------------|
873: -- ----------------------------------------------------------------------------
874: Procedure insert_validate
875: (p_rec in pay_liv_shd.g_rec_type
876: ,p_effective_date in date
877: ,p_datetrack_mode in varchar2
878: ,p_validation_start_date in date
879: ,p_validation_end_date in date

Line 923: (p_rec in pay_liv_shd.g_rec_type

919: -- ----------------------------------------------------------------------------
920: -- |---------------------------< update_validate >----------------------------|
921: -- ----------------------------------------------------------------------------
922: Procedure update_validate
923: (p_rec in pay_liv_shd.g_rec_type
924: ,p_effective_date in date
925: ,p_datetrack_mode in varchar2
926: ,p_validation_start_date in date
927: ,p_validation_end_date in date

Line 1042: (p_rec in pay_liv_shd.g_rec_type

1038: -- ----------------------------------------------------------------------------
1039: -- |---------------------------< delete_validate >----------------------------|
1040: -- ----------------------------------------------------------------------------
1041: Procedure delete_validate
1042: (p_rec in pay_liv_shd.g_rec_type
1043: ,p_effective_date in date
1044: ,p_datetrack_mode in varchar2
1045: ,p_validation_start_date in date
1046: ,p_validation_end_date in date