APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 380: from hxc_time_attributes a,

376: ,a.object_version_number
377: ,'N' NEW
378: ,'N' CHANGED
379: ,'N' PROCESS
380: from hxc_time_attributes a,
381: hxc_time_attribute_usages au,
382: hxc_bld_blk_info_types bbit
383: where au.time_building_block_id = p_detail_id
384: and au.time_building_block_ovn = p_detail_ovn

Line 959: RETURN hxc_time_attributes_api.timecard

955: END get_person_id;
956:
957:
958: FUNCTION get_empty_attribute
959: RETURN hxc_time_attributes_api.timecard
960: IS
961: t_attributes hxc_time_attributes_api.timecard;
962:
963: BEGIN

Line 961: t_attributes hxc_time_attributes_api.timecard;

957:
958: FUNCTION get_empty_attribute
959: RETURN hxc_time_attributes_api.timecard
960: IS
961: t_attributes hxc_time_attributes_api.timecard;
962:
963: BEGIN
964: t_attributes.delete;
965: t_attributes(1).attribute_name := NULL;

Line 1102: t_attributes hxc_time_attributes_api.timecard;

1098: funcmode IN varchar2,
1099: result IN OUT NOCOPY varchar2
1100: )
1101: IS
1102: t_attributes hxc_time_attributes_api.timecard;
1103: l_attribute approval_attribute;
1104: l_approver varchar2(150);
1105: l_user_name varchar2(150);
1106: l_appl_period_bb_id number;

Line 1401: t_attributes hxc_time_attributes_api.timecard;

1397: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1398: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1399: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1400: l_attribute approval_attribute;
1401: t_attributes hxc_time_attributes_api.timecard;
1402: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
1403: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
1404:
1405: l_proc VARCHAR2(150) := 'create_next_period';

Line 2128: t_attributes hxc_time_attributes_api.timecard;

2124: l_first_app_period BOOLEAN;
2125: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
2126: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
2127: l_creation_date DATE;
2128: t_attributes hxc_time_attributes_api.timecard;
2129: l_tc_ap_link_exists VARCHAR2(50) := NULL;
2130: l_app_exists BOOLEAN;
2131: l_removed_blocks block_table;
2132:

Line 2968: t_attributes hxc_time_attributes_api.timecard;

2964: l_appl_period_bb_ovn number;
2965: l_period_start_date date;
2966: l_period_end_date date;
2967: l_override_allowed boolean;
2968: t_attributes hxc_time_attributes_api.timecard;
2969: --
2970: l_all_apps varchar2(1000);
2971: l_cnt number;
2972: --

Line 4852: from hxc_time_attributes

4848: cursor csr_get_attributes(p_app_bb_id in number,
4849: p_app_bb_ovn in number) is
4850: select attribute1, attribute2,
4851: attribute8, attribute9
4852: from hxc_time_attributes
4853: where time_attribute_id = (select min(time_attribute_id)
4854: from hxc_time_attribute_usages
4855: where time_building_block_id = p_app_bb_id
4856: and time_building_block_ovn = p_app_bb_ovn);

Line 4859: t_attributes hxc_time_attributes_api.timecard;

4855: where time_building_block_id = p_app_bb_id
4856: and time_building_block_ovn = p_app_bb_ovn);
4857: */
4858: --
4859: t_attributes hxc_time_attributes_api.timecard;
4860: l_appl_period_bb_id number := p_app_bb_id;
4861: l_appl_period_bb_ovn number := p_app_bb_ovn;
4862: l_approver_id number := p_approver_id;
4863: -- l_time_recipient varchar2(150);

Line 4897: update hxc_time_attributes

4893: end if;
4894: -- Perf Rep Fix - SQL ID :3170802
4895: -- Added attribute_category = APPROVAL to the where clause.
4896:
4897: update hxc_time_attributes
4898: set attribute4 = l_notified_status,
4899: attribute5 = l_approved_time,
4900: attribute6 = l_approval_comment,
4901: attribute7 = l_approved_status,

Line 6316: from hxc_time_attributes ta,

6312: l_return hxc_time_building_blocks.resource_id%TYPE;
6313: --
6314: cursor csr_get_override_id is
6315: select to_number(ta.attribute10)
6316: from hxc_time_attributes ta,
6317: hxc_time_attribute_usages tau,
6318: hxc_time_building_blocks tbb
6319: where tbb.time_building_block_id = p_timecard_bb_id
6320: and tbb.object_version_number = p_timecard_ovn