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: ,hxc_approval_comps apc

769: apc.approval_mechanism_id,
770: apc.wf_item_type,
771: apc.wf_name
772: FROM hxc_app_period_summary apsum
773: ,hxc_approval_comps apc
774: ,hxc_tc_ap_links tcl
775: ,hxc_time_building_blocks tbb
776: WHERE apsum.application_period_id = p_application_period_id
777: AND apsum.application_period_ovn = p_application_period_ovn

Line 805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;

801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
808: l_wf_name hxc_approval_comps.wf_name%TYPE;
809: begin

Line 806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;

802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
808: l_wf_name hxc_approval_comps.wf_name%TYPE;
809: begin
810: g_debug:=hr_utility.debug_enabled;

Line 807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;

803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
808: l_wf_name hxc_approval_comps.wf_name%TYPE;
809: begin
810: g_debug:=hr_utility.debug_enabled;
811: --sb_msgs_pkg.begin_call(l_proc);

Line 808: l_wf_name hxc_approval_comps.wf_name%TYPE;

804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
808: l_wf_name hxc_approval_comps.wf_name%TYPE;
809: begin
810: g_debug:=hr_utility.debug_enabled;
811: --sb_msgs_pkg.begin_call(l_proc);
812: --sb_msgs_pkg.trace('p_funcmode>' || p_funcmode || '<');

Line 2163: FROM hxc_approval_comps

2159: FROM hxc_app_period_summary
2160: WHERE time_category_id = 0
2161: AND APPLICATION_PERIOD_ID = l_ap_bb_id
2162: AND approval_comp_id = (SELECT approval_comp_id
2163: FROM hxc_approval_comps
2164: WHERE approval_style_id =
2165: (SELECT approval_style_id
2166: FROM hxc_approval_styles
2167: WHERE NAME = 'SEEDED_APPL_PA_MGR')

Line 3070: l_formula_id hxc_approval_comps.approval_mechanism_id%type;

3066: l_inputs ff_exec.inputs_t;
3067: l_outputs ff_exec.outputs_t;
3068:
3069: l_effective_date date;
3070: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3071:
3072: -- formula return values
3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;

Line 3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;

3069: l_effective_date date;
3070: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3071:
3072: -- formula return values
3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3076: l_wf_process_name hxc_approval_comps.wf_name%type;
3077: l_person_id per_all_assignments_f.person_id%type;

Line 3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;

3070: l_formula_id hxc_approval_comps.approval_mechanism_id%type;
3071:
3072: -- formula return values
3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3076: l_wf_process_name hxc_approval_comps.wf_name%type;
3077: l_person_id per_all_assignments_f.person_id%type;
3078: l_formula_status varchar2(10);

Line 3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;

3071:
3072: -- formula return values
3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3076: l_wf_process_name hxc_approval_comps.wf_name%type;
3077: l_person_id per_all_assignments_f.person_id%type;
3078: l_formula_status varchar2(10);
3079: l_formula_message varchar2(2000);

Line 3076: l_wf_process_name hxc_approval_comps.wf_name%type;

3072: -- formula return values
3073: l_approval_mechanism hxc_approval_comps.approval_mechanism%type;
3074: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%type;
3075: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3076: l_wf_process_name hxc_approval_comps.wf_name%type;
3077: l_person_id per_all_assignments_f.person_id%type;
3078: l_formula_status varchar2(10);
3079: l_formula_message varchar2(2000);
3080: begin

Line 3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;

3416: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3417: l_item_key number;
3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;
3423: l_resource_id per_all_assignments_f.person_id%type;
3424: begin

Line 3421: l_wf_process_name hxc_approval_comps.wf_name%type;

3417: l_item_key number;
3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;
3423: l_resource_id per_all_assignments_f.person_id%type;
3424: begin
3425: --sb_msgs_pkg.begin_call(l_proc);