APPS.HXC_APPROVAL_UTILITIES dependencies on HXC_APPROVAL_UTILITIES

Line 1: PACKAGE BODY hxc_approval_utilities AS

1: PACKAGE BODY hxc_approval_utilities AS
2: /* $Header: hxcaprutil.pkb 120.7.12010000.3 2010/04/21 11:27:17 amakrish ship $ */
3:
4: TYPE approval_notification is RECORD(
5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 25: g_package VARCHAR2(100) := 'hxc_approval_utilities.';

21:
22: type cur_type is REF CURSOR;
23:
24: g_transaction_id NUMBER := NULL;
25: g_package VARCHAR2(100) := 'hxc_approval_utilities.';
26: g_debug BOOLEAN := hr_utility.debug_enabled;
27:
28: FUNCTION is_selected(
29: p_selected_ids IN hxc_deposit_wrapper_utilities.t_simple_table

Line 496: l_one_where := 'hxc_approval_utilities.has_comment(htbb.time_building_block_id, htbb.object_version_number,'''

492: || ', ''RRRR/MM/DD'')';
493:
494: ELSIF l_search_by = 'TIMECARD_COMMENT'
495: THEN
496: l_one_where := 'hxc_approval_utilities.has_comment(htbb.time_building_block_id, htbb.object_version_number,'''
497: || l_search_operator || ''',''' || l_search_value || ''') = ''Y''';
498:
499: ELSIF l_search_by = 'DETAIL_COMMENT'
500: THEN

Line 501: l_one_where := 'hxc_approval_utilities.has_detail_comment(htbb.time_building_block_id, htbb.object_version_number, '''

497: || l_search_operator || ''',''' || l_search_value || ''') = ''Y''';
498:
499: ELSIF l_search_by = 'DETAIL_COMMENT'
500: THEN
501: l_one_where := 'hxc_approval_utilities.has_detail_comment(htbb.time_building_block_id, htbb.object_version_number, '''
502: || l_search_operator || ''',''' || l_search_value || ''') = ''Y''';
503:
504: ELSIF l_search_by = 'STATUS_CODE'
505: THEN

Line 567: l_one_where := 'hxc_approval_utilities.attribute_search(htbb.time_building_block_id, htbb.object_version_number,'

563:
564:
565: ELSE
566: --attribute search
567: l_one_where := 'hxc_approval_utilities.attribute_search(htbb.time_building_block_id, htbb.object_version_number,'
568: || '''' || l_search_by || ''',''' || l_search_value || ''',''' || l_search_operator
569: || ''', htbb.resource_id) = ''Y''';
570:
571:

Line 1222: END hxc_approval_utilities;

1218: );
1219: END IF;
1220: END get_approval_notifications;
1221:
1222: END hxc_approval_utilities;
1223: