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_IP_STARTUP_UTIL dependencies on PAY_TIME_DEFINITIONS

Line 2692: ,p_short_name pay_time_definitions.short_name%TYPE

2688: -- else a new time definition will be created.
2689: --------------------------------------------------------------------------
2690: FUNCTION create_time_definitions
2691: (p_legislation_code VARCHAR2
2692: ,p_short_name pay_time_definitions.short_name%TYPE
2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

Line 2693: ,p_definition_name pay_time_definitions.definition_name%TYPE

2689: --------------------------------------------------------------------------
2690: FUNCTION create_time_definitions
2691: (p_legislation_code VARCHAR2
2692: ,p_short_name pay_time_definitions.short_name%TYPE
2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

Line 2694: ,p_period_type pay_time_definitions.period_type%TYPE

2690: FUNCTION create_time_definitions
2691: (p_legislation_code VARCHAR2
2692: ,p_short_name pay_time_definitions.short_name%TYPE
2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2698: RETURN NUMBER

Line 2695: ,p_period_unit pay_time_definitions.period_unit%TYPE

2691: (p_legislation_code VARCHAR2
2692: ,p_short_name pay_time_definitions.short_name%TYPE
2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2698: RETURN NUMBER
2699: IS

Line 2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

2692: ,p_short_name pay_time_definitions.short_name%TYPE
2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2698: RETURN NUMBER
2699: IS
2700: --

Line 2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)

2693: ,p_definition_name pay_time_definitions.definition_name%TYPE
2694: ,p_period_type pay_time_definitions.period_type%TYPE
2695: ,p_period_unit pay_time_definitions.period_unit%TYPE
2696: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE
2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2698: RETURN NUMBER
2699: IS
2700: --
2701: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

Line 2701: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;

2697: ,p_dynamic_code pay_time_definitions.dynamic_code%TYPE)
2698: RETURN NUMBER
2699: IS
2700: --
2701: l_time_definition_id pay_time_definitions.time_definition_id%TYPE;
2702: --
2703: CURSOR csr_time_definition_exists
2704: IS
2705: SELECT time_definition_id

Line 2706: FROM pay_time_definitions

2702: --
2703: CURSOR csr_time_definition_exists
2704: IS
2705: SELECT time_definition_id
2706: FROM pay_time_definitions
2707: WHERE short_name = p_short_name
2708: AND period_type = p_period_type
2709: AND legislation_code = p_legislation_code;
2710: --

Line 2713: SELECT pay_time_definitions_s.nextval

2709: AND legislation_code = p_legislation_code;
2710: --
2711: CURSOR csr_get_time_definition
2712: IS
2713: SELECT pay_time_definitions_s.nextval
2714: from dual;
2715: --
2716: BEGIN
2717: --

Line 2728: INSERT INTO pay_time_definitions

2724: OPEN csr_get_time_definition;
2725: FETCH csr_get_time_definition INTO l_time_definition_id;
2726: CLOSE csr_get_time_definition;
2727: --
2728: INSERT INTO pay_time_definitions
2729: (time_definition_id
2730: ,short_name
2731: ,definition_name
2732: ,period_type

Line 2751: UPDATE pay_time_definitions

2747: ,p_legislation_code);
2748: --
2749: ELSE
2750: --
2751: UPDATE pay_time_definitions
2752: SET definition_name = p_definition_name
2753: , period_unit = p_period_unit
2754: , day_adjustment = p_day_adjustment
2755: , dynamic_code = p_dynamic_code

Line 2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;

2847: l_corr_up_comp pay_retro_components.retro_component_id%TYPE;
2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2852: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2853: l_time_span_id pay_time_spans.time_span_id%TYPE;
2854:
2855: Begin

Line 2852: l_end_time_id pay_time_definitions.time_definition_id%TYPE;

2848: l_back_up_comp pay_retro_components.retro_component_id%TYPE;
2849: l_db_lumpsum_comp pay_retro_components.retro_component_id%TYPE;
2850: l_defn_comp_id pay_retro_defn_components.definition_component_id%TYPE;
2851: l_start_time_id pay_time_definitions.time_definition_id%TYPE;
2852: l_end_time_id pay_time_definitions.time_definition_id%TYPE;
2853: l_time_span_id pay_time_spans.time_span_id%TYPE;
2854:
2855: Begin
2856: --