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_GENERIC_RETRIEVAL_PKG dependencies on HXC_GENERIC_RETRIEVAL_UTILS

Line 172: IF (NOT hxc_generic_retrieval_utils.g_resources.EXISTS (p_resource_id)

168: RETURN NUMBER
169: IS
170: BEGIN
171: -- just in case deterministic is not working use EXISTS
172: IF (NOT hxc_generic_retrieval_utils.g_resources.EXISTS (p_resource_id)
173: )
174: THEN
175: hxc_generic_retrieval_utils.g_resources (p_resource_id).resource_id :=
176: p_resource_id;

Line 175: hxc_generic_retrieval_utils.g_resources (p_resource_id).resource_id :=

171: -- just in case deterministic is not working use EXISTS
172: IF (NOT hxc_generic_retrieval_utils.g_resources.EXISTS (p_resource_id)
173: )
174: THEN
175: hxc_generic_retrieval_utils.g_resources (p_resource_id).resource_id :=
176: p_resource_id;
177: -- NOTE: these setting are not the wrong way round
178: -- need a date for when the first LEAST/GREATEST comparison is done, so we always get the
179: -- TC start/stop time

Line 180: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=

176: p_resource_id;
177: -- NOTE: these setting are not the wrong way round
178: -- need a date for when the first LEAST/GREATEST comparison is done, so we always get the
179: -- TC start/stop time
180: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
181: hr_general.end_of_time;
182: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
183: hr_general.start_of_time;
184: END IF;

Line 182: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=

178: -- need a date for when the first LEAST/GREATEST comparison is done, so we always get the
179: -- TC start/stop time
180: hxc_generic_retrieval_utils.g_resources (p_resource_id).start_time :=
181: hr_general.end_of_time;
182: hxc_generic_retrieval_utils.g_resources (p_resource_id).stop_time :=
183: hr_general.start_of_time;
184: END IF;
185:
186: RETURN 1;

Line 1821: l_ret_criteria_clause := hxc_generic_retrieval_utils.get_ret_criteria;

1817:
1818: -- Bug 8888911
1819: l_ind BINARY_INTEGER;
1820: BEGIN
1821: l_ret_criteria_clause := hxc_generic_retrieval_utils.get_ret_criteria;
1822:
1823: -- Bug 9394444
1824: -- For respective processes, if the upgraded process is chosen,
1825: -- use the new queries.

Line 3047: hxc_generic_retrieval_utils.g_resources

3043: l_dummy :=
3044: initialise_g_resource
3045: (p_resource_id => t_bb (l_ind).detail_resource_id
3046: );
3047: hxc_generic_retrieval_utils.g_resources
3048: (t_bb (l_ind).detail_resource_id
3049: ).start_time :=
3050: LEAST
3051: (t_bb (l_ind).time_start_time,

Line 3052: hxc_generic_retrieval_utils.g_resources

3048: (t_bb (l_ind).detail_resource_id
3049: ).start_time :=
3050: LEAST
3051: (t_bb (l_ind).time_start_time,
3052: hxc_generic_retrieval_utils.g_resources
3053: (t_bb (l_ind).detail_resource_id
3054: ).start_time
3055: );
3056: hxc_generic_retrieval_utils.g_resources

Line 3056: hxc_generic_retrieval_utils.g_resources

3052: hxc_generic_retrieval_utils.g_resources
3053: (t_bb (l_ind).detail_resource_id
3054: ).start_time
3055: );
3056: hxc_generic_retrieval_utils.g_resources
3057: (t_bb (l_ind).detail_resource_id
3058: ).stop_time :=
3059: GREATEST
3060: (t_bb (l_ind).time_stop_time,

Line 3061: hxc_generic_retrieval_utils.g_resources

3057: (t_bb (l_ind).detail_resource_id
3058: ).stop_time :=
3059: GREATEST
3060: (t_bb (l_ind).time_stop_time,
3061: hxc_generic_retrieval_utils.g_resources
3062: (t_bb (l_ind).detail_resource_id
3063: ).stop_time
3064: );
3065: l_ind := l_ind + 1;

Line 4442: l_prefs hxc_generic_retrieval_utils.t_pref;

4438: l_bld_blk_info_index PLS_INTEGER;
4439: e_no_timecards EXCEPTION;
4440: e_no_bld_blks_to_transfer EXCEPTION;
4441: -- used in incremental when we fetched but no ovn diffs
4442: l_prefs hxc_generic_retrieval_utils.t_pref;
4443: l_ret_rules hxc_generic_retrieval_utils.t_ret_rule;
4444: l_rtr_outcomes hxc_generic_retrieval_utils.t_rtr_outcome;
4445: l_errors hxc_generic_retrieval_utils.t_errors;
4446: l_timecard_retrieve BOOLEAN;

Line 4443: l_ret_rules hxc_generic_retrieval_utils.t_ret_rule;

4439: e_no_timecards EXCEPTION;
4440: e_no_bld_blks_to_transfer EXCEPTION;
4441: -- used in incremental when we fetched but no ovn diffs
4442: l_prefs hxc_generic_retrieval_utils.t_pref;
4443: l_ret_rules hxc_generic_retrieval_utils.t_ret_rule;
4444: l_rtr_outcomes hxc_generic_retrieval_utils.t_rtr_outcome;
4445: l_errors hxc_generic_retrieval_utils.t_errors;
4446: l_timecard_retrieve BOOLEAN;
4447: l_day_retrieve BOOLEAN;

Line 4444: l_rtr_outcomes hxc_generic_retrieval_utils.t_rtr_outcome;

4440: e_no_bld_blks_to_transfer EXCEPTION;
4441: -- used in incremental when we fetched but no ovn diffs
4442: l_prefs hxc_generic_retrieval_utils.t_pref;
4443: l_ret_rules hxc_generic_retrieval_utils.t_ret_rule;
4444: l_rtr_outcomes hxc_generic_retrieval_utils.t_rtr_outcome;
4445: l_errors hxc_generic_retrieval_utils.t_errors;
4446: l_timecard_retrieve BOOLEAN;
4447: l_day_retrieve BOOLEAN;
4448: l_error_flag BOOLEAN;

Line 4445: l_errors hxc_generic_retrieval_utils.t_errors;

4441: -- used in incremental when we fetched but no ovn diffs
4442: l_prefs hxc_generic_retrieval_utils.t_pref;
4443: l_ret_rules hxc_generic_retrieval_utils.t_ret_rule;
4444: l_rtr_outcomes hxc_generic_retrieval_utils.t_rtr_outcome;
4445: l_errors hxc_generic_retrieval_utils.t_errors;
4446: l_timecard_retrieve BOOLEAN;
4447: l_day_retrieve BOOLEAN;
4448: l_error_flag BOOLEAN;
4449: l_tc_locked BOOLEAN;

Line 4529: p_errors IN OUT NOCOPY hxc_generic_retrieval_utils.t_errors,

4525: p_scope VARCHAR2,
4526: p_copied IN OUT NOCOPY VARCHAR2,
4527: p_cnt INTEGER,
4528: p_copy_old VARCHAR2,
4529: p_errors IN OUT NOCOPY hxc_generic_retrieval_utils.t_errors,
4530: p_error BOOLEAN
4531: )
4532: IS
4533: l_bld_blk_index PLS_INTEGER;

Line 5563: IF NOT (hxc_generic_retrieval_utils.g_resources.EXISTS

5559: THEN
5560: -- need to populate resources table since max_ovn was not called
5561: FOR x IN t_bb.FIRST .. t_bb.LAST
5562: LOOP
5563: IF NOT (hxc_generic_retrieval_utils.g_resources.EXISTS
5564: (t_bb (x).detail_resource_id
5565: )
5566: )
5567: THEN

Line 5568: hxc_generic_retrieval_utils.g_resources

5564: (t_bb (x).detail_resource_id
5565: )
5566: )
5567: THEN
5568: hxc_generic_retrieval_utils.g_resources
5569: (t_bb (x).detail_resource_id
5570: ).resource_id :=
5571: t_bb (x).detail_resource_id;
5572: hxc_generic_retrieval_utils.g_resources

Line 5572: hxc_generic_retrieval_utils.g_resources

5568: hxc_generic_retrieval_utils.g_resources
5569: (t_bb (x).detail_resource_id
5570: ).resource_id :=
5571: t_bb (x).detail_resource_id;
5572: hxc_generic_retrieval_utils.g_resources
5573: (t_bb (x).detail_resource_id
5574: ).start_time :=
5575: hr_general.end_of_time;
5576: hxc_generic_retrieval_utils.g_resources

Line 5576: hxc_generic_retrieval_utils.g_resources

5572: hxc_generic_retrieval_utils.g_resources
5573: (t_bb (x).detail_resource_id
5574: ).start_time :=
5575: hr_general.end_of_time;
5576: hxc_generic_retrieval_utils.g_resources
5577: (t_bb (x).detail_resource_id
5578: ).stop_time :=
5579: hr_general.start_of_time;
5580: END IF;

Line 5599: hxc_generic_retrieval_utils.parse_resources

5595:
5596: l_prefs.DELETE;
5597: l_ret_rules.DELETE;
5598: l_rtr_outcomes.DELETE;
5599: hxc_generic_retrieval_utils.parse_resources
5600: (p_process_id => g_retrieval_process_id,
5601: p_ret_tr_id => g_retrieval_tr_id,
5602: p_prefs => l_prefs,
5603: p_ret_rules => l_ret_rules,

Line 5613: l_count := hxc_generic_retrieval_utils.g_resources.COUNT;

5609: THEN
5610: hr_utility.TRACE (' *********** - GLOBAL TABLE INFO ************ ');
5611: END IF;
5612:
5613: l_count := hxc_generic_retrieval_utils.g_resources.COUNT;
5614:
5615: IF g_debug
5616: THEN
5617: hr_utility.TRACE ('Resources : ' || TO_CHAR (l_count));

Line 5751: AND (hxc_generic_retrieval_utils.chk_otm_pref( t_bb(cnt).detail_resource_id,

5747: -- Check preferences before adjusting the deleted entries.
5748:
5749: IF ( g_params.p_process IN ('BEE Retrieval Process',
5750: 'Apply Schedule Rules') )
5751: AND (hxc_generic_retrieval_utils.chk_otm_pref( t_bb(cnt).detail_resource_id,
5752: t_bb(cnt).day_start_time,
5753: g_retrieval_process_id))
5754: AND (hxc_generic_retrieval_utils.chk_need_adj( t_bb (cnt).time_bb_id,
5755: t_bb (cnt).time_ovn,

Line 5754: AND (hxc_generic_retrieval_utils.chk_need_adj( t_bb (cnt).time_bb_id,

5750: 'Apply Schedule Rules') )
5751: AND (hxc_generic_retrieval_utils.chk_otm_pref( t_bb(cnt).detail_resource_id,
5752: t_bb(cnt).day_start_time,
5753: g_retrieval_process_id))
5754: AND (hxc_generic_retrieval_utils.chk_need_adj( t_bb (cnt).time_bb_id,
5755: t_bb (cnt).time_ovn,
5756: t_bb (cnt).detail_resource_id,
5757: t_bb (cnt).day_start_time,
5758: t_bb (cnt).detail_bb_id,

Line 5802: hxc_generic_retrieval_utils.chk_retrieve

5798: -- Absences ends
5799:
5800:
5801: hr_utility.TRACE ('about to call chk retrieve');
5802: hxc_generic_retrieval_utils.chk_retrieve
5803: (p_resource_id => t_bb (cnt).detail_resource_id,
5804: p_bb_status => t_bb (cnt).detail_approval_status,
5805: p_bb_deleted => t_bb (cnt).time_deleted,
5806: p_bb_start_time => t_bb (cnt).day_start_time,

Line 6068: hxc_generic_retrieval_utils.g_resources.DELETE;

6064: END IF;
6065: EXCEPTION
6066: WHEN e_no_timecards
6067: THEN
6068: hxc_generic_retrieval_utils.g_resources.DELETE;
6069:
6070: IF (NOT hxc_generic_retrieval_pkg.g_in_loop)
6071: THEN
6072: audit_transaction

Line 6090: hxc_generic_retrieval_utils.g_resources.DELETE;

6086: fnd_message.raise_error;
6087: WHEN e_no_bld_blks_to_transfer
6088: THEN
6089: t_bb.DELETE;
6090: hxc_generic_retrieval_utils.g_resources.DELETE;
6091:
6092: IF (NOT hxc_generic_retrieval_pkg.g_in_loop)
6093: THEN
6094: audit_transaction

Line 7882: hxc_generic_retrieval_utils.g_resources.DELETE;

7878: hxc_generic_retrieval_pkg.t_old_detail_rec_lines.DELETE;
7879: hxc_generic_retrieval_pkg.g_old_bb_ids.DELETE;
7880: hxc_generic_retrieval_pkg.t_bb.DELETE;
7881: hxc_generic_retrieval_pkg.g_no_timecards := TRUE;
7882: hxc_generic_retrieval_utils.g_resources.DELETE;
7883:
7884: -- Bug 7595581
7885: -- Retrieval Log
7886:

Line 8305: hxc_generic_retrieval_utils.RECOVERY

8301: FROM hxc_retrieval_processes rp
8302: WHERE rp.NAME = 'BEE Retrieval Process';
8303:
8304: -- check to see that the last retrieval completed normally
8305: hxc_generic_retrieval_utils.RECOVERY
8306: (p_process_id => g_retrieval_process_id,
8307: p_process => p_process
8308: );
8309:

Line 8322: hxc_generic_retrieval_utils.RECOVERY

8318: END IF;
8319:
8320: IF (g_params.retrieval_options = 'BOTH')
8321: THEN
8322: hxc_generic_retrieval_utils.RECOVERY
8323: (p_process_id => l_ret_id,
8324: p_process => 'BEE Retrieval Process'
8325: );
8326:

Line 8344: hxc_generic_retrieval_utils.RECOVERY

8340: -- check the HXC_RETRIEVAL_OPTIONS profile value
8341: IF (g_params.retrieval_options = 'BEE')
8342: THEN
8343: -- Apply Schedule Rules was not called
8344: hxc_generic_retrieval_utils.RECOVERY
8345: (p_process_id => g_retrieval_process_id,
8346: p_process => p_process
8347: );
8348:

Line 8364: hxc_generic_retrieval_utils.RECOVERY

8360: -- started and cleaned up if appropriate
8361: NULL;
8362: END IF;
8363: ELSE
8364: hxc_generic_retrieval_utils.RECOVERY
8365: (p_process_id => g_retrieval_process_id,
8366: p_process => p_process
8367: );
8368:

Line 8831: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))

8827:
8828:
8829:
8830:
8831: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))
8832: THEN
8833: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8834: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
8835: fnd_message.set_token ('STEP', ': Process Terminated');

Line 10124: IF (hxc_generic_retrieval_utils.chk_terminated

10120: hr_utility.set_location ('Processing ' || l_proc, 250);
10121: END IF;
10122: END IF;
10123:
10124: IF (hxc_generic_retrieval_utils.chk_terminated
10125: (fnd_profile.VALUE ('CONC_REQUEST_ID')
10126: )
10127: )
10128: THEN