DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HR_GENERAL

Line 181: hr_general.end_of_time;

177: -- NOTE: these setting are not the wrong way round
178: -- need a date for when the first LEAST/GREATEST comparison is done, so we always get the
179: -- TC start/stop time
180: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
181: hr_general.end_of_time;
182: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
183: hr_general.start_of_time;
184: END IF;
185:

Line 183: hr_general.start_of_time;

179: -- TC start/stop time
180: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
181: hr_general.end_of_time;
182: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
183: hr_general.start_of_time;
184: END IF;
185:
186: RETURN 1;
187: END initialise_g_resource;

Line 1970: NVL (g_params.p_start_date, hr_general.start_of_time);

1966: hr_utility.TRACE ('Using Dates');
1967: END IF;
1968:
1969: l_start_date :=
1970: NVL (g_params.p_start_date, hr_general.start_of_time);
1971: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1972: END IF;
1973:
1974: IF g_debug

Line 1971: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);

1967: END IF;
1968:
1969: l_start_date :=
1970: NVL (g_params.p_start_date, hr_general.start_of_time);
1971: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1972: END IF;
1973:
1974: IF g_debug
1975: THEN

Line 2320: NVL (g_params.p_start_date, hr_general.start_of_time);

2316: ELSE -- this must be the EAM retrieval
2317: IF (g_params.l_using_dates)
2318: THEN
2319: l_start_date :=
2320: NVL (g_params.p_start_date, hr_general.start_of_time);
2321: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
2322: END IF;
2323:
2324: IF (g_params.l_using_dates)

Line 2321: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);

2317: IF (g_params.l_using_dates)
2318: THEN
2319: l_start_date :=
2320: NVL (g_params.p_start_date, hr_general.start_of_time);
2321: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
2322: END IF;
2323:
2324: IF (g_params.l_using_dates)
2325: THEN

Line 5575: hr_general.end_of_time;

5571: t_bb (x).detail_resource_id;
5572: hxc_generic_retrieval_utils.g_resources
5573: (t_bb (x).detail_resource_id
5574: ).start_time :=
5575: hr_general.end_of_time;
5576: hxc_generic_retrieval_utils.g_resources
5577: (t_bb (x).detail_resource_id
5578: ).stop_time :=
5579: hr_general.start_of_time;

Line 5579: hr_general.start_of_time;

5575: hr_general.end_of_time;
5576: hxc_generic_retrieval_utils.g_resources
5577: (t_bb (x).detail_resource_id
5578: ).stop_time :=
5579: hr_general.start_of_time;
5580: END IF;
5581: END LOOP;
5582: END IF;
5583:

Line 6949: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )

6945: , detail_block.date_from
6946: , detail_block.date_to
6947: , detail_block.approval_status
6948: , detail_block.approval_style_id
6949: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )
6950: , detail_att.attribute_category
6951: , 1
6952: , 1
6953: , NVL(detail_max_ovn.max_ovn, 0)

Line 6958: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';

6954: , detail_block.unit_of_measure
6955: , timecard_block.start_time
6956: , timecard_block.stop_time
6957: , timecard_block.comment_text
6958: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
6959: l_select VARCHAR2 (1945)
6960: := '
6961: SELECT /*+ ordered use_nl(
6962: detail_block detail_usage detail_att

Line 7018: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )

7014: , detail_block.date_from
7015: , detail_block.date_to
7016: , detail_block.approval_status
7017: , detail_block.approval_style_id
7018: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )
7019: , detail_att.attribute_category
7020: , 1
7021: , 1
7022: , detail_block.object_version_number -1

Line 7027: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';

7023: , detail_block.unit_of_measure
7024: , timecard_block.start_time
7025: , timecard_block.stop_time
7026: , timecard_block.comment_text
7027: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
7028: l_from VARCHAR2 (200)
7029: := '
7030: FROM
7031: hxc_time_building_blocks timecard_block

Line 7710: l_start_date DATE := NVL (p_start_date, hr_general.start_of_time);

7706: ('OFF_LINE', 'RESTORE_IN_PROGRESS',
7707: 'BACKUP_IN_PROGRESS');
7708:
7709: l_message_text VARCHAR2 (2000);
7710: l_start_date DATE := NVL (p_start_date, hr_general.start_of_time);
7711: l_end_date DATE := NVL (p_end_date, hr_general.end_of_time);
7712: BEGIN
7713: IF g_debug
7714: THEN

Line 7711: l_end_date DATE := NVL (p_end_date, hr_general.end_of_time);

7707: 'BACKUP_IN_PROGRESS');
7708:
7709: l_message_text VARCHAR2 (2000);
7710: l_start_date DATE := NVL (p_start_date, hr_general.start_of_time);
7711: l_end_date DATE := NVL (p_end_date, hr_general.end_of_time);
7712: BEGIN
7713: IF g_debug
7714: THEN
7715: hr_utility.TRACE ('Entering chk_a_and_r_overlap');

Line 8099: TO_DATE ( TO_CHAR (TRUNC (hr_general.end_of_time),

8095: ELSIF (p_start_date IS NOT NULL AND p_end_date IS NULL)
8096: THEN
8097: g_params.p_start_date := TRUNC (p_start_date);
8098: g_params.p_end_date :=
8099: TO_DATE ( TO_CHAR (TRUNC (hr_general.end_of_time),
8100: 'DD/MM/YYYY'
8101: )
8102: || ' 23:59:59',
8103: 'DD/MM/YYYY HH24:MI:SS'

Line 8108: g_params.p_start_date := hr_general.start_of_time;

8104: );
8105: g_params.l_using_dates := TRUE;
8106: ELSIF (p_start_date IS NULL AND p_end_date IS NOT NULL)
8107: THEN
8108: g_params.p_start_date := hr_general.start_of_time;
8109: g_params.p_end_date :=
8110: TO_DATE ( TO_CHAR (TRUNC (p_end_date), 'DD/MM/YYYY')
8111: || ' 23:59:59',
8112: 'DD/MM/YYYY HH24:MI:SS'