eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENTS

Line 2018: from pay_retro_components prc,

2014: );
2015: /* cursor is used to get retro component info for AU legislation. */
2016: cursor c_retro_info(cp_legislation_code in varchar2) is
2017: select retro_component_id, pts.time_span_id, ptd.short_name, ptd2.short_name
2018: from pay_retro_components prc,
2019: pay_time_spans pts,
2020: pay_time_definitions ptd,
2021: pay_time_definitions ptd2
2022: where pts.creator_id = prc.retro_component_id

Line 2034: pay_retro_components prc

2030: CURSOR c_get_retro_components
2031: IS
2032: select count(*)
2033: from pay_retro_component_usages prcu,
2034: pay_retro_components prc
2035: where prc.legislation_code = 'AU'
2036: and prc.retro_component_id = prcu.retro_component_id
2037: AND prcu.creator_id = p_element_type_id
2038: order by prcu.creator_id;

Line 2686: (p_short_name in pay_retro_components.short_name%TYPE

2682: -- then the details will be updated.
2683: -- else a new retro component will be created.
2684: --------------------------------------------------------------------------
2685: FUNCTION create_retro_components
2686: (p_short_name in pay_retro_components.short_name%TYPE
2687: ,p_component_name in pay_retro_components.component_name%TYPE
2688: ,p_retro_type in pay_retro_components.retro_type%TYPE
2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE

Line 2687: ,p_component_name in pay_retro_components.component_name%TYPE

2683: -- else a new retro component will be created.
2684: --------------------------------------------------------------------------
2685: FUNCTION create_retro_components
2686: (p_short_name in pay_retro_components.short_name%TYPE
2687: ,p_component_name in pay_retro_components.component_name%TYPE
2688: ,p_retro_type in pay_retro_components.retro_type%TYPE
2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2691: )

Line 2688: ,p_retro_type in pay_retro_components.retro_type%TYPE

2684: --------------------------------------------------------------------------
2685: FUNCTION create_retro_components
2686: (p_short_name in pay_retro_components.short_name%TYPE
2687: ,p_component_name in pay_retro_components.component_name%TYPE
2688: ,p_retro_type in pay_retro_components.retro_type%TYPE
2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2691: )
2692: RETURN NUMBER

Line 2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE

2685: FUNCTION create_retro_components
2686: (p_short_name in pay_retro_components.short_name%TYPE
2687: ,p_component_name in pay_retro_components.component_name%TYPE
2688: ,p_retro_type in pay_retro_components.retro_type%TYPE
2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2691: )
2692: RETURN NUMBER
2693: IS

Line 2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE

2686: (p_short_name in pay_retro_components.short_name%TYPE
2687: ,p_component_name in pay_retro_components.component_name%TYPE
2688: ,p_retro_type in pay_retro_components.retro_type%TYPE
2689: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2690: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE
2691: )
2692: RETURN NUMBER
2693: IS
2694: --

Line 2695: l_retro_component_id pay_retro_components.retro_component_id%TYPE;

2691: )
2692: RETURN NUMBER
2693: IS
2694: --
2695: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
2696: --
2697: CURSOR csr_component_exists
2698: IS
2699: SELECT retro_component_id

Line 2700: FROM pay_retro_components

2696: --
2697: CURSOR csr_component_exists
2698: IS
2699: SELECT retro_component_id
2700: FROM pay_retro_components
2701: WHERE short_name = p_short_name
2702: AND legislation_code = g_legislation_code;
2703: --
2704: CURSOR csr_get_comp_id

Line 2706: SELECT pay_retro_components_s.nextval

2702: AND legislation_code = g_legislation_code;
2703: --
2704: CURSOR csr_get_comp_id
2705: IS
2706: SELECT pay_retro_components_s.nextval
2707: FROM dual;
2708: --
2709: BEGIN
2710: --

Line 2721: INSERT INTO pay_retro_components

2717: OPEN csr_get_comp_id;
2718: FETCH csr_get_comp_id INTO l_retro_component_id;
2719: CLOSE csr_get_comp_id;
2720: --
2721: INSERT INTO pay_retro_components
2722: (retro_component_id
2723: ,short_name
2724: ,component_name
2725: ,retro_type

Line 2740: UPDATE pay_retro_components

2736: ,p_date_override_proc);
2737: --
2738: ELSE
2739: --
2740: UPDATE pay_retro_components
2741: SET component_name = p_component_name
2742: , retro_type = p_retro_type
2743: , recalculation_style = p_recalc_style
2744: , date_override_procedure = p_date_override_proc

Line 2991: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE

2987: -- then the details will not be updated.
2988: --------------------------------------------------------------------------
2989: PROCEDURE create_element_spans
2990: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2991: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2992: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2993: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2994: )
2995: IS

Line 3075: l_retro_component_id pay_retro_components.retro_component_id%TYPE;

3071: )
3072: IS
3073: --
3074: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;
3075: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
3076: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3077: --
3078: CURSOR csr_get_details IS
3079: SELECT c.retro_component_id

Line 3081: FROM pay_retro_components c

3077: --
3078: CURSOR csr_get_details IS
3079: SELECT c.retro_component_id
3080: , e.element_type_id
3081: FROM pay_retro_components c
3082: , pay_element_types_f e
3083: WHERE c.component_name = p_component_name
3084: AND e.element_name = p_creator_name
3085: AND e.legislation_code = g_legislation_code

Line 3270: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;

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;
3274: l_start_time_id pay_time_definitions.time_definition_id%TYPE;

Line 3271: l_back_up_comp pay_retro_components.retro_component_id%TYPE;

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;
3274: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
3275: l_end_time_id pay_time_definitions.time_definition_id%TYPE;

Line 3272: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;

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;
3274: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
3275: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
3276: l_time_span_id pay_time_spans.time_span_id%TYPE;