DBA Data[Home] [Help]

APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,

330:
331: end get_description;
332:
333: function get_description_tc
334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)
336: return varchar2 is
337:
338: l_description fnd_new_messages.message_text%type;

Line 335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)

331: end get_description;
332:
333: function get_description_tc
334: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
335: p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)
336: return varchar2 is
337:
338: l_description fnd_new_messages.message_text%type;
339:

Line 792: FROM hxc_timecard_summary tcsum

788: IS
789: SELECT tcsum.resource_id,
790: tcsum.start_time,
791: tcsum.stop_time
792: FROM hxc_timecard_summary tcsum
793: WHERE tcsum.timecard_id = p_tc_bbid;
794:
795:
796: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';