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_TER_UPLOAD_PKG dependencies on HXC_DATA_APP_RULE_USAGES

Line 279: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;

275: , p_time_recipient IN VARCHAR2
276: , p_owner IN VARCHAR2
277: , p_custom_mode IN VARCHAR2 ) IS
278:
279: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;
280: l_time_entry_rule_id hxc_data_app_rule_usages.time_entry_rule_id%TYPE;
281: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
282: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
283: l_ovn hxc_deposit_processes.object_version_number%TYPE;

Line 280: l_time_entry_rule_id hxc_data_app_rule_usages.time_entry_rule_id%TYPE;

276: , p_owner IN VARCHAR2
277: , p_custom_mode IN VARCHAR2 ) IS
278:
279: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;
280: l_time_entry_rule_id hxc_data_app_rule_usages.time_entry_rule_id%TYPE;
281: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
282: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
283: l_ovn hxc_deposit_processes.object_version_number%TYPE;
284: l_owner VARCHAR2(6);

Line 338: FROM hxc_data_app_rule_usages

334: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
335: INTO l_data_app_rule_usage_id
336: , l_ovn
337: , l_owner
338: FROM hxc_data_app_rule_usages
339: WHERE time_entry_rule_id = l_time_entry_rule_id
340: AND approval_style_id = l_approval_style_id;
341:
342: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )

Line 345: hxc_data_app_rule_usages_api.update_data_app_rule_usages (

341:
342: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
343: THEN
344:
345: hxc_data_app_rule_usages_api.update_data_app_rule_usages (
346: p_effective_date => sysdate
347: , p_approval_style_id => l_approval_style_id
348: , p_time_entry_rule_id => l_time_entry_rule_id
349: , p_time_recipient_id => l_time_recipient_id

Line 358: hxc_data_app_rule_usages_api.create_data_app_rule_usages (

354:
355: EXCEPTION WHEN NO_DATA_FOUND
356: THEN
357:
358: hxc_data_app_rule_usages_api.create_data_app_rule_usages (
359: p_effective_date => sysdate
360: , p_approval_style_id => l_approval_style_id
361: , p_time_entry_rule_id => l_time_entry_rule_id
362: , p_time_recipient_id => l_time_recipient_id