[Home] [Help]
300: );
301: --
302: If ((nvl(p_input_value_id, hr_api.g_number) <> hr_api.g_number) and
303: NOT (dt_api.check_min_max_dates
304: (p_base_table_name => 'pay_input_values_f'
305: ,p_base_key_column => 'INPUT_VALUE_ID'
306: ,p_base_key_value => p_input_value_id
307: ,p_from_date => p_validation_start_date
308: ,p_to_date => p_validation_end_date))) Then
489: --
490: l_proc varchar2(72) := g_package||'chk_min_and_max_values';
491: l_exists varchar2(1);
492: l_min_max_failure varchar2(1);
493: l_formula_id pay_input_values_f.formula_id%type;
494: l_value varchar2(255);
495: --
496: Cursor C_formula_id
497: is
495: --
496: Cursor C_formula_id
497: is
498: select formula_id
499: from pay_input_values_f
500: where input_value_id = p_input_value_id
501: and p_effective_date between effective_start_date
502: and effective_end_date;
503: --
515: l_min_max_failure varchar2(1);
516: l_checkformat_error boolean;
517: l_input_currency_code pay_element_types_f.input_currency_code%type;
518: l_message_text hr_lookups.meaning%type;
519: l_uom pay_input_values_f.uom%type;
520: --
521: Cursor C_currency_uom
522: is
523: select pet.input_currency_code, piv.uom
521: Cursor C_currency_uom
522: is
523: select pet.input_currency_code, piv.uom
524: from pay_element_types_f pet,
525: pay_input_values_f piv
526: where pet.element_type_id = piv.element_type_id
527: and piv.input_value_id = p_input_value_id
528: and p_effective_date between pet.effective_start_date
529: and pet.effective_end_date
693: ) is
694: --
695: l_proc varchar2(72) := g_package||'chk_costed_flag';
696: l_costable_type pay_element_links_f.costable_type%type;
697: l_uom pay_input_values_f.uom%type;
698: l_name pay_input_values_f.name%type;
699:
700: Cursor C_element_link
701: is
694: --
695: l_proc varchar2(72) := g_package||'chk_costed_flag';
696: l_costable_type pay_element_links_f.costable_type%type;
697: l_uom pay_input_values_f.uom%type;
698: l_name pay_input_values_f.name%type;
699:
700: Cursor C_element_link
701: is
702: select costable_type
707:
708: Cursor C_input_values
709: is
710: select name, uom
711: from pay_input_values_f
712: where input_value_id = p_input_value_id
713: and p_effective_date between effective_start_date
714: and effective_end_date;
715: --
764: ) is
765: --
766: l_proc varchar2(72) := g_package||'chk_benefit_plan';
767: l_contributions_used pay_element_links_v.contributions_used%type;
768: l_name pay_input_values_f.name%type;
769:
770: Cursor C_contributions_used
771: is
772: select contributions_used
777:
778: Cursor C_name
779: is
780: select name
781: from pay_input_values_f
782: where input_value_id = p_input_value_id
783: and p_effective_date between effective_start_date
784: and effective_end_date;
785: --
822: ) is
823: --
824: l_proc varchar2(72) := g_package||'chk_default_value';
825: l_exists varchar2(1);
826: l_hot_default_flag pay_input_values_f.hot_default_flag%type;
827: l_element_type_id pay_input_values_f.element_type_id%type;
828:
829: Cursor c_hot_default_flag
830: is
823: --
824: l_proc varchar2(72) := g_package||'chk_default_value';
825: l_exists varchar2(1);
826: l_hot_default_flag pay_input_values_f.hot_default_flag%type;
827: l_element_type_id pay_input_values_f.element_type_id%type;
828:
829: Cursor c_hot_default_flag
830: is
831: select hot_default_flag, element_type_id
828:
829: Cursor c_hot_default_flag
830: is
831: select hot_default_flag, element_type_id
832: from pay_input_values_f
833: where input_value_id = p_input_value_id
834: and p_effective_date between effective_start_date
835: and effective_end_date;
836:
944: --
945: Cursor c_formula
946: is
947: select formula_id
948: from pay_input_values_f
949: where input_value_id = p_rec.input_value_id
950: and p_effective_date between effective_start_date
951: and effective_end_date;
952: --