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.HXC_TIMEKEEPER_PROCESS dependencies on FND_DATE

Line 5786: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN

5782:
5783: LOOP
5784: EXIT WHEN (NOT l_timecard.EXISTS (l_timecard_index));
5785: IF l_timecard (l_timecard_index).SCOPE = 'DETAIL' THEN
5786: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN
5787: l_delete := FALSE;
5788: EXIT;
5789: END IF;
5790: END IF;

Line 5793: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) =

5789: END IF;
5790: END IF;
5791:
5792: IF l_timecard (l_timecard_index).SCOPE = 'TIMECARD' THEN
5793: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) =
5794: hr_general.end_of_time
5795: AND l_timecard (l_timecard_index).comment_text IS NOT NULL
5796: AND l_timecard (l_timecard_index).NEW = 'Y' THEN
5797: l_delete := FALSE;

Line 6115: argument2 => fnd_date.date_to_canonical (p_start_period),

6111: application => 'HXC',
6112: program => 'HXCTKSUB',
6113: description => NULL,
6114: argument1 => p_timekeeper_id,
6115: argument2 => fnd_date.date_to_canonical (p_start_period),
6116: argument3 => fnd_date.date_to_canonical (p_end_period),
6117: argument4 => p_submission_id
6118: );
6119: COMMIT;

Line 6116: argument3 => fnd_date.date_to_canonical (p_end_period),

6112: program => 'HXCTKSUB',
6113: description => NULL,
6114: argument1 => p_timekeeper_id,
6115: argument2 => fnd_date.date_to_canonical (p_start_period),
6116: argument3 => fnd_date.date_to_canonical (p_end_period),
6117: argument4 => p_submission_id
6118: );
6119: COMMIT;
6120: END;

Line 6435: fnd_date.canonical_to_date (p_start_period),

6431: mo_global.set_policy_context ( 'S', l_operating_unit_id );
6432: End;
6433: hxc_timekeeper_utilities.populate_tc_tab (
6434: c_resource.resource_id,
6435: fnd_date.canonical_to_date (p_start_period),
6436: fnd_date.canonical_to_date (p_end_period),
6437: spemp_tc_info
6438: );
6439: /* changes done by senthil for emp terminate enhancement*/

Line 6436: fnd_date.canonical_to_date (p_end_period),

6432: End;
6433: hxc_timekeeper_utilities.populate_tc_tab (
6434: c_resource.resource_id,
6435: fnd_date.canonical_to_date (p_start_period),
6436: fnd_date.canonical_to_date (p_end_period),
6437: spemp_tc_info
6438: );
6439: /* changes done by senthil for emp terminate enhancement*/
6440: /*Changed By Mithun for CWK Terminate Bug*/

Line 6444: if l_emp_terminate_date between fnd_date.canonical_to_date (p_start_period) and fnd_date.canonical_to_date (p_end_period) then

6440: /*Changed By Mithun for CWK Terminate Bug*/
6441: OPEN c_emp_terminateinfo (p_resource_id => c_resource.resource_id);
6442: FETCH c_emp_terminateinfo INTO l_emp_terminate_date, date_start;
6443: CLOSE c_emp_terminateinfo;
6444: if l_emp_terminate_date between fnd_date.canonical_to_date (p_start_period) and fnd_date.canonical_to_date (p_end_period) then
6445: open c_tc_in_term_period_exists(c_resource.resource_id, fnd_date.canonical_to_date (p_start_period), fnd_date.canonical_to_date (p_end_period));
6446: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
6447: close c_tc_in_term_period_exists;
6448: end if;

Line 6445: open c_tc_in_term_period_exists(c_resource.resource_id, fnd_date.canonical_to_date (p_start_period), fnd_date.canonical_to_date (p_end_period));

6441: OPEN c_emp_terminateinfo (p_resource_id => c_resource.resource_id);
6442: FETCH c_emp_terminateinfo INTO l_emp_terminate_date, date_start;
6443: CLOSE c_emp_terminateinfo;
6444: if l_emp_terminate_date between fnd_date.canonical_to_date (p_start_period) and fnd_date.canonical_to_date (p_end_period) then
6445: open c_tc_in_term_period_exists(c_resource.resource_id, fnd_date.canonical_to_date (p_start_period), fnd_date.canonical_to_date (p_end_period));
6446: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
6447: close c_tc_in_term_period_exists;
6448: end if;
6449: if l_tc_in_term_status <> 'Y' then

Line 6452: fnd_date.canonical_to_date (p_start_period),

6448: end if;
6449: if l_tc_in_term_status <> 'Y' then
6450: hxc_timekeeper_utilities.split_timecard (
6451: c_resource.resource_id,
6452: fnd_date.canonical_to_date (p_start_period),
6453: fnd_date.canonical_to_date (p_end_period),
6454: spemp_tc_info,
6455: spemp_tc_list
6456: );

Line 6453: fnd_date.canonical_to_date (p_end_period),

6449: if l_tc_in_term_status <> 'Y' then
6450: hxc_timekeeper_utilities.split_timecard (
6451: c_resource.resource_id,
6452: fnd_date.canonical_to_date (p_start_period),
6453: fnd_date.canonical_to_date (p_end_period),
6454: spemp_tc_info,
6455: spemp_tc_list
6456: );
6457: else

Line 6458: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).start_date := fnd_date.canonical_to_date (p_start_period);

6454: spemp_tc_info,
6455: spemp_tc_list
6456: );
6457: else
6458: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).start_date := fnd_date.canonical_to_date (p_start_period);
6459: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).end_date := fnd_date.canonical_to_date (p_end_period);
6460: end if;
6461: sp_index := spemp_tc_list.FIRST;
6462: LOOP

Line 6459: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).end_date := fnd_date.canonical_to_date (p_end_period);

6455: spemp_tc_list
6456: );
6457: else
6458: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).start_date := fnd_date.canonical_to_date (p_start_period);
6459: spemp_tc_list (TO_NUMBER (TO_CHAR (TO_DATE (fnd_date.canonical_to_date(p_start_period), 'dd-mm-rrrr'), 'J'))).end_date := fnd_date.canonical_to_date (p_end_period);
6460: end if;
6461: sp_index := spemp_tc_list.FIRST;
6462: LOOP
6463: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);

Line 6464: IF (TO_DATE (fnd_date.canonical_to_date (p_start_period), 'DD-MM-RRRR') >

6460: end if;
6461: sp_index := spemp_tc_list.FIRST;
6462: LOOP
6463: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);
6464: IF (TO_DATE (fnd_date.canonical_to_date (p_start_period), 'DD-MM-RRRR') >
6465: TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR')
6466: )
6467: OR (TO_DATE (fnd_date.canonical_to_date (p_end_period), 'DD-MM-RRRR') <
6468: TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR')

Line 6467: OR (TO_DATE (fnd_date.canonical_to_date (p_end_period), 'DD-MM-RRRR') <

6463: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);
6464: IF (TO_DATE (fnd_date.canonical_to_date (p_start_period), 'DD-MM-RRRR') >
6465: TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR')
6466: )
6467: OR (TO_DATE (fnd_date.canonical_to_date (p_end_period), 'DD-MM-RRRR') <
6468: TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR')
6469: ) THEN
6470: NULL;
6471: /*ADVICE(4432): Use of NULL statements [532] */

Line 6488: p_tc_frdt => fnd_date.canonical_to_date (p_start_period),

6484: create_timecard_day_structure (
6485: p_resource_id => c_resource.resource_id,
6486: p_start_period => TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR'),
6487: p_end_period => TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR'),
6488: p_tc_frdt => fnd_date.canonical_to_date (p_start_period),
6489: p_tc_todt => fnd_date.canonical_to_date (p_end_period),
6490: p_timecard => l_timecard,
6491: p_attributes => l_attributes,
6492: p_day_id_info_table => l_day_id_info_table,

Line 6489: p_tc_todt => fnd_date.canonical_to_date (p_end_period),

6485: p_resource_id => c_resource.resource_id,
6486: p_start_period => TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR'),
6487: p_end_period => TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR'),
6488: p_tc_frdt => fnd_date.canonical_to_date (p_start_period),
6489: p_tc_todt => fnd_date.canonical_to_date (p_end_period),
6490: p_timecard => l_timecard,
6491: p_attributes => l_attributes,
6492: p_day_id_info_table => l_day_id_info_table,
6493: p_approval_style_id => l_approval_style_id,

Line 6521: fnd_date.canonical_to_date (p_start_period),

6517: END IF;
6518:
6519: OPEN crs_employee_info (
6520: c_resource.resource_id,
6521: fnd_date.canonical_to_date (p_start_period),
6522: fnd_date.canonical_to_date (p_end_period)
6523: );
6524: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6525: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */

Line 6522: fnd_date.canonical_to_date (p_end_period)

6518:
6519: OPEN crs_employee_info (
6520: c_resource.resource_id,
6521: fnd_date.canonical_to_date (p_start_period),
6522: fnd_date.canonical_to_date (p_end_period)
6523: );
6524: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6525: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
6526:

Line 6562: p_start_time => fnd_date.canonical_to_date (p_start_period),

6558: IF l_lock_row_id IS NULL THEN
6559: hxc_lock_api.request_lock (
6560: p_process_locker_type => l_process_lock_type,
6561: p_resource_id => c_resource.resource_id,
6562: p_start_time => fnd_date.canonical_to_date (p_start_period),
6563: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,
6564: p_time_building_block_id => NULL,
6565: p_time_building_block_ovn => NULL,
6566: p_transaction_lock_id => l_lock_trx_id,

Line 6563: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,

6559: hxc_lock_api.request_lock (
6560: p_process_locker_type => l_process_lock_type,
6561: p_resource_id => c_resource.resource_id,
6562: p_start_time => fnd_date.canonical_to_date (p_start_period),
6563: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,
6564: p_time_building_block_id => NULL,
6565: p_time_building_block_ovn => NULL,
6566: p_transaction_lock_id => l_lock_trx_id,
6567: p_messages => l_messages,

Line 6590: fnd_date.canonical_to_date (p_start_period),

6586: END IF;
6587:
6588: OPEN crs_employee_info (
6589: c_resource.resource_id,
6590: fnd_date.canonical_to_date (p_start_period),
6591: fnd_date.canonical_to_date (p_end_period)
6592: );
6593: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6594: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */

Line 6591: fnd_date.canonical_to_date (p_end_period)

6587:
6588: OPEN crs_employee_info (
6589: c_resource.resource_id,
6590: fnd_date.canonical_to_date (p_start_period),
6591: fnd_date.canonical_to_date (p_end_period)
6592: );
6593: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6594: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */
6595:

Line 6635: fnd_date.canonical_to_date (p_start_period),

6631: ELSE
6632: --put message in log file as it is not locked
6633: OPEN crs_employee_info (
6634: c_resource.resource_id,
6635: fnd_date.canonical_to_date (p_start_period),
6636: fnd_date.canonical_to_date (p_end_period)
6637: );
6638: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6639: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */

Line 6636: fnd_date.canonical_to_date (p_end_period)

6632: --put message in log file as it is not locked
6633: OPEN crs_employee_info (
6634: c_resource.resource_id,
6635: fnd_date.canonical_to_date (p_start_period),
6636: fnd_date.canonical_to_date (p_end_period)
6637: );
6638: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6639: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */
6640: