APPS.PER_ZA_UTILITY_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE

576: -------------------------------------------------------------------------------
577: -- insert_ee_value
578: -------------------------------------------------------------------------------
579: PROCEDURE insert_ee_value (
580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE

Line 581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE

577: -- insert_ee_value
578: -------------------------------------------------------------------------------
579: PROCEDURE insert_ee_value (
580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE
585: )

Line 582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE

578: -------------------------------------------------------------------------------
579: PROCEDURE insert_ee_value (
580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE
585: )
586: AS

Line 583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE

579: PROCEDURE insert_ee_value (
580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE
585: )
586: AS
587: ------------

Line 584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE

580: p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
581: , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
582: , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
583: , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
584: , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE
585: )
586: AS
587: ------------
588: -- Variables

Line 590: l_entry_value_pk pay_element_entry_values_f.element_entry_value_id%TYPE;

586: AS
587: ------------
588: -- Variables
589: ------------
590: l_entry_value_pk pay_element_entry_values_f.element_entry_value_id%TYPE;
591:
592: -------------------------------------------------------------------------------
593: BEGIN -- MAIN --
594: -------------------------------------------------------------------------------

Line 603: INTO pay_element_entry_values_f

599: FROM dual;
600: hr_utility.set_location('per_za_utility_pkg.insert_ee_value',2);
601: -- Insert a new row using the sequence value
602: INSERT
603: INTO pay_element_entry_values_f
604: ( element_entry_value_id
605: , effective_start_date
606: , effective_end_date
607: , input_value_id