APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_DEFINITIONS

Line 2357: (p_short_name in pay_retro_definitions.short_name%TYPE

2353: --------------------------------------------------------------------------
2354:
2355:
2356: FUNCTION create_retro_definitions
2357: (p_short_name in pay_retro_definitions.short_name%TYPE
2358: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2359: RETURN NUMBER
2360: IS
2361: --

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

2354:
2355:
2356: FUNCTION create_retro_definitions
2357: (p_short_name in pay_retro_definitions.short_name%TYPE
2358: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2359: RETURN NUMBER
2360: IS
2361: --
2362: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

Line 2362: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

2358: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2359: RETURN NUMBER
2360: IS
2361: --
2362: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;
2363: --
2364: CURSOR csr_defn_exists
2365: IS
2366: SELECT retro_definition_id

Line 2367: FROM pay_retro_definitions

2363: --
2364: CURSOR csr_defn_exists
2365: IS
2366: SELECT retro_definition_id
2367: FROM pay_retro_definitions
2368: WHERE short_name = p_short_name
2369: AND legislation_code = g_legislation_code;
2370: --
2371: CURSOR csr_get_defn_id

Line 2373: SELECT pay_retro_definitions_s.nextval

2369: AND legislation_code = g_legislation_code;
2370: --
2371: CURSOR csr_get_defn_id
2372: IS
2373: SELECT pay_retro_definitions_s.nextval
2374: FROM dual;
2375: --
2376: BEGIN
2377: --

Line 2388: INSERT INTO pay_retro_definitions

2384: OPEN csr_get_defn_id;
2385: FETCH csr_get_defn_id INTO l_retro_definition_id;
2386: CLOSE csr_get_defn_id;
2387: --
2388: INSERT INTO pay_retro_definitions
2389: (retro_definition_id
2390: ,short_name
2391: ,definition_name
2392: ,legislation_code)

Line 2939: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;

2935:
2936: PROCEDURE create_enhanced_retro_defn
2937: IS
2938:
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;

Line 3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');

3244: IF ( l_leg_rule = 'Y')
3245: THEN
3246: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');
3247: pay_au_retro_upgrade.create_enhanced_retro_defn;
3248: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3249: pay_au_retro_upgrade.set_enh_retro_request_group;
3250: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');
3251: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3252: