DBA Data[Home] [Help]

APPS.HXC_TCD_XML_PKG dependencies on HXC_TCD_XML_PKG

Line 1: PACKAGE BODY HXC_TCD_XML_PKG AS

1: PACKAGE BODY HXC_TCD_XML_PKG AS
2: /* $Header: hxctcdrpt.pkb 120.21 2011/02/17 09:01:49 pnshukla ship $ */
3:
4:
5: TYPE r_person_id IS RECORD (person_id NUMBER(15));

Line 438: hxc_tcd_xml_pkg.get_timecard_start_date(person_id,tim.timecard_id) AS start_date,

434: supervisor_name,
435: organization,
436: location,
437: payroll,
438: hxc_tcd_xml_pkg.get_timecard_start_date(person_id,tim.timecard_id) AS start_date,
439: hxc_tcd_xml_pkg.get_timecard_end_date(person_id,tim.timecard_id) AS end_date,
440: (SELECT user_name FROM fnd_user
441: WHERE user_id = (SELECT last_updated_by FROM hxc_time_building_blocks
442: WHERE scope = ''TIMECARD''

Line 439: hxc_tcd_xml_pkg.get_timecard_end_date(person_id,tim.timecard_id) AS end_date,

435: organization,
436: location,
437: payroll,
438: hxc_tcd_xml_pkg.get_timecard_start_date(person_id,tim.timecard_id) AS start_date,
439: hxc_tcd_xml_pkg.get_timecard_end_date(person_id,tim.timecard_id) AS end_date,
440: (SELECT user_name FROM fnd_user
441: WHERE user_id = (SELECT last_updated_by FROM hxc_time_building_blocks
442: WHERE scope = ''TIMECARD''
443: AND resource_id = person_id

Line 948: END HXC_TCD_XML_PKG ;

944: l_supervisor_id, l_location_id, l_org_id, l_sel_supervisor_id, l_sel_tc_status, l_rpt_status;
945:
946: END clear_report_table;
947:
948: END HXC_TCD_XML_PKG ;