APPS.PER_ZA_UTILITY_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 501: -- This procedure handles the insert of values into pay_link_input_values_f

497: end get_table_value;
498:
499: -------------------------------------------------------------------------------
500: -- insert_ipv_link
501: -- This procedure handles the insert of values into pay_link_input_values_f
502: -------------------------------------------------------------------------------
503: PROCEDURE insert_ipv_link (
504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE

Line 504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE

500: -- insert_ipv_link
501: -- This procedure handles the insert of values into pay_link_input_values_f
502: -------------------------------------------------------------------------------
503: PROCEDURE insert_ipv_link (
504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE

Line 505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE

501: -- This procedure handles the insert of values into pay_link_input_values_f
502: -------------------------------------------------------------------------------
503: PROCEDURE insert_ipv_link (
504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE

Line 506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE

502: -------------------------------------------------------------------------------
503: PROCEDURE insert_ipv_link (
504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE

Line 507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE

503: PROCEDURE insert_ipv_link (
504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE

Line 508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE

504: p_effective_start_date IN pay_link_input_values_f.effective_start_date%TYPE
505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE
512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE

Line 509: , p_default_value IN pay_link_input_values_f.default_value%TYPE

505: , p_effective_end_date IN pay_link_input_values_f.effective_end_date%TYPE
506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE
512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE
513: )

Line 510: , p_max_value IN pay_link_input_values_f.max_value%TYPE

506: , p_element_link_id IN pay_link_input_values_f.element_link_id%TYPE
507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE
512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE
513: )
514: AS

Line 511: , p_min_value IN pay_link_input_values_f.min_value%TYPE

507: , p_input_value_id IN pay_link_input_values_f.input_value_id%TYPE
508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE
512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE
513: )
514: AS
515: ------------

Line 512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE

508: , p_costed_flag IN pay_link_input_values_f.costed_flag%TYPE
509: , p_default_value IN pay_link_input_values_f.default_value%TYPE
510: , p_max_value IN pay_link_input_values_f.max_value%TYPE
511: , p_min_value IN pay_link_input_values_f.min_value%TYPE
512: , p_warning_or_error IN pay_link_input_values_f.warning_or_error%TYPE
513: )
514: AS
515: ------------
516: -- Variables

Line 518: l_link_input_pk pay_link_input_values_f.link_input_value_id%TYPE;

514: AS
515: ------------
516: -- Variables
517: ------------
518: l_link_input_pk pay_link_input_values_f.link_input_value_id%TYPE;
519:
520: -------------------------------------------------------------------------------
521: BEGIN -- MAIN --
522: -------------------------------------------------------------------------------

Line 530: INTO pay_link_input_values_f

526: INTO l_link_input_pk
527: FROM dual;
528: hr_utility.set_location('per_za_utility_pkg.insert_ipv_link',2);
529: INSERT
530: INTO pay_link_input_values_f
531: ( link_input_value_id
532: , effective_start_date
533: , effective_end_date
534: , element_link_id

Line 770: pay_link_input_values_f pli

766: and not exists
767: ( select
768: null
769: from
770: pay_link_input_values_f pli
771: where
772: pli.element_link_id = pel.element_link_id
773: and pli.input_value_id = piv.input_value_id
774: and pli.effective_start_date >=