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 171: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

167: p_att_5 IN VARCHAR2 DEFAULT NULL,
168: p_att_6 IN VARCHAR2 DEFAULT NULL,
169: p_att_7 IN VARCHAR2 DEFAULT NULL,
170: p_att_8 IN VARCHAR2 DEFAULT NULL,
171: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
172: ) IS
173: l_new VARCHAR2 (1);
174: l_attribute_index NUMBER
175: /*ADVICE(195): NUMBER has no precision [315] */

Line 254: p_attribute_index_info OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

250: p_attributes OUT NOCOPY hxc_attribute_table_type,
251: p_add_hours_type_id
252: /*ADVICE(272): Unreferenced parameter [552] */
253: IN NUMBER,
254: p_attribute_index_info OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
255: ) IS
256: CURSOR c_detail_attribute (
257: timecard_id IN NUMBER,
258: timecard_ovn IN NUMBER,

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

334: -- index the attribute table with the attribute_id
335: p_attributes.EXTEND;
336: l_attribute_index := p_attributes.LAST;
337: /* start of changes made by senthil for 4295540 */
338: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'REASON' then
339: l_attribute8:='N';
340: else
341: l_attribute8:=detail_attribute_info.attribute8;
342: end if;

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

344:
345: --Condition Added By Mithun for Persistent resp Enhancement
346: --condition was added so that Whenever TK makes modification to a timecard
347: --The resp_id and user_id stored in attribute3 and attribute4 gets refreshed.
348: if hxc_timekeeper_process.g_submit and detail_attribute_info.attribute_category = 'SECURITY' then
349: l_attribute3:=FND_GLOBAL.USER_ID;
350: l_attribute4:=FND_GLOBAL.RESP_ID;
351: else
352: l_attribute3:=detail_attribute_info.attribute3;

Line 413: p_insert_detail IN hxc_timekeeper_process.t_time_info,

409: FUNCTION get_tk_dff_attrname (
410: p_tkid
411: /*ADVICE(408): Unreferenced parameter [552] */
412: IN NUMBER,
413: p_insert_detail IN hxc_timekeeper_process.t_time_info,
414: p_base_dff IN VARCHAR2,
415: p_att_tab IN hxc_alias_utility.t_alias_att_info
416: )
417: RETURN VARCHAR2 IS

Line 606: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info

602: p_att_27 IN VARCHAR2,
603: p_att_28 IN VARCHAR2,
604: p_att_29 IN VARCHAR2,
605: p_att_30 IN VARCHAR2,
606: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info
607: ) IS
608: l_new VARCHAR2 (1);
609: l_attribute_index NUMBER
610: /*ADVICE(598): NUMBER has no precision [315] */

Line 712: p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table

708: -------------------------------------------------------------------------------
709: -- This procedure dump the timkeeper date table information
710: -------------------------------------------------------------------------------
711: PROCEDURE dump_timkeeper_data (
712: p_timekeeper_data IN hxc_timekeeper_process.t_timekeeper_table
713: ) IS
714: l_index NUMBER
715: /*ADVICE(703): NUMBER has no precision [315] */
716: ;

Line 731: p_buffer_table hxc_timekeeper_process.t_buffer_table

727: -------------------------------------------------------------------------------
728: -- This procedure dump the buffer table information
729: -------------------------------------------------------------------------------
730: PROCEDURE dump_buffer_table (
731: p_buffer_table hxc_timekeeper_process.t_buffer_table
732: /*ADVICE(720): Mode of parameter is not specified with IN parameter [521] */
733:
734: ) IS
735: l_index NUMBER

Line 752: l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table

748: -------------------------------------------------------------------------------
749: -- this procedure dump the resource tc table information
750: -------------------------------------------------------------------------------
751: PROCEDURE dump_resource_tc_table (
752: l_resource_tc_table hxc_timekeeper_process.t_resource_tc_table
753: /*ADVICE(741): Mode of parameter is not specified with IN parameter [521] */
754:
755: ) IS
756: l_index NUMBER

Line 768: 'hxc_timekeeper_process.l_resource_tc_table',

764:
765: IF (1 >= fnd_log.g_current_runtime_level) THEN
766: fnd_log.STRING (
767: 1,
768: 'hxc_timekeeper_process.l_resource_tc_table',
769: 'index_string:' || l_resource_tc_table (l_index).index_string || ' index:' || l_index
770: );
771: END IF;
772:

Line 796: 'hxc_timekeeper_process.dump_buffer_table',

792:
793: IF (1 >= fnd_log.g_current_runtime_level) THEN
794: fnd_log.STRING (
795: 1,
796: 'hxc_timekeeper_process.dump_buffer_table',
797: 'time_building_block_id :' || p_timecard (l_index).time_building_block_id || ' ovn :'
798: || p_timecard (l_index).object_version_number || ' start_time :' || p_timecard (l_index).start_time
799: || ' stop_time :' || p_timecard (l_index).stop_time || ' parent_id :'
800: || p_timecard (l_index).parent_building_block_id || ' parent_ovn :'

Line 807: 'hxc_timekeeper_process.dump_buffer_table',

803: || ' type :' || p_timecard (l_index).TYPE
804: );
805: fnd_log.STRING (
806: 1,
807: 'hxc_timekeeper_process.dump_buffer_table',
808: ' measure :' || p_timecard (l_index).measure || ' OFM :' || p_timecard (l_index).unit_of_measure
809: || ' parent_is_new :' || p_timecard (l_index).parent_is_new || ' scope :' || p_timecard (l_index).SCOPE
810: || ' app_status :' || p_timecard (l_index).approval_status || ' app_style_id :'
811: || p_timecard (l_index).approval_style_id || ' date_from :' || p_timecard (l_index).date_from

Line 2195: p_insert_data_details IN hxc_timekeeper_process.t_time_info,

2191: END convert_type_to_message_table;
2192:
2193: PROCEDURE manage_attributes (
2194: p_attribute_number IN NUMBER,
2195: p_insert_data_details IN hxc_timekeeper_process.t_time_info,
2196: p_old_value IN OUT NOCOPY VARCHAR2,
2197: p_new_value IN OUT NOCOPY VARCHAR2
2198: ) IS
2199: BEGIN

Line 2265: p_insert_detail IN hxc_timekeeper_process.t_time_info,

2261: END;
2262:
2263: PROCEDURE manage_timeinfo (
2264: p_day_counter IN NUMBER,
2265: p_insert_detail IN hxc_timekeeper_process.t_time_info,
2266: p_measure IN OUT NOCOPY NUMBER,
2267: p_detail_id IN OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2268: p_detail_ovn IN OUT NOCOPY NUMBER,
2269: p_detail_time_in IN OUT NOCOPY DATE,

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

2464:
2465: PROCEDURE manage_detaildffinfo (
2466: p_detail_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2467: p_detail_ovn IN NUMBER,
2468: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2469: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2470: p_attribute_category IN VARCHAR2,
2471: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2472: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,

Line 2472: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,

2468: p_det_details IN OUT NOCOPY hxc_timekeeper_process.g_detail_data%TYPE,
2469: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
2470: p_attribute_category IN VARCHAR2,
2471: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2472: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
2473: p_timecard_index_info
2474: /*ADVICE(1974): Unreferenced parameter [552] */
2475: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
2476: ) IS

Line 2475: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info

2471: p_tbb_id_reference_table IN OUT NOCOPY hxc_alias_utility.t_tbb_id_reference,
2472: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
2473: p_timecard_index_info
2474: /*ADVICE(1974): Unreferenced parameter [552] */
2475: IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info
2476: ) IS
2477: l_bldtyp_id NUMBER
2478: /*ADVICE(1978): NUMBER has no precision [315] */
2479: ;

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

2626:
2627: -- now we need to check if we need to create an attribute or do an update
2628: --IF l_attribute_index = -1 THEN
2629: IF NOT (l_attribute_found) THEN
2630: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2631: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2632: hxc_timekeeper_utilities.add_dff_attribute (
2633: p_attribute => p_attributes,
2634: p_attribute_id => l_attribute_index,

Line 2631: l_attribute_index := hxc_timekeeper_process.g_negative_index;

2627: -- now we need to check if we need to create an attribute or do an update
2628: --IF l_attribute_index = -1 THEN
2629: IF NOT (l_attribute_found) THEN
2630: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
2631: l_attribute_index := hxc_timekeeper_process.g_negative_index;
2632: hxc_timekeeper_utilities.add_dff_attribute (
2633: p_attribute => p_attributes,
2634: p_attribute_id => l_attribute_index,
2635: p_tbb_id => p_detail_id,

Line 2677: || hxc_timekeeper_process.g_negative_index;

2673: -- add the new attribute in the ref table
2674: IF p_tbb_id_reference_table.EXISTS (p_detail_id) THEN
2675: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2676: p_tbb_id_reference_table (p_detail_id).attribute_index || '|'
2677: || hxc_timekeeper_process.g_negative_index;
2678: ELSE
2679: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2680: '|' || hxc_timekeeper_process.g_negative_index;
2681: END IF;

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

2676: p_tbb_id_reference_table (p_detail_id).attribute_index || '|'
2677: || hxc_timekeeper_process.g_negative_index;
2678: ELSE
2679: p_tbb_id_reference_table (p_detail_id).attribute_index :=
2680: '|' || hxc_timekeeper_process.g_negative_index;
2681: END IF;
2682: ELSE
2683: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
2684: hxc_timekeeper_utilities.add_dff_attribute (