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_TIMEKEEPER_UTILITIES dependencies on HXC_TIMEKEEPER_PROCESS

Line 25: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

21: p_changed IN VARCHAR2,
22: p_comment_text IN VARCHAR2,
23: p_submit_flg IN BOOLEAN,
24: p_application_set_id IN hxc_time_building_blocks.application_set_id%type,
25: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
26: ) IS
27: l_type hxc_time_building_blocks.TYPE%TYPE;
28: l_parent_is_new VARCHAR2 (1);
29: l_approval_status hxc_time_building_blocks.approval_status%TYPE;

Line 189: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

185: p_att_5 IN VARCHAR2 DEFAULT NULL,
186: p_att_6 IN VARCHAR2 DEFAULT NULL,
187: p_att_7 IN VARCHAR2 DEFAULT NULL,
188: p_att_8 IN VARCHAR2 DEFAULT NULL,
189: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
190: ) IS
191: l_new VARCHAR2 (1);
192: l_attribute_index NUMBER
193: /*ADVICE(195): NUMBER has no precision [315] */

Line 272: p_attribute_index_info OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

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
273: ) IS
274: CURSOR c_detail_attribute (
275: timecard_id IN NUMBER,
276: timecard_ovn IN NUMBER,

Line 356: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'REASON' then

352: -- index the attribute table with the attribute_id
353: p_attributes.EXTEND;
354: l_attribute_index := p_attributes.LAST;
355: /* start of changes made by senthil for 4295540 */
356: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'REASON' then
357: l_attribute8:='N';
358: else
359: l_attribute8:=detail_attribute_info.attribute8;
360: end if;

Line 366: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'SECURITY' then

362:
363: --Condition Added By Mithun for Persistent resp Enhancement
364: --condition was added so that Whenever TK makes modification to a timecard
365: --The resp_id and user_id stored in attribute3 and attribute4 gets refreshed.
366: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'SECURITY' then
367: l_attribute3:=FND_GLOBAL.USER_ID;
368: l_attribute4:=FND_GLOBAL.RESP_ID;
369: else
370: l_attribute3:=detail_attribute_info.attribute3;

Line 431: p_insert_detail IN hxc_timekeeper_process.t_time_info,

427: FUNCTION get_tk_dff_attrname (
428: p_tkid
429: /*ADVICE(408): Unreferenced parameter [552] */
430: IN NUMBER,
431: p_insert_detail IN hxc_timekeeper_process.t_time_info,
432: p_base_dff IN VARCHAR2,
433: p_att_tab IN hxc_alias_utility.t_alias_att_info
434: )
435: RETURN VARCHAR2 IS

Line 624: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

620: p_att_27 IN VARCHAR2,
621: p_att_28 IN VARCHAR2,
622: p_att_29 IN VARCHAR2,
623: p_att_30 IN VARCHAR2,
624: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
625: ) IS
626: l_new VARCHAR2 (1);
627: l_attribute_index NUMBER
628: /*ADVICE(598): NUMBER has no precision [315] */

Line 730: p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table

726: -------------------------------------------------------------------------------
727: -- This procedure dump the timkeeper date table information
728: -------------------------------------------------------------------------------
729: PROCEDURE dump_timkeeper_data (
730: p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table
731: ) IS
732: l_index NUMBER
733: /*ADVICE(703): NUMBER has no precision [315] */
734: ;

Line 749: p_buffer_table hxc_timekeeper_process.t_buffer_table

745: -------------------------------------------------------------------------------
746: -- This procedure dump the buffer table information
747: -------------------------------------------------------------------------------
748: PROCEDURE dump_buffer_table (
749: p_buffer_table hxc_timekeeper_process.t_buffer_table
750: /*ADVICE(720): Mode of parameter is not specified with IN parameter [521] */
751:
752: ) IS
753: l_index NUMBER

Line 770: l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table

766: -------------------------------------------------------------------------------
767: -- this procedure dump the resource tc table information
768: -------------------------------------------------------------------------------
769: PROCEDURE dump_resource_tc_table (
770: l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table
771: /*ADVICE(741): Mode of parameter is not specified with IN parameter [521] */
772:
773: ) IS
774: l_index NUMBER

Line 786: 'hxc_timekeeper_process.l_resource_tc_table',

782:
783: IF (1 >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.STRING (
785: 1,
786: 'hxc_timekeeper_process.l_resource_tc_table',
787: 'index_string:' || l_resource_tc_table (l_index).index_string || ' index:' || l_index
788: );
789: END IF;
790:

Line 814: 'hxc_timekeeper_process.dump_buffer_table',

810:
811: IF (1 >= fnd_log.g_current_runtime_level) THEN
812: fnd_log.STRING (
813: 1,
814: 'hxc_timekeeper_process.dump_buffer_table',
815: 'time_building_block_id :' || p_timecard (l_index).time_building_block_id || ' ovn :'
816: || p_timecard (l_index).object_version_number || ' start_time :' || p_timecard (l_index).start_time
817: || ' stop_time :' || p_timecard (l_index).stop_time || ' parent_id :'
818: || p_timecard (l_index).parent_building_block_id || ' parent_ovn :'

Line 825: 'hxc_timekeeper_process.dump_buffer_table',

821: || ' type :' || p_timecard (l_index).TYPE
822: );
823: fnd_log.STRING (
824: 1,
825: 'hxc_timekeeper_process.dump_buffer_table',
826: ' measure :' || p_timecard (l_index).measure || ' OFM :' || p_timecard (l_index).unit_of_measure
827: || ' parent_is_new :' || p_timecard (l_index).parent_is_new || ' scope :' || p_timecard (l_index).SCOPE
828: || ' app_status :' || p_timecard (l_index).approval_status || ' app_style_id :'
829: || p_timecard (l_index).approval_style_id || ' date_from :' || p_timecard (l_index).date_from

Line 2213: p_insert_data_details IN hxc_timekeeper_process.t_time_info,

2209: END convert_type_to_message_table;
2210:
2211: PROCEDURE manage_attributes (
2212: p_attribute_number IN NUMBER,
2213: p_insert_data_details IN hxc_timekeeper_process.t_time_info,
2214: p_old_value IN OUT NOCOPY VARCHAR2,
2215: p_new_value IN OUT NOCOPY VARCHAR2
2216: ) IS
2217: BEGIN

Line 2283: p_insert_detail IN hxc_timekeeper_process.t_time_info,

2279: END;
2280:
2281: PROCEDURE manage_timeinfo (
2282: p_day_counter IN NUMBER,
2283: p_insert_detail IN hxc_timekeeper_process.t_time_info,
2284: p_measure IN OUT NOCOPY NUMBER,
2285: p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2286: p_detail_ovn IN OUT NOCOPY NUMBER,
2287: p_detail_time_in IN OUT NOCOPY DATE,

Line 2486: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,

2482:
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,

Line 2490: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,

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
2492: /*ADVICE(1974): Unreferenced parameter [552] */
2493: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
2494: ) IS

Line 2493: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

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
2492: /*ADVICE(1974): Unreferenced parameter [552] */
2493: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
2494: ) IS
2495: l_bldtyp_id NUMBER
2496: /*ADVICE(1978): NUMBER has no precision [315] */
2497: ;

Line 2648: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

2644:
2645: -- now we need to check if we need to create an attribute or do an update
2646: --IF l_attribute_index = -1 THEN
2647: IF NOT (l_attribute_found) THEN
2648: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2649: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2650: hxc_timekeeper_utilities.add_dff_attribute (
2651: p_attribute => p_attributes,
2652: p_attribute_id => l_attribute_index,

Line 2649: l_attribute_index := hxc_timekeeper_process.g_negative_index;

2645: -- now we need to check if we need to create an attribute or do an update
2646: --IF l_attribute_index = -1 THEN
2647: IF NOT (l_attribute_found) THEN
2648: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2649: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2650: hxc_timekeeper_utilities.add_dff_attribute (
2651: p_attribute => p_attributes,
2652: p_attribute_id => l_attribute_index,
2653: p_tbb_id => p_detail_id,

Line 2695: || hxc_timekeeper_process.g_negative_index;

2691: -- add the new attribute in the ref table
2692: IF p_tbb_id_reference_table.EXISTS (p_detail_id) THEN
2693: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2694: p_tbb_id_reference_table (p_detail_id).attribute_index || '|'
2695: || hxc_timekeeper_process.g_negative_index;
2696: ELSE
2697: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2698: '|' || hxc_timekeeper_process.g_negative_index;
2699: END IF;

Line 2698: '|' || hxc_timekeeper_process.g_negative_index;

2694: p_tbb_id_reference_table (p_detail_id).attribute_index || '|'
2695: || hxc_timekeeper_process.g_negative_index;
2696: ELSE
2697: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2698: '|' || hxc_timekeeper_process.g_negative_index;
2699: END IF;
2700: ELSE
2701: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
2702: hxc_timekeeper_utilities.add_dff_attribute (

Line 4268: (p_timekeeper_data_rec IN hxc_timekeeper_process.t_time_info,

4264: ---------------------------------------------------------------------------------------
4265:
4266:
4267: PROCEDURE populate_prepop_detail_id_info
4268: (p_timekeeper_data_rec IN hxc_timekeeper_process.t_time_info,
4269: p_tk_prepop_detail_id_tab IN OUT NOCOPY hxc_timekeeper_process.g_tk_prepop_detail_id_tab_type)
4270:
4271: IS
4272:

Line 4269: p_tk_prepop_detail_id_tab IN OUT NOCOPY hxc_timekeeper_process.g_tk_prepop_detail_id_tab_type)

4265:
4266:
4267: PROCEDURE populate_prepop_detail_id_info
4268: (p_timekeeper_data_rec IN hxc_timekeeper_process.t_time_info,
4269: p_tk_prepop_detail_id_tab IN OUT NOCOPY hxc_timekeeper_process.g_tk_prepop_detail_id_tab_type)
4270:
4271: IS
4272:
4273: l_index NUMBER;

Line 4656: p_tk_abs_tab OUT NOCOPY hxc_timekeeper_process.t_tk_abs_tab_type,

4652:
4653:
4654: PROCEDURE build_absence_prepop_table
4655: (p_tk_prepop_info IN hxc_timekeeper_utilities.t_tk_prepop_info_type,
4656: p_tk_abs_tab OUT NOCOPY hxc_timekeeper_process.t_tk_abs_tab_type,
4657: p_start_period IN DATE,
4658: p_end_period IN DATE,
4659: p_tc_start IN DATE,
4660: p_tc_end IN DATE,

Line 4751: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count

4747: p_attribute_array => p_attribute_array,
4748: p_lock_rowid => p_lock_row_id,
4749: p_source => 'TK',
4750: p_timekeeper_id => p_timekeeper_id,
4751: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count
4752: );
4753: */
4754: if g_debug then
4755: hr_utility.trace('Entering build_absence_prepop_table');

Line 5819: p_tk_abs_tab OUT NOCOPY hxc_timekeeper_process.t_tk_abs_tab_type

5815: p_tc_start IN DATE,
5816: p_tc_end IN DATE,
5817: p_resource_id IN NUMBER,
5818: p_lock_row_id IN ROWID,
5819: p_tk_abs_tab OUT NOCOPY hxc_timekeeper_process.t_tk_abs_tab_type
5820: )
5821:
5822: IS
5823:

Line 5915: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count

5911: p_attribute_array => p_attribute_array,
5912: p_lock_rowid => p_lock_row_id,
5913: p_source => 'TK',
5914: p_timekeeper_id => p_timekeeper_id,
5915: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count
5916: );
5917:
5918: if g_debug then
5919: hr_utility.trace('INSIDE pre_populate absences');