[Home] [Help]
170: -------------------------------------------------------------------------------
171: -- this procedure add a attribute in the attribute_table
172: -------------------------------------------------------------------------------
173: PROCEDURE add_attribute (
174: p_attribute IN OUT NOCOPY hxc_attribute_table_type,
175: p_attribute_id IN NUMBER,
176: p_tbb_id IN NUMBER,
177: p_tbb_ovn IN NUMBER,
178: p_blk_type IN VARCHAR2,
264: IN DATE,
265: p_end_period
266: /*ADVICE(268): Unreferenced parameter [552] */
267: IN DATE,
268: p_attributes OUT NOCOPY hxc_attribute_table_type,
269: p_add_hours_type_id
270: /*ADVICE(272): Unreferenced parameter [552] */
271: IN NUMBER,
272: p_attribute_index_info OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
345: l_attribute8 varchar2(150);
346: l_attribute3 varchar2(150);
347: l_attribute4 varchar2(150);
348: BEGIN
349: p_attributes := hxc_attribute_table_type ();
350:
351: FOR detail_attribute_info IN c_detail_attribute (p_timecard_id, p_timecard_ovn, p_resource_id) LOOP
352: -- index the attribute table with the attribute_id
353: p_attributes.EXTEND;
581:
582: -------------------------------------------------------------------------------
583: -------------------------------------------------------------------------------
584: PROCEDURE add_dff_attribute (
585: p_attribute IN OUT NOCOPY hxc_attribute_table_type,
586: p_attribute_id IN NUMBER,
587: p_tbb_id IN NUMBER,
588: p_tbb_ovn
589: /*ADVICE(559): Unreferenced parameter [552] */
628: /*ADVICE(598): NUMBER has no precision [315] */
629: := 0;
630: BEGIN
631:
632: --p_attribute :=HXC_ATTRIBUTE_TABLE_TYPE();
633: IF p_attribute_index_info.EXISTS (p_attribute_id) THEN
634: l_attribute_index := p_attribute_index_info (p_attribute_id).attribute_block_row_index;
635: ELSE
636: p_attribute.EXTEND;
2483: PROCEDURE manage_detaildffinfo (
2484: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2485: p_detail_ovn IN NUMBER,
2486: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2487: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2488: p_attribute_category IN VARCHAR2,
2489: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2490: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
2491: p_timecard_index_info
2746: END;
2747:
2748: PROCEDURE check_msg_set_process_flag (
2749: p_blocks IN OUT NOCOPY hxc_block_table_type,
2750: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2751: p_messages IN OUT NOCOPY hxc_message_table_type
2752: ) IS
2753: l_change_process_flag BOOLEAN := FALSE;
2754: l_index BINARY_INTEGER
4697: tmp_bin_index BINARY_INTEGER;
4698: l_detail_id NUMBER;
4699: /*
4700: p_block_array HXC_BLOCK_TABLE_TYPE;
4701: p_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
4702:
4703: l_resp_id NUMBER;
4704: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;
4705: l_resp_appl_id NUMBER;
4710:
4711: /*
4712: p_block_array:= HXC_BLOCK_TABLE_TYPE();
4713:
4714: p_attribute_array:= HXC_ATTRIBUTE_TABLE_TYPE();
4715:
4716: if g_debug then
4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
4718: end if;
5857:
5858: l_abs_pending_appr_notif EXCEPTION;
5859:
5860: p_block_array HXC_BLOCK_TABLE_TYPE;
5861: p_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5862: p_messages HXC_MESSAGE_TABLE_TYPE;
5863:
5864: l_resp_id NUMBER;
5865: l_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE;
5871: BEGIN
5872:
5873: p_block_array:= HXC_BLOCK_TABLE_TYPE();
5874:
5875: p_attribute_array:= HXC_ATTRIBUTE_TABLE_TYPE();
5876:
5877: p_messages:= HXC_MESSAGE_TABLE_TYPE();
5878:
5879: if g_debug then