APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_DEFN_COMPONENTS

Line 2765: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE

2761: -- then the priority will be updated.
2762: -- else a new retro definition component will be created.
2763: --------------------------------------------------------------------------
2764: FUNCTION create_retro_defn_components
2765: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2766: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2767: ,p_priority in pay_retro_defn_components.priority%TYPE)
2768: RETURN NUMBER
2769: IS

Line 2766: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE

2762: -- else a new retro definition component will be created.
2763: --------------------------------------------------------------------------
2764: FUNCTION create_retro_defn_components
2765: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2766: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2767: ,p_priority in pay_retro_defn_components.priority%TYPE)
2768: RETURN NUMBER
2769: IS
2770: --

Line 2767: ,p_priority in pay_retro_defn_components.priority%TYPE)

2763: --------------------------------------------------------------------------
2764: FUNCTION create_retro_defn_components
2765: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2766: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2767: ,p_priority in pay_retro_defn_components.priority%TYPE)
2768: RETURN NUMBER
2769: IS
2770: --
2771: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

Line 2771: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

2767: ,p_priority in pay_retro_defn_components.priority%TYPE)
2768: RETURN NUMBER
2769: IS
2770: --
2771: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;
2772: --
2773: CURSOR csr_defn_comp_exists
2774: IS
2775: SELECT definition_component_id

Line 2776: FROM pay_retro_defn_components

2772: --
2773: CURSOR csr_defn_comp_exists
2774: IS
2775: SELECT definition_component_id
2776: FROM pay_retro_defn_components
2777: WHERE retro_definition_id = p_retro_definition_id
2778: AND retro_component_id = p_retro_component_id;
2779: --
2780: CURSOR csr_get_defn_comp_id IS

Line 2781: SELECT pay_retro_defn_components_s.nextval

2777: WHERE retro_definition_id = p_retro_definition_id
2778: AND retro_component_id = p_retro_component_id;
2779: --
2780: CURSOR csr_get_defn_comp_id IS
2781: SELECT pay_retro_defn_components_s.nextval
2782: from dual;
2783: --
2784: BEGIN
2785: --

Line 2796: INSERT INTO pay_retro_defn_components

2792: OPEN csr_get_defn_comp_id;
2793: FETCH csr_get_defn_comp_id INTO l_definition_component_id;
2794: CLOSE csr_get_defn_comp_id;
2795: --
2796: INSERT INTO pay_retro_defn_components
2797: (definition_component_id
2798: ,retro_definition_id
2799: ,retro_component_id
2800: ,priority)

Line 2809: UPDATE pay_retro_defn_components

2805: ,p_priority);
2806: --
2807: ELSE
2808: --
2809: UPDATE pay_retro_defn_components
2810: SET priority = p_priority
2811: WHERE definition_component_id = l_definition_component_id
2812: AND retro_definition_id = p_retro_definition_id
2813: AND retro_component_id = p_retro_component_id;

Line 3273: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;

3269: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;
3270: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
3271: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
3272: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
3273: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
3274: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
3275: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
3276: l_time_span_id pay_time_spans.time_span_id%TYPE;
3277: