DBA Data[Home] [Help]

APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 210: p_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info)

206: PROCEDURE get_block_info
207: (p_det_bb_id IN NUMBER,
208: p_det_bb_ovn IN NUMBER,
209: p_get_type IN VARCHAR2,
210: p_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info)
211: AS
212:
213: CURSOR c_time_building_blocks
214: (p_bb_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,

Line 245: l_block hxc_self_service_time_deposit.building_block_info;

241: where tbb1.TIME_BUILDING_BLOCK_ID = p_bb_id
242: and tbb1.OBJECT_VERSION_NUMBER = p_bb_ovn
243: and decode(p_get_type,'NEW',hr_general.end_of_time,tbb1.date_to) = tbb1.date_to;
244:
245: l_block hxc_self_service_time_deposit.building_block_info;
246: l_block_index NUMBER;
247:
248: BEGIN
249:

Line 269: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

265:
266: PROCEDURE get_attributes(
267: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
268: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
269: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
270: )
271: IS
272: l_attribute_index NUMBER;
273: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

Line 273: l_temp_attribute hxc_self_service_time_deposit.attribute_info;

269: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
270: )
271: IS
272: l_attribute_index NUMBER;
273: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
274:
275: CURSOR c_block_attributes(
276: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
277: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

Line 407: l_blocks hxc_self_service_time_deposit.timecard_info;

403: WHERE alias_value_id = p_alias_value_id;
404:
405: l_get_otl_alias get_otl_alias%rowtype;
406:
407: l_blocks hxc_self_service_time_deposit.timecard_info;
408: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
409: l_day_bb_id NUMBER;
410: l_day_bb_ovn NUMBER;
411: l_tim_bb_id NUMBER;

Line 408: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

404:
405: l_get_otl_alias get_otl_alias%rowtype;
406:
407: l_blocks hxc_self_service_time_deposit.timecard_info;
408: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
409: l_day_bb_id NUMBER;
410: l_day_bb_ovn NUMBER;
411: l_tim_bb_id NUMBER;
412: l_tim_bb_ovn NUMBER;