DBA Data[Home] [Help]

APPS.PAY_LINK_INPUT_VALUES_API dependencies on PAY_LINK_INPUT_VALUES_F

Line 38: l_default_value pay_link_input_values_f.default_value%type;

34: l_effective_end_date date;
35: l_exists varchar2(1);
36: l_rec pay_input_values_f%rowtype;
37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;

Line 39: l_max_value pay_link_input_values_f.max_value%type;

35: l_exists varchar2(1);
36: l_rec pay_input_values_f%rowtype;
37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;

Line 40: l_min_value pay_link_input_values_f.min_value%type;

36: l_rec pay_input_values_f%rowtype;
37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;
44: l_object_version_number pay_link_input_values_f.object_version_number%type;

Line 41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;

37: l_costable_type pay_element_links_f.costable_type%type;
38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;
44: l_object_version_number pay_link_input_values_f.object_version_number%type;
45:

Line 42: l_costed_flag pay_link_input_values_f.costed_flag%type;

38: l_default_value pay_link_input_values_f.default_value%type;
39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;
44: l_object_version_number pay_link_input_values_f.object_version_number%type;
45:
46:

Line 43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;

39: l_max_value pay_link_input_values_f.max_value%type;
40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;
44: l_object_version_number pay_link_input_values_f.object_version_number%type;
45:
46:
47: Cursor C_input_values

Line 44: l_object_version_number pay_link_input_values_f.object_version_number%type;

40: l_min_value pay_link_input_values_f.min_value%type;
41: l_warning_or_error pay_link_input_values_f.warning_or_error%type;
42: l_costed_flag pay_link_input_values_f.costed_flag%type;
43: l_link_input_value_id pay_link_input_values_f.link_input_value_id%type;
44: l_object_version_number pay_link_input_values_f.object_version_number%type;
45:
46:
47: Cursor C_input_values
48: is

Line 190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;

186: l_default_range_warning boolean;
187: l_default_formula_warning boolean;
188: l_assignment_id_warning boolean;
189: l_formula_message fnd_new_messages.message_text%type;
190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;
191: l_element_link_id pay_link_input_values_f.element_link_id%type;
192: l_input_value_id pay_link_input_values_f.input_value_id%type;
193: l_object_version_number pay_link_input_values_f.object_version_number%type;
194: l_lookup_type hr_lookups.lookup_type%type;

Line 191: l_element_link_id pay_link_input_values_f.element_link_id%type;

187: l_default_formula_warning boolean;
188: l_assignment_id_warning boolean;
189: l_formula_message fnd_new_messages.message_text%type;
190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;
191: l_element_link_id pay_link_input_values_f.element_link_id%type;
192: l_input_value_id pay_link_input_values_f.input_value_id%type;
193: l_object_version_number pay_link_input_values_f.object_version_number%type;
194: l_lookup_type hr_lookups.lookup_type%type;
195:

Line 192: l_input_value_id pay_link_input_values_f.input_value_id%type;

188: l_assignment_id_warning boolean;
189: l_formula_message fnd_new_messages.message_text%type;
190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;
191: l_element_link_id pay_link_input_values_f.element_link_id%type;
192: l_input_value_id pay_link_input_values_f.input_value_id%type;
193: l_object_version_number pay_link_input_values_f.object_version_number%type;
194: l_lookup_type hr_lookups.lookup_type%type;
195:
196: Cursor c_link_input_value_id

Line 193: l_object_version_number pay_link_input_values_f.object_version_number%type;

189: l_formula_message fnd_new_messages.message_text%type;
190: l_default_value pay_link_input_values_f.default_value%type := p_default_value;
191: l_element_link_id pay_link_input_values_f.element_link_id%type;
192: l_input_value_id pay_link_input_values_f.input_value_id%type;
193: l_object_version_number pay_link_input_values_f.object_version_number%type;
194: l_lookup_type hr_lookups.lookup_type%type;
195:
196: Cursor c_link_input_value_id
197: is

Line 199: from pay_link_input_values_f

195:
196: Cursor c_link_input_value_id
197: is
198: select element_link_id, input_value_id
199: from pay_link_input_values_f
200: where link_input_value_id = p_link_input_value_id
201: and p_effective_date between effective_start_date
202: and effective_end_date;
203:

Line 452: l_object_version_number pay_link_input_values_f.object_version_number%type;

448: l_proc varchar2(72) := g_package||'delete_liv';
449: l_effective_date date;
450: l_effective_end_date date;
451: l_effective_start_date date;
452: l_object_version_number pay_link_input_values_f.object_version_number%type;
453:
454: begin
455: hr_utility.set_location('Entering:'|| l_proc, 10);
456: --