APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_DEFN_COMPONENTS

Line 2496: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE

2492: -- then the priority will be updated.
2493: -- else a new retro definition component will be created.
2494: --------------------------------------------------------------------------
2495: FUNCTION create_retro_defn_components
2496: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2497: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2498: ,p_priority in pay_retro_defn_components.priority%TYPE)
2499: RETURN NUMBER
2500: IS

Line 2497: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE

2493: -- else a new retro definition component will be created.
2494: --------------------------------------------------------------------------
2495: FUNCTION create_retro_defn_components
2496: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2497: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2498: ,p_priority in pay_retro_defn_components.priority%TYPE)
2499: RETURN NUMBER
2500: IS
2501: --

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

2494: --------------------------------------------------------------------------
2495: FUNCTION create_retro_defn_components
2496: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2497: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2498: ,p_priority in pay_retro_defn_components.priority%TYPE)
2499: RETURN NUMBER
2500: IS
2501: --
2502: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

Line 2502: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

2498: ,p_priority in pay_retro_defn_components.priority%TYPE)
2499: RETURN NUMBER
2500: IS
2501: --
2502: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;
2503: --
2504: CURSOR csr_defn_comp_exists
2505: IS
2506: SELECT definition_component_id

Line 2507: FROM pay_retro_defn_components

2503: --
2504: CURSOR csr_defn_comp_exists
2505: IS
2506: SELECT definition_component_id
2507: FROM pay_retro_defn_components
2508: WHERE retro_definition_id = p_retro_definition_id
2509: AND retro_component_id = p_retro_component_id;
2510: --
2511: CURSOR csr_get_defn_comp_id IS

Line 2512: SELECT pay_retro_defn_components_s.nextval

2508: WHERE retro_definition_id = p_retro_definition_id
2509: AND retro_component_id = p_retro_component_id;
2510: --
2511: CURSOR csr_get_defn_comp_id IS
2512: SELECT pay_retro_defn_components_s.nextval
2513: from dual;
2514: --
2515: BEGIN
2516: --

Line 2527: INSERT INTO pay_retro_defn_components

2523: OPEN csr_get_defn_comp_id;
2524: FETCH csr_get_defn_comp_id INTO l_definition_component_id;
2525: CLOSE csr_get_defn_comp_id;
2526: --
2527: INSERT INTO pay_retro_defn_components
2528: (definition_component_id
2529: ,retro_definition_id
2530: ,retro_component_id
2531: ,priority)

Line 2540: UPDATE pay_retro_defn_components

2536: ,p_priority);
2537: --
2538: ELSE
2539: --
2540: UPDATE pay_retro_defn_components
2541: SET priority = p_priority
2542: WHERE definition_component_id = l_definition_component_id
2543: AND retro_definition_id = p_retro_definition_id
2544: AND retro_component_id = p_retro_component_id;

Line 2943: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;

2939: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;
2940: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
2941: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2942: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2943: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2944: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2945: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2946: l_time_span_id pay_time_spans.time_span_id%TYPE;
2947: