APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RETRO_COMPONENTS

Line 2544: ,p_short_name in pay_retro_components.short_name%TYPE

2540: -- else a new retro component will be created.
2541: --------------------------------------------------------------------------
2542: FUNCTION create_retro_components
2543: (p_legislation_code VARCHAR2
2544: ,p_short_name in pay_retro_components.short_name%TYPE
2545: ,p_component_name in pay_retro_components.component_name%TYPE
2546: ,p_retro_type in pay_retro_components.retro_type%TYPE
2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE

Line 2545: ,p_component_name in pay_retro_components.component_name%TYPE

2541: --------------------------------------------------------------------------
2542: FUNCTION create_retro_components
2543: (p_legislation_code VARCHAR2
2544: ,p_short_name in pay_retro_components.short_name%TYPE
2545: ,p_component_name in pay_retro_components.component_name%TYPE
2546: ,p_retro_type in pay_retro_components.retro_type%TYPE
2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2549: )

Line 2546: ,p_retro_type in pay_retro_components.retro_type%TYPE

2542: FUNCTION create_retro_components
2543: (p_legislation_code VARCHAR2
2544: ,p_short_name in pay_retro_components.short_name%TYPE
2545: ,p_component_name in pay_retro_components.component_name%TYPE
2546: ,p_retro_type in pay_retro_components.retro_type%TYPE
2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2549: )
2550: RETURN NUMBER

Line 2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE

2543: (p_legislation_code VARCHAR2
2544: ,p_short_name in pay_retro_components.short_name%TYPE
2545: ,p_component_name in pay_retro_components.component_name%TYPE
2546: ,p_retro_type in pay_retro_components.retro_type%TYPE
2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2549: )
2550: RETURN NUMBER
2551: IS

Line 2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE

2544: ,p_short_name in pay_retro_components.short_name%TYPE
2545: ,p_component_name in pay_retro_components.component_name%TYPE
2546: ,p_retro_type in pay_retro_components.retro_type%TYPE
2547: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2548: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2549: )
2550: RETURN NUMBER
2551: IS
2552: --

Line 2553: l_retro_component_id pay_retro_components.retro_component_id%TYPE;

2549: )
2550: RETURN NUMBER
2551: IS
2552: --
2553: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
2554: --
2555: CURSOR csr_component_exists
2556: IS
2557: SELECT retro_component_id

Line 2558: FROM pay_retro_components

2554: --
2555: CURSOR csr_component_exists
2556: IS
2557: SELECT retro_component_id
2558: FROM pay_retro_components
2559: WHERE short_name = p_short_name
2560: AND legislation_code = p_legislation_code;
2561: --
2562: CURSOR csr_get_comp_id

Line 2564: SELECT pay_retro_components_s.nextval

2560: AND legislation_code = p_legislation_code;
2561: --
2562: CURSOR csr_get_comp_id
2563: IS
2564: SELECT pay_retro_components_s.nextval
2565: FROM dual;
2566: --
2567: BEGIN
2568: --

Line 2579: INSERT INTO pay_retro_components

2575: OPEN csr_get_comp_id;
2576: FETCH csr_get_comp_id INTO l_retro_component_id;
2577: CLOSE csr_get_comp_id;
2578: --
2579: INSERT INTO pay_retro_components
2580: (retro_component_id
2581: ,short_name
2582: ,component_name
2583: ,retro_type

Line 2598: UPDATE pay_retro_components

2594: ,p_date_override_proc);
2595: --
2596: ELSE
2597: --
2598: UPDATE pay_retro_components
2599: SET component_name = p_component_name
2600: , retro_type = p_retro_type
2601: , recalculation_style = p_recalc_style
2602: , date_override_procedure = p_date_override_proc

Line 2847: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;

2843: PROCEDURE create_enh_retro_setup
2844: (p_legislation_code IN VARCHAR2) IS
2845:
2846: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;
2847: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;

Line 2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;

2844: (p_legislation_code IN VARCHAR2) IS
2845:
2846: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;
2847: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2852: l_end_time_id pay_time_definitions.time_definition_id%TYPE;

Line 2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;

2845:
2846: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;
2847: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2852: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2853: l_time_span_id pay_time_spans.time_span_id%TYPE;