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_FIND_NOTIFY_APRS_PKG dependencies on HXC_APPROVAL_COMPS

Line 49: FROM HXC_APPROVAL_COMPS apc,

45: SELECT apc.approval_mechanism,
46: apc.approval_mechanism_id,
47: apc.wf_item_type,
48: apc.wf_name
49: FROM HXC_APPROVAL_COMPS apc,
50: HXC_APPROVAL_STYLES aps,
51: HXC_TIME_BUILDING_BLOCKS htb_time,
52: hxc_time_building_blocks htb_appln
53: WHERE htb_appln.TIME_BUILDING_BLOCK_ID = b_ap_bbid AND

Line 759: ,hxc_approval_comps apc

755: apc.approval_mechanism_id,
756: apc.wf_item_type,
757: apc.wf_name
758: FROM hxc_app_period_summary apsum
759: ,hxc_approval_comps apc
760: WHERE apsum.application_period_id = p_ap_bb_id
761: AND apsum.application_period_ovn = p_ap_bb_ovn
762: AND apsum.approval_comp_id = apc.approval_comp_id
763:

Line 773: FROM hxc_approval_comps apc2

769: -- Modified the condition this way so that it connect back to the parent_comp_id
770:
771: AND ( apsum.time_recipient_id = apc.time_recipient_id
772: OR ( EXISTS ( SELECT 1
773: FROM hxc_approval_comps apc2
774: WHERE apc2.approval_comp_id = apc.parent_comp_id
775: AND apc2.approval_mechanism = 'ENTRY_LEVEL_APPROVAL'
776: AND apc2.time_recipient_id = apsum.time_recipient_id
777: )

Line 791: ,hxc_approval_comps apc

787: apc.approval_mechanism_id,
788: apc.wf_item_type,
789: apc.wf_name
790: FROM hxc_app_period_summary apsum
791: ,hxc_approval_comps apc
792: ,hxc_tc_ap_links tcl
793: ,hxc_time_building_blocks tbb
794: WHERE apsum.application_period_id = p_application_period_id
795: AND apsum.application_period_ovn = p_application_period_ovn

Line 823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;

819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;
827: begin

Line 824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;

820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;
827: begin
828: g_debug:=hr_utility.debug_enabled;

Line 825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;

821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;
827: begin
828: g_debug:=hr_utility.debug_enabled;
829: --sb_msgs_pkg.begin_call(l_proc);

Line 826: l_wf_name hxc_approval_comps.wf_name%TYPE;

822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;
827: begin
828: g_debug:=hr_utility.debug_enabled;
829: --sb_msgs_pkg.begin_call(l_proc);
830: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');

Line 2304: FROM hxc_approval_comps

2300: FROM hxc_app_period_summary
2301: WHERE time_category_id = 0
2302: AND APPLICATION_PERIOD_ID = l_ap_bb_id
2303: AND approval_comp_id = (SELECT approval_comp_id
2304: FROM hxc_approval_comps
2305: WHERE approval_style_id =
2306: (SELECT approval_style_id
2307: FROM hxc_approval_styles
2308: WHERE NAME = 'SEEDED_APPL_PA_MGR')

Line 3271: l_formula_id hxc_approval_comps.approval_mechanism_id%type;

3267: l_inputs ff_exec.inputs_t;
3268: l_outputs ff_exec.outputs_t;
3269:
3270: l_effective_date date;
3271: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3272:
3273: -- formula return values
3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;

Line 3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;

3270: l_effective_date date;
3271: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3272:
3273: -- formula return values
3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3276: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3277: l_wf_process_name hxc_approval_comps.wf_name%type;
3278: l_person_id per_all_assignments_f.person_id%type;

Line 3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;

3271: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3272:
3273: -- formula return values
3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3276: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3277: l_wf_process_name hxc_approval_comps.wf_name%type;
3278: l_person_id per_all_assignments_f.person_id%type;
3279: l_formula_status varchar2(10);

Line 3276: l_wf_item_type hxc_approval_comps.wf_item_type%type;

3272:
3273: -- formula return values
3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3276: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3277: l_wf_process_name hxc_approval_comps.wf_name%type;
3278: l_person_id per_all_assignments_f.person_id%type;
3279: l_formula_status varchar2(10);
3280: l_formula_message varchar2(2000);

Line 3277: l_wf_process_name hxc_approval_comps.wf_name%type;

3273: -- formula return values
3274: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3275: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3276: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3277: l_wf_process_name hxc_approval_comps.wf_name%type;
3278: l_person_id per_all_assignments_f.person_id%type;
3279: l_formula_status varchar2(10);
3280: l_formula_message varchar2(2000);
3281: begin

Line 3626: l_wf_item_type hxc_approval_comps.wf_item_type%type;

3622: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3623: l_item_key number;
3624: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3625: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3626: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3627: l_wf_process_name hxc_approval_comps.wf_name%type;
3628: l_apr_person_id per_all_assignments_f.person_id%type;
3629: l_resource_id per_all_assignments_f.person_id%type;
3630: begin

Line 3627: l_wf_process_name hxc_approval_comps.wf_name%type;

3623: l_item_key number;
3624: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3625: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3626: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3627: l_wf_process_name hxc_approval_comps.wf_name%type;
3628: l_apr_person_id per_all_assignments_f.person_id%type;
3629: l_resource_id per_all_assignments_f.person_id%type;
3630: begin
3631: --sb_msgs_pkg.begin_call(l_proc);