APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 257: from hxc_time_attributes a,

253: ,a.object_version_number
254: ,'N' NEW
255: ,'N' CHANGED
256: ,'N' PROCESS
257: from hxc_time_attributes a,
258: hxc_time_attribute_usages au,
259: hxc_bld_blk_info_types bbit
260: where au.time_building_block_id = p_detail_id
261: and au.time_building_block_ovn = p_detail_ovn

Line 807: RETURN hxc_time_attributes_api.timecard

803: END get_person_id;
804:
805:
806: FUNCTION get_empty_attribute
807: RETURN hxc_time_attributes_api.timecard
808: IS
809: t_attributes hxc_time_attributes_api.timecard;
810:
811: BEGIN

Line 809: t_attributes hxc_time_attributes_api.timecard;

805:
806: FUNCTION get_empty_attribute
807: RETURN hxc_time_attributes_api.timecard
808: IS
809: t_attributes hxc_time_attributes_api.timecard;
810:
811: BEGIN
812: t_attributes.delete;
813: t_attributes(1).attribute_name := NULL;

Line 935: t_attributes hxc_time_attributes_api.timecard;

931: funcmode IN varchar2,
932: result IN OUT NOCOPY varchar2
933: )
934: IS
935: t_attributes hxc_time_attributes_api.timecard;
936: l_attribute approval_attribute;
937: l_approver varchar2(150);
938: l_user_name varchar2(150);
939: l_appl_period_bb_id number;

Line 1222: t_attributes hxc_time_attributes_api.timecard;

1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;
1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
1224: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
1225:
1226: l_proc VARCHAR2(150) := 'create_next_period';

Line 1949: t_attributes hxc_time_attributes_api.timecard;

1945: l_first_app_period BOOLEAN;
1946: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
1947: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
1948: l_creation_date DATE;
1949: t_attributes hxc_time_attributes_api.timecard;
1950: l_tc_ap_link_exists VARCHAR2(50) := NULL;
1951: l_app_exists BOOLEAN;
1952: l_removed_blocks block_table;
1953:

Line 2620: t_attributes hxc_time_attributes_api.timecard;

2616: l_appl_period_bb_ovn number;
2617: l_period_start_date date;
2618: l_period_end_date date;
2619: l_override_allowed boolean;
2620: t_attributes hxc_time_attributes_api.timecard;
2621: --
2622: l_all_apps varchar2(1000);
2623: l_cnt number;
2624: --

Line 4200: from hxc_time_attributes

4196: cursor csr_get_attributes(p_app_bb_id in number,
4197: p_app_bb_ovn in number) is
4198: select attribute1, attribute2,
4199: attribute8, attribute9
4200: from hxc_time_attributes
4201: where time_attribute_id = (select min(time_attribute_id)
4202: from hxc_time_attribute_usages
4203: where time_building_block_id = p_app_bb_id
4204: and time_building_block_ovn = p_app_bb_ovn);

Line 4207: t_attributes hxc_time_attributes_api.timecard;

4203: where time_building_block_id = p_app_bb_id
4204: and time_building_block_ovn = p_app_bb_ovn);
4205: */
4206: --
4207: t_attributes hxc_time_attributes_api.timecard;
4208: l_appl_period_bb_id number := p_app_bb_id;
4209: l_appl_period_bb_ovn number := p_app_bb_ovn;
4210: l_approver_id number := p_approver_id;
4211: -- l_time_recipient varchar2(150);

Line 4245: update hxc_time_attributes

4241: end if;
4242: -- Perf Rep Fix - SQL ID :3170802
4243: -- Added attribute_category = APPROVAL to the where clause.
4244:
4245: update hxc_time_attributes
4246: set attribute4 = l_notified_status,
4247: attribute5 = l_approved_time,
4248: attribute6 = l_approval_comment,
4249: attribute7 = l_approved_status,

Line 5629: from hxc_time_attributes ta,

5625: l_return hxc_time_building_blocks.resource_id%TYPE;
5626: --
5627: cursor csr_get_override_id is
5628: select to_number(ta.attribute10)
5629: from hxc_time_attributes ta,
5630: hxc_time_attribute_usages tau,
5631: hxc_time_building_blocks tbb
5632: where tbb.time_building_block_id = p_timecard_bb_id
5633: and tbb.object_version_number = p_timecard_ovn