DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HR_GENERAL

Line 166: hr_general.end_of_time;

162: -- NOTE: these setting are not the wrong way round
163: -- need a date for when the first LEAST/GREATEST comparison is done, so we always get the
164: -- TC start/stop time
165: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
166: hr_general.end_of_time;
167: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
168: hr_general.start_of_time;
169: END IF;
170:

Line 168: hr_general.start_of_time;

164: -- TC start/stop time
165: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
166: hr_general.end_of_time;
167: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
168: hr_general.start_of_time;
169: END IF;
170:
171: RETURN 1;
172: END initialise_g_resource;

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

1385: hr_utility.TRACE ('Using Dates');
1386: END IF;
1387:
1388: l_start_date :=
1389: NVL (g_params.p_start_date, hr_general.start_of_time);
1390: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1391: END IF;
1392:
1393: IF g_debug

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

1386: END IF;
1387:
1388: l_start_date :=
1389: NVL (g_params.p_start_date, hr_general.start_of_time);
1390: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1391: END IF;
1392:
1393: IF g_debug
1394: THEN

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

1717: ELSE -- this must be the EAM retrieval
1718: IF (g_params.l_using_dates)
1719: THEN
1720: l_start_date :=
1721: NVL (g_params.p_start_date, hr_general.start_of_time);
1722: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1723: END IF;
1724:
1725: IF (g_params.l_using_dates)

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

1718: IF (g_params.l_using_dates)
1719: THEN
1720: l_start_date :=
1721: NVL (g_params.p_start_date, hr_general.start_of_time);
1722: l_end_date := NVL (g_params.p_end_date, hr_general.end_of_time);
1723: END IF;
1724:
1725: IF (g_params.l_using_dates)
1726: THEN

Line 4901: hr_general.end_of_time;

4897: t_bb (x).detail_resource_id;
4898: hxc_generic_retrieval_utils.g_resources
4899: (t_bb (x).detail_resource_id
4900: ).start_time :=
4901: hr_general.end_of_time;
4902: hxc_generic_retrieval_utils.g_resources
4903: (t_bb (x).detail_resource_id
4904: ).stop_time :=
4905: hr_general.start_of_time;

Line 4905: hr_general.start_of_time;

4901: hr_general.end_of_time;
4902: hxc_generic_retrieval_utils.g_resources
4903: (t_bb (x).detail_resource_id
4904: ).stop_time :=
4905: hr_general.start_of_time;
4906: END IF;
4907: END LOOP;
4908: END IF;
4909:

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

6210: , detail_block.date_from
6211: , detail_block.date_to
6212: , detail_block.approval_status
6213: , detail_block.approval_style_id
6214: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )
6215: , detail_att.attribute_category
6216: , 1
6217: , 1
6218: , NVL(detail_max_ovn.max_ovn, 0)

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

6219: , detail_block.unit_of_measure
6220: , timecard_block.start_time
6221: , timecard_block.stop_time
6222: , timecard_block.comment_text
6223: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
6224: l_select VARCHAR2 (1945)
6225: := '
6226: SELECT /*+ ordered use_nl(
6227: detail_block detail_usage detail_att

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

6279: , detail_block.date_from
6280: , detail_block.date_to
6281: , detail_block.approval_status
6282: , detail_block.approval_style_id
6283: , DECODE ( detail_block.date_to, hr_general.end_of_time, ''N'', ''Y'' )
6284: , detail_att.attribute_category
6285: , 1
6286: , 1
6287: , detail_block.object_version_number -1

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

6288: , detail_block.unit_of_measure
6289: , timecard_block.start_time
6290: , timecard_block.stop_time
6291: , timecard_block.comment_text
6292: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
6293: l_from VARCHAR2 (200)
6294: := '
6295: FROM
6296: hxc_time_building_blocks timecard_block

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

6823: ('OFF_LINE', 'RESTORE_IN_PROGRESS',
6824: 'BACKUP_IN_PROGRESS');
6825:
6826: l_message_text VARCHAR2 (2000);
6827: l_start_date DATE := NVL (p_start_date, hr_general.start_of_time);
6828: l_end_date DATE := NVL (p_end_date, hr_general.end_of_time);
6829: BEGIN
6830: IF g_debug
6831: THEN

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

6824: 'BACKUP_IN_PROGRESS');
6825:
6826: l_message_text VARCHAR2 (2000);
6827: l_start_date DATE := NVL (p_start_date, hr_general.start_of_time);
6828: l_end_date DATE := NVL (p_end_date, hr_general.end_of_time);
6829: BEGIN
6830: IF g_debug
6831: THEN
6832: hr_utility.TRACE ('Entering chk_a_and_r_overlap');

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

7164: ELSIF (p_start_date IS NOT NULL AND p_end_date IS NULL)
7165: THEN
7166: g_params.p_start_date := TRUNC (p_start_date);
7167: g_params.p_end_date :=
7168: TO_DATE ( TO_CHAR (TRUNC (hr_general.end_of_time),
7169: 'DD/MM/YYYY'
7170: )
7171: || ' 23:59:59',
7172: 'DD/MM/YYYY HH24:MI:SS'

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

7173: );
7174: g_params.l_using_dates := TRUE;
7175: ELSIF (p_start_date IS NULL AND p_end_date IS NOT NULL)
7176: THEN
7177: g_params.p_start_date := hr_general.start_of_time;
7178: g_params.p_end_date :=
7179: TO_DATE ( TO_CHAR (TRUNC (p_end_date), 'DD/MM/YYYY')
7180: || ' 23:59:59',
7181: 'DD/MM/YYYY HH24:MI:SS'