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 2043: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

2039: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
2040: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
2041: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
2042: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
2043: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2044: ,p_approval_comp IN approval_comp
2045: ,p_tc_resubmitted IN VARCHAR2
2046: -- ,p_first IN VARCHAR2
2047: ,p_detail_blocks IN OUT NOCOPY block_table

Line 2057: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

2053: p_resource_id hxc_time_building_blocks.resource_id%TYPE
2054: ,p_start_time hxc_time_building_blocks.start_time%TYPE
2055: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
2056: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
2057: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2058: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
2059: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
2060: )
2061: IS

Line 2059: ,p_category_sequence hxc_approval_comps.approval_order%TYPE

2055: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
2056: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
2057: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
2058: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
2059: ,p_category_sequence hxc_approval_comps.approval_order%TYPE
2060: )
2061: IS
2062: SELECT application_period_id
2063: ,application_period_ovn

Line 3003: FROM hxc_approval_comps

2999: ,wf_item_type
3000: ,wf_name
3001: ,time_category_id
3002: ,approval_order
3003: FROM hxc_approval_comps
3004: WHERE approval_style_id = p_approval_style
3005: AND time_recipient_id = p_time_recipient;
3006:
3007:

Line 3009: p_comp_id hxc_approval_comps.approval_comp_id%TYPE

3005: AND time_recipient_id = p_time_recipient;
3006:
3007:
3008: CURSOR c_ela_comps(
3009: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
3010: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
3011: )
3012: IS
3013: SELECT approval_comp_id

Line 3010: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE

3006:
3007:
3008: CURSOR c_ela_comps(
3009: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
3010: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
3011: )
3012: IS
3013: SELECT approval_comp_id
3014: ,object_version_number

Line 3021: FROM hxc_approval_comps

3017: ,wf_item_type
3018: ,wf_name
3019: ,time_category_id
3020: ,approval_order
3021: FROM hxc_approval_comps
3022: WHERE parent_comp_id = p_comp_id
3023: AND parent_comp_ovn = p_comp_ovn
3024: ORDER BY time_category_id desc;
3025:

Line 3030: p_comp_id hxc_approval_comps.approval_comp_id%TYPE

3026:
3027: -- Bug 13817976
3028: -- Modified cursor to pick up only a subset of time categories.
3029: CURSOR c_ela_comps2(
3030: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
3031: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
3032: )
3033: IS
3034: SELECT approval_comp_id

Line 3031: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE

3027: -- Bug 13817976
3028: -- Modified cursor to pick up only a subset of time categories.
3029: CURSOR c_ela_comps2(
3030: p_comp_id hxc_approval_comps.approval_comp_id%TYPE
3031: ,p_comp_ovn hxc_approval_comps.object_version_number%TYPE
3032: )
3033: IS
3034: SELECT approval_comp_id
3035: ,object_version_number

Line 3042: FROM hxc_approval_comps

3038: ,wf_item_type
3039: ,wf_name
3040: ,time_category_id
3041: ,approval_order
3042: FROM hxc_approval_comps
3043: WHERE parent_comp_id = p_comp_id
3044: AND parent_comp_ovn = p_comp_ovn
3045: AND ( time_category_id = 0
3046: OR time_category_id IN ( SELECT detail_id

Line 4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;

4093: l_process_name varchar2(30);
4094: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';
4095: l_last_updated_by number;
4096:
4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
4098: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4099: l_category_sequence hxc_approval_comps.approval_order%TYPE;
4100: l_approval_item_key wf_items.item_key%type;
4101: l_is_blank varchar2(1) := NULL;

Line 4099: l_category_sequence hxc_approval_comps.approval_order%TYPE;

4095: l_last_updated_by number;
4096:
4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
4098: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4099: l_category_sequence hxc_approval_comps.approval_order%TYPE;
4100: l_approval_item_key wf_items.item_key%type;
4101: l_is_blank varchar2(1) := NULL;
4102: l_process varchar2(1) := 'Y';
4103:

Line 5009: from hxc_approval_comps hac,

5005:
5006: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
5007: is
5008: select hac.approval_comp_id
5009: from hxc_approval_comps hac,
5010: hxc_approval_styles has,
5011: hxc_time_building_blocks htb
5012: where htb.time_building_block_id =p_bb_id
5013: and htb.object_version_number = p_bb_ovn