APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RETRO_DEFN_COMPONENTS

Line 2623: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE

2619: -- then the priority will be updated.
2620: -- else a new retro definition component will be created.
2621: --------------------------------------------------------------------------
2622: FUNCTION create_retro_defn_components
2623: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2624: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2625: ,p_priority in pay_retro_defn_components.priority%TYPE)
2626: RETURN NUMBER
2627: IS

Line 2624: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE

2620: -- else a new retro definition component will be created.
2621: --------------------------------------------------------------------------
2622: FUNCTION create_retro_defn_components
2623: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2624: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2625: ,p_priority in pay_retro_defn_components.priority%TYPE)
2626: RETURN NUMBER
2627: IS
2628: --

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

2621: --------------------------------------------------------------------------
2622: FUNCTION create_retro_defn_components
2623: (p_retro_definition_id pay_retro_defn_components.retro_definition_id%TYPE
2624: ,p_retro_component_id pay_retro_defn_components.retro_component_id%TYPE
2625: ,p_priority in pay_retro_defn_components.priority%TYPE)
2626: RETURN NUMBER
2627: IS
2628: --
2629: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

Line 2629: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;

2625: ,p_priority in pay_retro_defn_components.priority%TYPE)
2626: RETURN NUMBER
2627: IS
2628: --
2629: l_definition_component_id pay_retro_defn_components.definition_component_id%TYPE;
2630: --
2631: CURSOR csr_defn_comp_exists
2632: IS
2633: SELECT definition_component_id

Line 2634: FROM pay_retro_defn_components

2630: --
2631: CURSOR csr_defn_comp_exists
2632: IS
2633: SELECT definition_component_id
2634: FROM pay_retro_defn_components
2635: WHERE retro_definition_id = p_retro_definition_id
2636: AND retro_component_id = p_retro_component_id;
2637: --
2638: CURSOR csr_get_defn_comp_id IS

Line 2639: SELECT pay_retro_defn_components_s.nextval

2635: WHERE retro_definition_id = p_retro_definition_id
2636: AND retro_component_id = p_retro_component_id;
2637: --
2638: CURSOR csr_get_defn_comp_id IS
2639: SELECT pay_retro_defn_components_s.nextval
2640: from dual;
2641: --
2642: BEGIN
2643: --

Line 2654: INSERT INTO pay_retro_defn_components

2650: OPEN csr_get_defn_comp_id;
2651: FETCH csr_get_defn_comp_id INTO l_definition_component_id;
2652: CLOSE csr_get_defn_comp_id;
2653: --
2654: INSERT INTO pay_retro_defn_components
2655: (definition_component_id
2656: ,retro_definition_id
2657: ,retro_component_id
2658: ,priority)

Line 2667: UPDATE pay_retro_defn_components

2663: ,p_priority);
2664: --
2665: ELSE
2666: --
2667: UPDATE pay_retro_defn_components
2668: SET priority = p_priority
2669: WHERE definition_component_id = l_definition_component_id
2670: AND retro_definition_id = p_retro_definition_id
2671: AND retro_component_id = p_retro_component_id;

Line 2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;

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;
2854: