APPS.HXC_TIMECARD_SEARCH_PKG dependencies on HXC_TIMECARD_SEARCH_PKG

Line 1: package body hxc_timecard_search_pkg as

1: package body hxc_timecard_search_pkg as
2: /* $Header: hxcserch.pkb 120.1 2006/03/23 02:56:53 gsirigin noship $ */
3:
4: TYPE search_record IS RECORD(
5: search_by VARCHAR2(100)

Line 404: RETURN(hxc_timecard_search_pkg.c_no_valueset_attached); --if value set not attached to a segment

400: RETURN l_return_string;
401: END IF;
402:
403: ELSE
404: RETURN(hxc_timecard_search_pkg.c_no_valueset_attached); --if value set not attached to a segment
405: END IF;
406:
407: END IF;
408: END LOOP;

Line 1091: || ' ,hxc_timecard_search_pkg.get_timecard_status_code('

1087:
1088:
1089: l_sql_select := 'SELECT distinct hrt.timecard_id'
1090: || ' ,hrt.timecard_ovn'
1091: || ' ,hxc_timecard_search_pkg.get_timecard_status_code('
1092: || ' hrt.timecard_id, '
1093: || ' hrt.timecard_ovn'
1094: || ' ) as status_code'
1095: || ' ,hxc_timecard_search_pkg.get_timecard_status_meaning('

Line 1095: || ' ,hxc_timecard_search_pkg.get_timecard_status_meaning('

1091: || ' ,hxc_timecard_search_pkg.get_timecard_status_code('
1092: || ' hrt.timecard_id, '
1093: || ' hrt.timecard_ovn'
1094: || ' ) as status_code'
1095: || ' ,hxc_timecard_search_pkg.get_timecard_status_meaning('
1096: || ' hrt.timecard_id, '
1097: || ' hrt.timecard_ovn'
1098: || ' ) as status_name'
1099: || ' ,hrt.period_starts'

Line 1554: if l_flex_search_value = hxc_timecard_search_pkg.c_no_valueset_attached

1550: || l_flex_search_value
1551: || ')';
1552: ELSE
1553:
1554: if l_flex_search_value = hxc_timecard_search_pkg.c_no_valueset_attached
1555: then
1556: l_one_where := ' hta.bld_blk_info_type_id = '
1557: || l_bld_blk_info_type_id
1558: || ' AND hta.'

Line 1615: END hxc_timecard_search_pkg;

1611:
1612: END get_sql_where;
1613:
1614:
1615: END hxc_timecard_search_pkg;