APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_DEFINITIONS

Line 2626: (p_short_name in pay_retro_definitions.short_name%TYPE

2622: --------------------------------------------------------------------------
2623:
2624:
2625: FUNCTION create_retro_definitions
2626: (p_short_name in pay_retro_definitions.short_name%TYPE
2627: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2628: RETURN NUMBER
2629: IS
2630: --

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

2623:
2624:
2625: FUNCTION create_retro_definitions
2626: (p_short_name in pay_retro_definitions.short_name%TYPE
2627: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2628: RETURN NUMBER
2629: IS
2630: --
2631: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

Line 2631: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;

2627: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2628: RETURN NUMBER
2629: IS
2630: --
2631: l_retro_definition_id pay_retro_definitions.retro_definition_id%TYPE;
2632: --
2633: CURSOR csr_defn_exists
2634: IS
2635: SELECT retro_definition_id

Line 2636: FROM pay_retro_definitions

2632: --
2633: CURSOR csr_defn_exists
2634: IS
2635: SELECT retro_definition_id
2636: FROM pay_retro_definitions
2637: WHERE short_name = p_short_name
2638: AND legislation_code = g_legislation_code;
2639: --
2640: CURSOR csr_get_defn_id

Line 2642: SELECT pay_retro_definitions_s.nextval

2638: AND legislation_code = g_legislation_code;
2639: --
2640: CURSOR csr_get_defn_id
2641: IS
2642: SELECT pay_retro_definitions_s.nextval
2643: FROM dual;
2644: --
2645: BEGIN
2646: --

Line 2657: INSERT INTO pay_retro_definitions

2653: OPEN csr_get_defn_id;
2654: FETCH csr_get_defn_id INTO l_retro_definition_id;
2655: CLOSE csr_get_defn_id;
2656: --
2657: INSERT INTO pay_retro_definitions
2658: (retro_definition_id
2659: ,short_name
2660: ,definition_name
2661: ,legislation_code)

Line 3269: l_retro_defn_id pay_retro_definitions.retro_definition_id%TYPE;

3265:
3266: PROCEDURE create_enhanced_retro_defn
3267: IS
3268:
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;

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

3683: IF ( l_leg_rule = 'Y')
3684: THEN
3685: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Rule Enabled ');
3686: pay_au_retro_upgrade.create_enhanced_retro_defn;
3687: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay Retro Definitions Created ');
3688: pay_au_retro_upgrade.set_enh_retro_request_group;
3689: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Request Group - programs for Enhanced Retropay added ');
3690: fnd_file.put_line(FND_FILE.LOG,' MESSAGE: Enhanced Retropay is enabled for the following Australian Business Groups :');
3691: