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_TIMECARD_UTILITIES dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_utilities AS

1: PACKAGE BODY hxc_timecard_utilities AS
2: /* $Header: hxctcutil.pkb 120.30.12020000.4 2013/05/16 09:35:43 pravesk ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_assignment_periods periods;

Line 16: g_package VARCHAR2(30) := 'hxc_timecard_utilities.';

12: g_num_future_entries NUMBER := 10; --hardcoded
13: g_separator VARCHAR2(1) := '|';
14: g_date_format VARCHAR2(20) := 'YYYY/MM/DD';
15: g_initialized VARCHAR2(20) := 'N';
16: g_package VARCHAR2(30) := 'hxc_timecard_utilities.';
17:
18: PROCEDURE get_period_by_duration(
19: p_rec_period_start_date IN DATE
20: ,p_duration_in_days IN NUMBER

Line 162: IF (p_period.exist_flag = hxc_timecard.c_existing_period_indicator) THEN

158: ELSE
159: l_return_index := p_return_periods.last + 1;
160: END IF;
161:
162: IF (p_period.exist_flag = hxc_timecard.c_existing_period_indicator) THEN
163:
164: --Remove the entry if its already found. We need to keep the existing period
165: --in the list, rather than a open period.
166: l_found_index := find_period_already_exist(p_return_periods,

Line 180: p_return_periods(l_return_index).exist_flag := hxc_timecard.c_archived_period_indicator;

176: p_return_periods(l_return_index).exist_flag := p_period.exist_flag;
177: p_return_periods(l_return_index).p_set_more_period := p_period.p_set_more_period;
178:
179: IF (check_period_archived(p_period.end_date)) THEN
180: p_return_periods(l_return_index).exist_flag := hxc_timecard.c_archived_period_indicator;
181: ELSE
182: p_return_periods(l_return_index).exist_flag := p_period.exist_flag;
183: END IF;
184:

Line 392: IF NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_existing_period_indicator AND NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_archived_period_indicator

388: || ' end=' || p_periods(l_index).end_date
389: || 'exists=' || NVL(p_periods(l_index).exist_flag, 'N'));
390: END IF;
391:
392: IF NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_existing_period_indicator AND NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_archived_period_indicator
393: THEN
394:
395:
396: IF not p_future and p_default_tc_period = 'EARLIEST' AND

Line 503: FROM hxc_timecard_summary

499:
500: CURSOR get_leading_timecards( p_resource_id IN NUMBER,
501: p_start_time IN DATE)
502: IS SELECT COUNT(1)
503: FROM hxc_timecard_summary
504: START WITH resource_id = p_resource_id
505: AND start_time = p_start_time
506: CONNECT BY resource_id = p_resource_id
507: AND PRIOR TRUNC(stop_time) + 1 = start_time;

Line 513: FROM hxc_timecard_summary

509:
510: CURSOR get_lagging_timecards( p_resource_id IN NUMBER,
511: p_stop_time IN DATE)
512: IS SELECT COUNT(1)
513: FROM hxc_timecard_summary
514: START WITH resource_id = p_resource_id
515: AND start_time < p_stop_time
516: AND stop_time = p_stop_time
517: CONNECT BY resource_id = p_resource_id

Line 538: hr_utility.trace('> In hxc_timecard_utilities.get_periods.');

534: hr_utility.set_location (g_package||l_proc, 10);
535: END IF;
536:
537: IF g_debug THEN
538: hr_utility.trace('> In hxc_timecard_utilities.get_periods.');
539: hr_utility.trace('> p_resource_id ::'||p_resource_id);
540: hr_utility.trace('> p_resource_type ::'||p_resource_type);
541: hr_utility.trace('> p_current_date ::'||p_current_date);
542: hr_utility.trace('> p_show_existing_timecard ::'||p_show_existing_timecard);

Line 796: ,p_set_more_period => hxc_timecard.c_more_period_indicator

792: p_periods => l_periods
793: ,p_start_date => l_start_date
794: ,p_end_date => l_end_date
795: ,p_position => 'BEFORE'
796: ,p_set_more_period => hxc_timecard.c_more_period_indicator
797: );
798: ELSE
799: l_added := add_period(
800: p_periods => l_periods

Line 915: ,p_set_more_period =>hxc_timecard.c_more_period_indicator

911: ,p_start_date => l_start_date
912: ,p_end_date => l_end_date
913: ,p_future_date_limit => g_future_date_limit
914: ,p_assignment_end => g_assignment_periods(l_assignment_index).end_date
915: ,p_set_more_period =>hxc_timecard.c_more_period_indicator
916: );
917: ELSE
918:
919: IF g_debug THEN

Line 978: ,p_exists => hxc_timecard.c_archived_period_indicator

974: ,p_end_date => l_periods(l_period_index).end_date
975: ,p_last_period_end => l_last_period_end
976: ,p_past_date_limit => g_past_date_limit
977: ,p_future_date_limit => g_future_date_limit
978: ,p_exists => hxc_timecard.c_archived_period_indicator
979: ,p_show_existing_timecard => p_show_existing_timecard
980: ,p_set_more_period => l_periods(l_period_index).p_set_more_period
981: );
982:

Line 1017: ,p_exists => hxc_timecard.c_existing_period_indicator

1013: ,p_end_date => l_end_date
1014: ,p_last_period_end => l_last_period_end
1015: ,p_past_date_limit => g_past_date_limit
1016: ,p_future_date_limit => g_future_date_limit
1017: ,p_exists => hxc_timecard.c_existing_period_indicator
1018: ,p_show_existing_timecard => p_show_existing_timecard
1019: ,p_set_more_period => get_more_period_value(l_periods,l_start_date,l_end_date)
1020: );
1021: END IF;

Line 1058: ,p_exists => hxc_timecard.c_archived_period_indicator

1054: ,p_end_date => l_periods(l_period_index).end_date
1055: ,p_last_period_end => l_last_period_end
1056: ,p_past_date_limit => g_past_date_limit
1057: ,p_future_date_limit => g_future_date_limit
1058: ,p_exists => hxc_timecard.c_archived_period_indicator
1059: ,p_show_existing_timecard => p_show_existing_timecard
1060: ,p_set_more_period => l_periods(l_period_index).p_set_more_period
1061: );
1062: ELSE

Line 1111: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND

1107: l_period_index := l_assignment_processed_periods.first;
1108: while l_period_index is not null
1109: loop
1110: if((l_assignment_processed_periods(l_period_index).exist_flag is null) or
1111: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND
1112: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))
1113: ) then
1114: l_processed_periods(l_index) := l_assignment_processed_periods(l_period_index);
1115: l_index := l_index+1;

Line 1112: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))

1108: while l_period_index is not null
1109: loop
1110: if((l_assignment_processed_periods(l_period_index).exist_flag is null) or
1111: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND
1112: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))
1113: ) then
1114: l_processed_periods(l_index) := l_assignment_processed_periods(l_period_index);
1115: l_index := l_index+1;
1116: end if;

Line 1176: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');

1172: -- look for empty period in the past
1173: l_current_date := p_current_date;
1174:
1175: IF g_debug THEN
1176: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');
1177: hr_utility.trace('> p_resource_id ::'||p_resource_id);
1178: hr_utility.trace('> p_resource_type ::'||p_resource_type);
1179: hr_utility.trace('> l_current_date ::'||l_current_date);
1180: hr_utility.trace('> p_show_existing_timecard ::'||p_show_existing_timecard);

Line 1271: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');

1267:
1268: l_current_date := p_current_date;
1269:
1270: IF g_debug THEN
1271: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');
1272: hr_utility.trace('> p_resource_id ::'||p_resource_id);
1273: hr_utility.trace('> p_resource_type ::'||p_resource_type);
1274: hr_utility.trace('> l_current_date ::'||l_current_date);
1275: hr_utility.trace('> p_show_existing_timecard ::'||p_show_existing_timecard);

Line 1351: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');

1347: -- look for empty period in the past
1348: l_current_date := SYSDATE;
1349:
1350: IF g_debug THEN
1351: hr_utility.trace('> In hxc_timecard_utilities.get_first_empty_period.');
1352: hr_utility.trace('> p_resource_id ::'||p_resource_id);
1353: hr_utility.trace('> p_resource_type ::'||p_resource_type);
1354: hr_utility.trace('> l_current_date ::'||l_current_date);
1355: hr_utility.trace('> p_show_existing_timecard ::'||p_show_existing_timecard);

Line 1503: hr_utility.trace('> In hxc_timecard_utilities.get_period_list.');

1499: l_current_date := p_current_date;
1500:
1501:
1502: IF g_debug THEN
1503: hr_utility.trace('> In hxc_timecard_utilities.get_period_list.');
1504: hr_utility.trace('> p_resource_id ::'||p_resource_id);
1505: hr_utility.trace('> p_resource_type ::'||p_resource_type);
1506: hr_utility.trace('> l_current_date ::'||l_current_date);
1507: hr_utility.trace('> p_show_existing_timecard ::'||p_show_existing_timecard);

Line 1977: hr_utility.trace('> In hxc_timecard_utilities.get_time_periods');

1973: BEGIN
1974: g_debug := hr_utility.debug_enabled;
1975:
1976: IF g_debug THEN
1977: hr_utility.trace('> In hxc_timecard_utilities.get_time_periods');
1978: END IF;
1979:
1980: IF g_debug THEN
1981: hr_utility.trace('> p_resource_id ::'||p_resource_id);

Line 2043: hr_utility.trace('> In hxc_timecard_utilities.get_time_periods AFTER CALL TO get_period_list');

2039: ,p_periods => p_periods
2040: );
2041:
2042: IF g_debug THEN
2043: hr_utility.trace('> In hxc_timecard_utilities.get_time_periods AFTER CALL TO get_period_list');
2044: hr_utility.trace('> p_periods'||p_periods);
2045: END IF;
2046:
2047: IF g_debug THEN

Line 2918: ,hxc_timecard_summary hts

2914: , fad.automatically_added_flag
2915: , fad.category_id
2916: FROM hxc_time_building_blocks app
2917: ,hxc_tc_ap_links htal
2918: ,hxc_timecard_summary hts
2919: ,fnd_attached_documents fad
2920: WHERE app.scope = 'APPLICATION_PERIOD'
2921: AND app.date_to = hr_general.end_of_time
2922: AND app.resource_id = to_number(p_resource_id)

Line 2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'

2928: AND htal.timecard_id = hts.timecard_id
2929: AND hts.resource_id = to_number(fad.pk1_value)
2930: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
2931: AND regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
2932: AND fad.entity_name = 'HXC_TIMECARD_SUMMARY'
2933: ;
2934:
2935: TYPE num_tab IS TABLE OF NUMBER;
2936: TYPE varchar_tab IS TABLE OF VARCHAR2(200);

Line 2962: hr_utility.trace('In hxc_timecard_utilities.copy_attachments_to_ap');

2958: BEGIN
2959:
2960: IF g_debug
2961: THEN
2962: hr_utility.trace('In hxc_timecard_utilities.copy_attachments_to_ap');
2963: hr_utility.trace('Timecard Attachments Enabled ::'||
2964: NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N'));
2965: END IF;
2966:

Line 2964: NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N'));

2960: IF g_debug
2961: THEN
2962: hr_utility.trace('In hxc_timecard_utilities.copy_attachments_to_ap');
2963: hr_utility.trace('Timecard Attachments Enabled ::'||
2964: NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N'));
2965: END IF;
2966:
2967: IF (NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N') = 'N') THEN
2968: RETURN;

Line 2967: IF (NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N') = 'N') THEN

2963: hr_utility.trace('Timecard Attachments Enabled ::'||
2964: NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N'));
2965: END IF;
2966:
2967: IF (NVL(fnd_profile.value('HXC_TIMECARD_ATTACHMENT_ENABLED'), 'N') = 'N') THEN
2968: RETURN;
2969: END IF;
2970:
2971:

Line 3009: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'

3005: hr_utility.trace('call to delete approval period attachments...fnd_attached_documents2_pkg.delete_attachments');
3006: END IF;
3007:
3008: fnd_attached_documents2_pkg.delete_attachments
3009: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'
3010: , X_pk1_value => l_app_resource_id_tab(l_app_resource_id_tab.FIRST)
3011: , X_pk2_value => l_app_start_date_tab(l_app_resource_id_tab.FIRST)
3012: , X_pk3_value => l_app_end_date_tab(l_app_resource_id_tab.FIRST)
3013: , X_delete_document_flag => 'Y'

Line 3050: END hxc_timecard_utilities;

3046: END copy_attachments_to_ap;
3047:
3048:
3049:
3050: END hxc_timecard_utilities;