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 4460: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN

4456:
4457: LOOP
4458: EXIT WHEN (NOT l_timecard.EXISTS (l_timecard_index));
4459: IF l_timecard (l_timecard_index).SCOPE = 'DETAIL' THEN
4460: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) = hr_general.end_of_time THEN
4461: l_delete := FALSE;
4462: EXIT;
4463: END IF;
4464: END IF;

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

4463: END IF;
4464: END IF;
4465:
4466: IF l_timecard (l_timecard_index).SCOPE = 'TIMECARD' THEN
4467: IF fnd_date.canonical_to_date (l_timecard (l_timecard_index).date_to) =
4468: hr_general.end_of_time
4469: AND l_timecard (l_timecard_index).comment_text IS NOT NULL
4470: AND l_timecard (l_timecard_index).NEW = 'Y' THEN
4471: l_delete := FALSE;

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

4759: application => 'HXC',
4760: program => 'HXCTKSUB',
4761: description => NULL,
4762: argument1 => p_timekeeper_id,
4763: argument2 => fnd_date.date_to_canonical (p_start_period),
4764: argument3 => fnd_date.date_to_canonical (p_end_period),
4765: argument4 => p_submission_id
4766: );
4767: COMMIT;

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

4760: program => 'HXCTKSUB',
4761: description => NULL,
4762: argument1 => p_timekeeper_id,
4763: argument2 => fnd_date.date_to_canonical (p_start_period),
4764: argument3 => fnd_date.date_to_canonical (p_end_period),
4765: argument4 => p_submission_id
4766: );
4767: COMMIT;
4768: END;

Line 5083: fnd_date.canonical_to_date (p_start_period),

5079: mo_global.set_policy_context ( 'S', l_operating_unit_id );
5080: End;
5081: hxc_timekeeper_utilities.populate_tc_tab (
5082: c_resource.resource_id,
5083: fnd_date.canonical_to_date (p_start_period),
5084: fnd_date.canonical_to_date (p_end_period),
5085: spemp_tc_info
5086: );
5087: /* changes done by senthil for emp terminate enhancement*/

Line 5084: fnd_date.canonical_to_date (p_end_period),

5080: End;
5081: hxc_timekeeper_utilities.populate_tc_tab (
5082: c_resource.resource_id,
5083: fnd_date.canonical_to_date (p_start_period),
5084: fnd_date.canonical_to_date (p_end_period),
5085: spemp_tc_info
5086: );
5087: /* changes done by senthil for emp terminate enhancement*/
5088: /*Changed By Mithun for CWK Terminate Bug*/

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

5088: /*Changed By Mithun for CWK Terminate Bug*/
5089: OPEN c_emp_terminateinfo (p_resource_id => c_resource.resource_id);
5090: FETCH c_emp_terminateinfo INTO l_emp_terminate_date, date_start;
5091: CLOSE c_emp_terminateinfo;
5092: if l_emp_terminate_date between fnd_date.canonical_to_date (p_start_period) and fnd_date.canonical_to_date (p_end_period) then
5093: 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));
5094: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
5095: close c_tc_in_term_period_exists;
5096: end if;

Line 5093: 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));

5089: OPEN c_emp_terminateinfo (p_resource_id => c_resource.resource_id);
5090: FETCH c_emp_terminateinfo INTO l_emp_terminate_date, date_start;
5091: CLOSE c_emp_terminateinfo;
5092: if l_emp_terminate_date between fnd_date.canonical_to_date (p_start_period) and fnd_date.canonical_to_date (p_end_period) then
5093: 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));
5094: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
5095: close c_tc_in_term_period_exists;
5096: end if;
5097: if l_tc_in_term_status <> 'Y' then

Line 5100: fnd_date.canonical_to_date (p_start_period),

5096: end if;
5097: if l_tc_in_term_status <> 'Y' then
5098: hxc_timekeeper_utilities.split_timecard (
5099: c_resource.resource_id,
5100: fnd_date.canonical_to_date (p_start_period),
5101: fnd_date.canonical_to_date (p_end_period),
5102: spemp_tc_info,
5103: spemp_tc_list
5104: );

Line 5101: fnd_date.canonical_to_date (p_end_period),

5097: if l_tc_in_term_status <> 'Y' then
5098: hxc_timekeeper_utilities.split_timecard (
5099: c_resource.resource_id,
5100: fnd_date.canonical_to_date (p_start_period),
5101: fnd_date.canonical_to_date (p_end_period),
5102: spemp_tc_info,
5103: spemp_tc_list
5104: );
5105: else

Line 5106: 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);

5102: spemp_tc_info,
5103: spemp_tc_list
5104: );
5105: else
5106: 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);
5107: 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);
5108: end if;
5109: sp_index := spemp_tc_list.FIRST;
5110: LOOP

Line 5107: 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);

5103: spemp_tc_list
5104: );
5105: else
5106: 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);
5107: 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);
5108: end if;
5109: sp_index := spemp_tc_list.FIRST;
5110: LOOP
5111: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);

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

5108: end if;
5109: sp_index := spemp_tc_list.FIRST;
5110: LOOP
5111: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);
5112: IF (TO_DATE (fnd_date.canonical_to_date (p_start_period), 'DD-MM-RRRR') >
5113: TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR')
5114: )
5115: OR (TO_DATE (fnd_date.canonical_to_date (p_end_period), 'DD-MM-RRRR') <
5116: TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR')

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

5111: EXIT WHEN NOT spemp_tc_list.EXISTS (sp_index);
5112: IF (TO_DATE (fnd_date.canonical_to_date (p_start_period), 'DD-MM-RRRR') >
5113: TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR')
5114: )
5115: OR (TO_DATE (fnd_date.canonical_to_date (p_end_period), 'DD-MM-RRRR') <
5116: TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR')
5117: ) THEN
5118: NULL;
5119: /*ADVICE(4432): Use of NULL statements [532] */

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

5132: create_timecard_day_structure (
5133: p_resource_id => c_resource.resource_id,
5134: p_start_period => TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR'),
5135: p_end_period => TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR'),
5136: p_tc_frdt => fnd_date.canonical_to_date (p_start_period),
5137: p_tc_todt => fnd_date.canonical_to_date (p_end_period),
5138: p_timecard => l_timecard,
5139: p_attributes => l_attributes,
5140: p_day_id_info_table => l_day_id_info_table,

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

5133: p_resource_id => c_resource.resource_id,
5134: p_start_period => TO_DATE (spemp_tc_list (sp_index).start_date, 'DD-MM-RRRR'),
5135: p_end_period => TO_DATE (spemp_tc_list (sp_index).end_date, 'DD-MM-RRRR'),
5136: p_tc_frdt => fnd_date.canonical_to_date (p_start_period),
5137: p_tc_todt => fnd_date.canonical_to_date (p_end_period),
5138: p_timecard => l_timecard,
5139: p_attributes => l_attributes,
5140: p_day_id_info_table => l_day_id_info_table,
5141: p_approval_style_id => l_approval_style_id,

Line 5169: fnd_date.canonical_to_date (p_start_period),

5165: END IF;
5166:
5167: OPEN crs_employee_info (
5168: c_resource.resource_id,
5169: fnd_date.canonical_to_date (p_start_period),
5170: fnd_date.canonical_to_date (p_end_period)
5171: );
5172: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5173: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */

Line 5170: fnd_date.canonical_to_date (p_end_period)

5166:
5167: OPEN crs_employee_info (
5168: c_resource.resource_id,
5169: fnd_date.canonical_to_date (p_start_period),
5170: fnd_date.canonical_to_date (p_end_period)
5171: );
5172: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5173: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
5174:

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

5206: IF l_lock_row_id IS NULL THEN
5207: hxc_lock_api.request_lock (
5208: p_process_locker_type => l_process_lock_type,
5209: p_resource_id => c_resource.resource_id,
5210: p_start_time => fnd_date.canonical_to_date (p_start_period),
5211: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,
5212: p_time_building_block_id => NULL,
5213: p_time_building_block_ovn => NULL,
5214: p_transaction_lock_id => l_lock_trx_id,

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

5207: hxc_lock_api.request_lock (
5208: p_process_locker_type => l_process_lock_type,
5209: p_resource_id => c_resource.resource_id,
5210: p_start_time => fnd_date.canonical_to_date (p_start_period),
5211: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,
5212: p_time_building_block_id => NULL,
5213: p_time_building_block_ovn => NULL,
5214: p_transaction_lock_id => l_lock_trx_id,
5215: p_messages => l_messages,

Line 5238: fnd_date.canonical_to_date (p_start_period),

5234: END IF;
5235:
5236: OPEN crs_employee_info (
5237: c_resource.resource_id,
5238: fnd_date.canonical_to_date (p_start_period),
5239: fnd_date.canonical_to_date (p_end_period)
5240: );
5241: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5242: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */

Line 5239: fnd_date.canonical_to_date (p_end_period)

5235:
5236: OPEN crs_employee_info (
5237: c_resource.resource_id,
5238: fnd_date.canonical_to_date (p_start_period),
5239: fnd_date.canonical_to_date (p_end_period)
5240: );
5241: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5242: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */
5243:

Line 5283: fnd_date.canonical_to_date (p_start_period),

5279: ELSE
5280: --put message in log file as it is not locked
5281: OPEN crs_employee_info (
5282: c_resource.resource_id,
5283: fnd_date.canonical_to_date (p_start_period),
5284: fnd_date.canonical_to_date (p_end_period)
5285: );
5286: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5287: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */

Line 5284: fnd_date.canonical_to_date (p_end_period)

5280: --put message in log file as it is not locked
5281: OPEN crs_employee_info (
5282: c_resource.resource_id,
5283: fnd_date.canonical_to_date (p_start_period),
5284: fnd_date.canonical_to_date (p_end_period)
5285: );
5286: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5287: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */
5288: