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

Line 14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE

10:
11: g_trace VARCHAR2(2000);
12:
13: TYPE approval_comp IS RECORD(
14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE
15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE

Line 15: ,object_version_number hxc_approval_comps.object_version_number%TYPE

11: g_trace VARCHAR2(2000);
12:
13: TYPE approval_comp IS RECORD(
14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE
15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE

Line 16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE

12:
13: TYPE approval_comp IS RECORD(
14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE
15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE

Line 17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE

13: TYPE approval_comp IS RECORD(
14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE
15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE
21: ,approval_order hxc_approval_comps.approval_order%TYPE

Line 18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE

14: approval_comp_id hxc_approval_comps.approval_comp_id%TYPE
15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE
21: ,approval_order hxc_approval_comps.approval_order%TYPE
22: );

Line 19: ,wf_name hxc_approval_comps.wf_name%TYPE

15: ,object_version_number hxc_approval_comps.object_version_number%TYPE
16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE
21: ,approval_order hxc_approval_comps.approval_order%TYPE
22: );
23:

Line 20: ,time_category_id hxc_approval_comps.time_category_id%TYPE

16: ,approval_mechanism hxc_approval_comps.approval_mechanism%TYPE
17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE
21: ,approval_order hxc_approval_comps.approval_order%TYPE
22: );
23:
24:

Line 21: ,approval_order hxc_approval_comps.approval_order%TYPE

17: ,approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE
18: ,wf_item_type hxc_approval_comps.wf_item_type%TYPE
19: ,wf_name hxc_approval_comps.wf_name%TYPE
20: ,time_category_id hxc_approval_comps.time_category_id%TYPE
21: ,approval_order hxc_approval_comps.approval_order%TYPE
22: );
23:
24:
25: TYPE approval_attribute is RECORD(

Line 1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1865: ,p_approval_comp IN approval_comp
1866: ,p_tc_resubmitted IN VARCHAR2
1867: -- ,p_first IN VARCHAR2
1868: ,p_detail_blocks IN OUT NOCOPY block_table

Line 1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
1881: )
1882: IS

Line 1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE

1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
1881: )
1882: IS
1883: SELECT application_period_id
1884: ,application_period_ovn

Line 2655: FROM hxc_approval_comps

2651: ,wf_item_type
2652: ,wf_name
2653: ,time_category_id
2654: ,approval_order
2655: FROM hxc_approval_comps
2656: WHERE approval_style_id = p_approval_style
2657: AND time_recipient_id = p_time_recipient;
2658:
2659:

Line 2661: p_comp_id hxc_approval_comps.approval_comp_id%TYPE

2657: AND time_recipient_id = p_time_recipient;
2658:
2659:
2660: CURSOR c_ela_comps(
2661: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
2662: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
2663: )
2664: IS
2665: SELECT approval_comp_id

Line 2662: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE

2658:
2659:
2660: CURSOR c_ela_comps(
2661: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
2662: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
2663: )
2664: IS
2665: SELECT approval_comp_id
2666: ,object_version_number

Line 2673: FROM hxc_approval_comps

2669: ,wf_item_type
2670: ,wf_name
2671: ,time_category_id
2672: ,approval_order
2673: FROM hxc_approval_comps
2674: WHERE parent_comp_id = p_comp_id
2675: AND parent_comp_ovn = p_comp_ovn
2676: ORDER BY time_category_id desc;
2677:

Line 3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;

3462: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';
3463: l_last_updated_by number;
3464: l_process varchar2(1) := 'Y';
3465:
3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
3467: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3468: l_category_sequence hxc_approval_comps.approval_order%TYPE;
3469: l_approval_item_key wf_items.item_key%type;
3470: l_is_blank varchar2(1) := NULL;

Line 3468: l_category_sequence hxc_approval_comps.approval_order%TYPE;

3464: l_process varchar2(1) := 'Y';
3465:
3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
3467: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3468: l_category_sequence hxc_approval_comps.approval_order%TYPE;
3469: l_approval_item_key wf_items.item_key%type;
3470: l_is_blank varchar2(1) := NULL;
3471:
3472: BEGIN

Line 4322: from hxc_approval_comps hac,

4318:
4319: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
4320: is
4321: select hac.approval_comp_id
4322: from hxc_approval_comps hac,
4323: hxc_approval_styles has,
4324: hxc_time_building_blocks htb
4325: where htb.time_building_block_id =p_bb_id
4326: and htb.object_version_number = p_bb_ovn