DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_BLOCK_TABLE_TYPE

Line 27: p_blocks IN hxc_block_table_type

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 (
31: p_blocks IN OUT NOCOPY hxc_block_table_type,

Line 31: p_blocks IN OUT NOCOPY hxc_block_table_type,

27: p_blocks IN hxc_block_table_type
28: );
29:
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

Line 45: p_blocks IN OUT NOCOPY hxc_block_table_type,

41: p_template IN VARCHAR2,
42: p_mode IN VARCHAR2,
43: p_retrieval_process IN hxc_retrieval_processes.NAME%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

Line 60: RETURN hxc_block_table_type;

56:
57: FUNCTION convert_tbb_to_type (
58: p_blocks IN hxc_self_service_time_deposit.timecard_info
59: )
60: RETURN hxc_block_table_type;
61:
62: PROCEDURE convert_app_attributes_to_type (
63: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
64: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 83: p_app_blocks IN hxc_block_table_type,

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: );
87:

Line 109: p_bb_table IN hxc_block_table_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,
110: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
111: )
112: RETURN PLS_INTEGER;
113:

Line 131: p_app_blocks OUT NOCOPY hxc_block_table_type,

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,
132: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
133: );
134:
135: PROCEDURE get_timecard_tables (

Line 152: p_app_blocks IN OUT NOCOPY hxc_block_table_type

148: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
149: );
150:
151: PROCEDURE clear_building_block_table (
152: p_app_blocks IN OUT NOCOPY hxc_block_table_type
153: );
154:
155: PROCEDURE clear_attribute_table (
156: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 164: p_app_blocks IN hxc_block_table_type,

160: p_messages IN OUT NOCOPY hxc_message_table_type
161: );
162:
163: PROCEDURE request_lock (
164: p_app_blocks IN hxc_block_table_type,
165: p_messages IN OUT NOCOPY hxc_message_table_type,
166: p_locked_success OUT NOCOPY BOOLEAN,
167: p_row_lock_id OUT NOCOPY ROWID
168: );

Line 171: p_app_blocks IN hxc_block_table_type,

167: p_row_lock_id OUT NOCOPY ROWID
168: );
169:
170: PROCEDURE release_lock (
171: p_app_blocks IN hxc_block_table_type,
172: p_messages IN OUT NOCOPY hxc_message_table_type,
173: p_released_success OUT NOCOPY BOOLEAN,
174: p_row_lock_id IN OUT NOCOPY ROWID
175: );

Line 178: p_app_blocks IN hxc_block_table_type,

174: p_row_lock_id IN OUT NOCOPY ROWID
175: );
176:
177: PROCEDURE log_timecard (
178: p_app_blocks IN hxc_block_table_type,
179: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
180: );
181:
182: PROCEDURE log_timecard (