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 1817: pay_time_definitions ptd,

1813: cursor c_retro_info(cp_legislation_code in varchar2) is
1814: select retro_component_id, pts.time_span_id, ptd.short_name, ptd2.short_name
1815: from pay_retro_components prc,
1816: pay_time_spans pts,
1817: pay_time_definitions ptd,
1818: pay_time_definitions ptd2
1819: where pts.creator_id = prc.retro_component_id
1820: and prc.legislation_code = 'AU'
1821: and ptd.legislation_code = 'AU'

Line 1818: pay_time_definitions ptd2

1814: select retro_component_id, pts.time_span_id, ptd.short_name, ptd2.short_name
1815: from pay_retro_components prc,
1816: pay_time_spans pts,
1817: pay_time_definitions ptd,
1818: pay_time_definitions ptd2
1819: where pts.creator_id = prc.retro_component_id
1820: and prc.legislation_code = 'AU'
1821: and ptd.legislation_code = 'AU'
1822: and ptd.time_definition_id = pts.start_time_def_id

Line 2565: (p_short_name pay_time_definitions.short_name%TYPE

2561: -- then the other fields will be updated.
2562: -- else a new time definition will be created.
2563: --------------------------------------------------------------------------
2564: FUNCTION create_time_definitions
2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

Line 2566: ,p_definition_name pay_time_definitions.definition_name%TYPE

2562: -- else a new time definition will be created.
2563: --------------------------------------------------------------------------
2564: FUNCTION create_time_definitions
2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

Line 2567: ,p_period_type pay_time_definitions.period_type%TYPE

2563: --------------------------------------------------------------------------
2564: FUNCTION create_time_definitions
2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2571: RETURN NUMBER

Line 2568: ,p_period_unit pay_time_definitions.period_unit%TYPE

2564: FUNCTION create_time_definitions
2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2571: RETURN NUMBER
2572: IS

Line 2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2571: RETURN NUMBER
2572: IS
2573: --

Line 2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2571: RETURN NUMBER
2572: IS
2573: --
2574: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

Line 2574: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

2570: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2571: RETURN NUMBER
2572: IS
2573: --
2574: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;
2575: --
2576: CURSOR csr_time_definition_exists
2577: IS
2578: SELECT time_definition_id

Line 2579: FROM pay_time_definitions

2575: --
2576: CURSOR csr_time_definition_exists
2577: IS
2578: SELECT time_definition_id
2579: FROM pay_time_definitions
2580: WHERE short_name = p_short_name
2581: AND period_type = p_period_type
2582: AND legislation_code = g_legislation_code;
2583: --

Line 2586: SELECT pay_time_definitions_s.nextval

2582: AND legislation_code = g_legislation_code;
2583: --
2584: CURSOR csr_get_time_definition
2585: IS
2586: SELECT pay_time_definitions_s.nextval
2587: from dual;
2588: --
2589: BEGIN
2590: --

Line 2601: INSERT INTO pay_time_definitions

2597: OPEN csr_get_time_definition;
2598: FETCH csr_get_time_definition INTO l_time_definition_id;
2599: CLOSE csr_get_time_definition;
2600: --
2601: INSERT INTO pay_time_definitions
2602: (time_definition_id
2603: ,short_name
2604: ,definition_name
2605: ,period_type

Line 2624: UPDATE pay_time_definitions

2620: ,g_legislation_code);
2621: --
2622: ELSE
2623: --
2624: UPDATE pay_time_definitions
2625: SET definition_name = p_definition_name
2626: , period_unit = p_period_unit
2627: , day_adjustment = p_day_adjustment
2628: , dynamic_code = p_dynamic_code

Line 2899: (p_short_name pay_time_definitions.short_name%TYPE

2895: -- Private Function to get time definitions
2896: -- Bug#5556042
2897: --------------------------------------------------------------------------
2898: FUNCTION get_time_definitions
2899: (p_short_name pay_time_definitions.short_name%TYPE
2900: )
2901: RETURN NUMBER
2902: IS
2903: --

Line 2904: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

2900: )
2901: RETURN NUMBER
2902: IS
2903: --
2904: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;
2905: --
2906: CURSOR csr_get_time_definition
2907: IS
2908: SELECT time_definition_id

Line 2909: FROM pay_time_definitions

2905: --
2906: CURSOR csr_get_time_definition
2907: IS
2908: SELECT time_definition_id
2909: FROM pay_time_definitions
2910: WHERE short_name = p_short_name
2911: AND legislation_code = 'AU';
2912: --
2913: --

Line 2944: l_start_time_id pay_time_definitions.time_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;
2944: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2945: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2946: l_time_span_id pay_time_spans.time_span_id%TYPE;
2947:
2948: BEGIN

Line 2945: l_end_time_id pay_time_definitions.time_definition_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;
2944: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2945: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2946: l_time_span_id pay_time_spans.time_span_id%TYPE;
2947:
2948: BEGIN
2949: