APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_TIME_SPANS

Line 2775: (p_creator_id pay_time_spans.creator_id%TYPE

2771: -- then the start and end time definition ids will be updated.
2772: -- else a new time span will be created.
2773: --------------------------------------------------------------------------
2774: FUNCTION create_time_spans
2775: (p_creator_id pay_time_spans.creator_id%TYPE
2776: ,p_creator_type pay_time_spans.creator_type%TYPE
2777: ,p_start_time_def_id pay_time_spans.start_time_def_id%TYPE
2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)
2779: RETURN NUMBER

Line 2776: ,p_creator_type pay_time_spans.creator_type%TYPE

2772: -- else a new time span will be created.
2773: --------------------------------------------------------------------------
2774: FUNCTION create_time_spans
2775: (p_creator_id pay_time_spans.creator_id%TYPE
2776: ,p_creator_type pay_time_spans.creator_type%TYPE
2777: ,p_start_time_def_id pay_time_spans.start_time_def_id%TYPE
2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)
2779: RETURN NUMBER
2780: IS

Line 2777: ,p_start_time_def_id pay_time_spans.start_time_def_id%TYPE

2773: --------------------------------------------------------------------------
2774: FUNCTION create_time_spans
2775: (p_creator_id pay_time_spans.creator_id%TYPE
2776: ,p_creator_type pay_time_spans.creator_type%TYPE
2777: ,p_start_time_def_id pay_time_spans.start_time_def_id%TYPE
2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)
2779: RETURN NUMBER
2780: IS
2781: --

Line 2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)

2774: FUNCTION create_time_spans
2775: (p_creator_id pay_time_spans.creator_id%TYPE
2776: ,p_creator_type pay_time_spans.creator_type%TYPE
2777: ,p_start_time_def_id pay_time_spans.start_time_def_id%TYPE
2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)
2779: RETURN NUMBER
2780: IS
2781: --
2782: l_time_span_id pay_time_spans.time_span_id%TYPE;

Line 2782: l_time_span_id pay_time_spans.time_span_id%TYPE;

2778: ,p_end_time_def_id pay_time_spans.end_time_def_id%TYPE)
2779: RETURN NUMBER
2780: IS
2781: --
2782: l_time_span_id pay_time_spans.time_span_id%TYPE;
2783: --
2784: CURSOR csr_time_span_exists
2785: IS
2786: SELECT time_span_id

Line 2787: FROM pay_time_spans

2783: --
2784: CURSOR csr_time_span_exists
2785: IS
2786: SELECT time_span_id
2787: FROM pay_time_spans
2788: WHERE creator_id = p_creator_id
2789: AND creator_type = p_creator_type
2790: AND start_time_def_id = p_start_time_def_id
2791: AND end_time_def_id = p_end_time_def_id;

Line 2795: select pay_time_spans_s.nextval

2791: AND end_time_def_id = p_end_time_def_id;
2792:
2793: CURSOR csr_get_time_span
2794: IS
2795: select pay_time_spans_s.nextval
2796: from dual;
2797: --
2798: BEGIN
2799: --

Line 2810: INSERT INTO pay_time_spans

2806: open csr_get_time_span;
2807: fetch csr_get_time_span into l_time_span_id;
2808: close csr_get_time_span;
2809:
2810: INSERT INTO pay_time_spans
2811: (time_span_id
2812: ,creator_id
2813: ,creator_type
2814: ,start_time_def_id

Line 2824: UPDATE pay_time_spans

2820: , p_end_time_def_id);
2821: --
2822: ELSE
2823: --
2824: UPDATE pay_time_spans
2825: SET start_time_def_id = p_start_time_def_id
2826: , end_time_def_id = p_end_time_def_id
2827: WHERE time_span_id = l_time_span_id;
2828: --

Line 2853: l_time_span_id pay_time_spans.time_span_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: --
2857: -- Insert a new retro definition for the new localisation