APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RETRO_DEFINITIONS

Line 2483: ,p_short_name in pay_retro_definitions.short_name%TYPE

2479: -- then it will not be inserted or updated.
2480: --------------------------------------------------------------------------
2481: FUNCTION create_retro_definitions
2482: (p_legislation_code in varchar2
2483: ,p_short_name in pay_retro_definitions.short_name%TYPE
2484: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2485: RETURN NUMBER
2486: IS
2487: --

Line 2484: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)

2480: --------------------------------------------------------------------------
2481: FUNCTION create_retro_definitions
2482: (p_legislation_code in varchar2
2483: ,p_short_name in pay_retro_definitions.short_name%TYPE
2484: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2485: RETURN NUMBER
2486: IS
2487: --
2488: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

Line 2488: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

2484: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2485: RETURN NUMBER
2486: IS
2487: --
2488: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;
2489: --
2490: CURSOR csr_defn_exists
2491: IS
2492: SELECT retro_definition_id

Line 2493: FROM pay_retro_definitions

2489: --
2490: CURSOR csr_defn_exists
2491: IS
2492: SELECT retro_definition_id
2493: FROM pay_retro_definitions
2494: WHERE short_name = p_short_name
2495: AND legislation_code = p_legislation_code;
2496: --
2497: CURSOR csr_get_defn_id

Line 2499: SELECT pay_retro_definitions_s.nextval

2495: AND legislation_code = p_legislation_code;
2496: --
2497: CURSOR csr_get_defn_id
2498: IS
2499: SELECT pay_retro_definitions_s.nextval
2500: FROM dual;
2501: --
2502: BEGIN
2503: --

Line 2514: INSERT INTO pay_retro_definitions

2510: OPEN csr_get_defn_id;
2511: FETCH csr_get_defn_id INTO l_retro_definition_id;
2512: CLOSE csr_get_defn_id;
2513: --
2514: INSERT INTO pay_retro_definitions
2515: (retro_definition_id
2516: ,short_name
2517: ,definition_name
2518: ,legislation_code)

Line 2846: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;

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