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_TIME_DEFINITIONS

Line 2020: pay_time_definitions ptd,

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
2023: and prc.legislation_code = 'AU'
2024: and ptd.legislation_code = 'AU'

Line 2021: pay_time_definitions ptd2

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
2023: and prc.legislation_code = 'AU'
2024: and ptd.legislation_code = 'AU'
2025: and ptd.time_definition_id = pts.start_time_def_id

Line 2834: (p_short_name pay_time_definitions.short_name%TYPE

2830: -- then the other fields will be updated.
2831: -- else a new time definition will be created.
2832: --------------------------------------------------------------------------
2833: FUNCTION create_time_definitions
2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

Line 2835: ,p_definition_name pay_time_definitions.definition_name%TYPE

2831: -- else a new time definition will be created.
2832: --------------------------------------------------------------------------
2833: FUNCTION create_time_definitions
2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

Line 2836: ,p_period_type pay_time_definitions.period_type%TYPE

2832: --------------------------------------------------------------------------
2833: FUNCTION create_time_definitions
2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2840: RETURN NUMBER

Line 2837: ,p_period_unit pay_time_definitions.period_unit%TYPE

2833: FUNCTION create_time_definitions
2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2840: RETURN NUMBER
2841: IS

Line 2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2840: RETURN NUMBER
2841: IS
2842: --

Line 2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2840: RETURN NUMBER
2841: IS
2842: --
2843: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

Line 2843: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

2839: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2840: RETURN NUMBER
2841: IS
2842: --
2843: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;
2844: --
2845: CURSOR csr_time_definition_exists
2846: IS
2847: SELECT time_definition_id

Line 2848: FROM pay_time_definitions

2844: --
2845: CURSOR csr_time_definition_exists
2846: IS
2847: SELECT time_definition_id
2848: FROM pay_time_definitions
2849: WHERE short_name = p_short_name
2850: AND period_type = p_period_type
2851: AND legislation_code = g_legislation_code;
2852: --

Line 2855: SELECT pay_time_definitions_s.nextval

2851: AND legislation_code = g_legislation_code;
2852: --
2853: CURSOR csr_get_time_definition
2854: IS
2855: SELECT pay_time_definitions_s.nextval
2856: from dual;
2857: --
2858: BEGIN
2859: --

Line 2870: INSERT INTO pay_time_definitions

2866: OPEN csr_get_time_definition;
2867: FETCH csr_get_time_definition INTO l_time_definition_id;
2868: CLOSE csr_get_time_definition;
2869: --
2870: INSERT INTO pay_time_definitions
2871: (time_definition_id
2872: ,short_name
2873: ,definition_name
2874: ,period_type

Line 2893: UPDATE pay_time_definitions

2889: ,g_legislation_code);
2890: --
2891: ELSE
2892: --
2893: UPDATE pay_time_definitions
2894: SET definition_name = p_definition_name
2895: , period_unit = p_period_unit
2896: , day_adjustment = p_day_adjustment
2897: , dynamic_code = p_dynamic_code

Line 3168: (p_short_name pay_time_definitions.short_name%TYPE

3164: -- Private Function to get time definitions
3165: -- Bug#5556042
3166: --------------------------------------------------------------------------
3167: FUNCTION get_time_definitions
3168: (p_short_name pay_time_definitions.short_name%TYPE
3169: )
3170: RETURN NUMBER
3171: IS
3172: --

Line 3173: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

3169: )
3170: RETURN NUMBER
3171: IS
3172: --
3173: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;
3174: --
3175: CURSOR csr_get_time_definition
3176: IS
3177: SELECT time_definition_id

Line 3178: FROM pay_time_definitions

3174: --
3175: CURSOR csr_get_time_definition
3176: IS
3177: SELECT time_definition_id
3178: FROM pay_time_definitions
3179: WHERE short_name = p_short_name
3180: AND legislation_code = 'AU';
3181: --
3182: --

Line 3274: l_start_time_id pay_time_definitions.time_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;
3277:
3278: /* bug 10388533 - check if Statutory PPL Payment element has retro event group */

Line 3275: l_end_time_id pay_time_definitions.time_definition_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;
3277:
3278: /* bug 10388533 - check if Statutory PPL Payment element has retro event group */
3279: