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_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_TIME_BUILDING_BLOCKS

Line 6: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

2: /* $Header: hxctsdputil.pkh 120.4 2006/03/31 19:50:00 arundell noship $ */
3: TYPE translated_message_info IS RECORD (
4: message_name fnd_new_messages.message_name%TYPE,
5: MESSAGE_TEXT VARCHAR2 (4000),
6: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
7: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
8: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
9: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE
10: );

Line 7: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,

3: TYPE translated_message_info IS RECORD (
4: message_name fnd_new_messages.message_name%TYPE,
5: MESSAGE_TEXT VARCHAR2 (4000),
6: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
7: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
8: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
9: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE
10: );
11:

Line 26: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

22: )
23: RETURN hxc_approval_styles.approval_style_id%TYPE;
24:
25: PROCEDURE begin_approval (
26: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
27: p_blocks IN hxc_block_table_type
28: );
29:
30: PROCEDURE save_timecard (

Line 34: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

30: PROCEDURE save_timecard (
31: p_blocks IN OUT NOCOPY hxc_block_table_type,
32: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
33: p_messages IN OUT NOCOPY hxc_message_table_type,
34: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
35: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
36: );
37:
38: PROCEDURE submit_timecard (

Line 35: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

31: p_blocks IN OUT NOCOPY hxc_block_table_type,
32: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
33: p_messages IN OUT NOCOPY hxc_message_table_type,
34: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
35: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
36: );
37:
38: PROCEDURE submit_timecard (
39: p_item_type IN wf_items.item_type%TYPE,

Line 48: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

44: DEFAULT NULL,
45: p_blocks IN OUT NOCOPY hxc_block_table_type,
46: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
47: p_messages IN OUT NOCOPY hxc_message_table_type,
48: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
49: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
50: );
51:
52: FUNCTION convert_new_trans_info_to_old (

Line 49: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

45: p_blocks IN OUT NOCOPY hxc_block_table_type,
46: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
47: p_messages IN OUT NOCOPY hxc_message_table_type,
48: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
49: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
50: );
51:
52: FUNCTION convert_new_trans_info_to_old (
53: p_transaction_info IN hxc_timecard.transaction_info

Line 79: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

75: FUNCTION get_approval_status (p_mode IN VARCHAR2)
76: RETURN VARCHAR2;
77:
78: PROCEDURE find_parent_building_block (
79: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,

Line 80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

76: RETURN VARCHAR2;
77:
78: PROCEDURE find_parent_building_block (
79: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,
84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

77:
78: PROCEDURE find_parent_building_block (
79: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,
84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

78: PROCEDURE find_parent_building_block (
79: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,
84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
86: );

Line 84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

80: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,
84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
86: );
87:
88: PROCEDURE find_parent_building_block (

Line 85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

81: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
82: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
83: p_app_blocks IN hxc_block_table_type,
84: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
86: );
87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

Line 89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

85: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
86: );
87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,

Line 90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

86: );
87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );

Line 94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );
97:
98: PROCEDURE set_new_change_flags (

Line 95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );
97:
98: PROCEDURE set_new_change_flags (
99: p_attributes IN OUT NOCOPY hxc_attribute_table_type

Line 103: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

99: p_attributes IN OUT NOCOPY hxc_attribute_table_type
100: );
101:
102: PROCEDURE get_timecard_bb_id (
103: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:

Line 104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

100: );
101:
102: PROCEDURE get_timecard_bb_id (
103: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:
108: FUNCTION get_index_in_bb_table (

Line 105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

101:
102: PROCEDURE get_timecard_bb_id (
103: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:
108: FUNCTION get_index_in_bb_table (
109: p_bb_table IN hxc_block_table_type,

Line 110: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE

106: );
107:
108: FUNCTION get_index_in_bb_table (
109: p_bb_table IN hxc_block_table_type,
110: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
111: )
112: RETURN PLS_INTEGER;
113:
114: FUNCTION get_deposit_process_id (

Line 127: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

123: )
124: RETURN PLS_INTEGER;
125: -- ARR: Next two procedures add p_clear_mapping_cache for update case
126: PROCEDURE get_timecard_tables (
127: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
128: -- p_time_recipient_id IN NUMBER,
129: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
130: p_clear_mapping_cache IN BOOLEAN default false,
131: p_app_blocks OUT NOCOPY hxc_block_table_type,

Line 136: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

132: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
133: );
134:
135: PROCEDURE get_timecard_tables (
136: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
137: -- p_time_recipient_id IN NUMBER,
138: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
139: p_clear_mapping_cache IN BOOLEAN default false,
140: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 199: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

195: )
196: RETURN translated_message_table;
197:
198: PROCEDURE find_current_period (
199: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
200: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
201: p_day IN hxc_time_building_blocks.start_time%TYPE,
202: p_start_time OUT NOCOPY DATE,
203: p_stop_time OUT NOCOPY DATE

Line 200: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

196: RETURN translated_message_table;
197:
198: PROCEDURE find_current_period (
199: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
200: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
201: p_day IN hxc_time_building_blocks.start_time%TYPE,
202: p_start_time OUT NOCOPY DATE,
203: p_stop_time OUT NOCOPY DATE
204: );

Line 201: p_day IN hxc_time_building_blocks.start_time%TYPE,

197:
198: PROCEDURE find_current_period (
199: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
200: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
201: p_day IN hxc_time_building_blocks.start_time%TYPE,
202: p_start_time OUT NOCOPY DATE,
203: p_stop_time OUT NOCOPY DATE
204: );
205:

Line 207: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

203: p_stop_time OUT NOCOPY DATE
204: );
205:
206: FUNCTION cla_enabled (
207: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
208: )
209: RETURN BOOLEAN;
210: END hxc_timestore_deposit_util;