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 dependencies on HXC_TIMECARD

Line 166: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

162: ) is
163:
164:
165: cursor c_previous_timecard(
166: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
167: select tk_audit_item_key,tk_audit_item_type
168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:

Line 168: from hxc_timecard_summary

164:
165: cursor c_previous_timecard(
166: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
167: select tk_audit_item_key,tk_audit_item_type
168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;

Line 171: l_timecard_blocks hxc_timecard.block_list;

167: select tk_audit_item_key,tk_audit_item_type
168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;
173: l_detail_blocks hxc_timecard.block_list;
174: l_transaction_info hxc_timecard.transaction_info;
175: l_timecard_props hxc_timecard_prop_table_type;

Line 172: l_day_blocks hxc_timecard.block_list;

168: from hxc_timecard_summary
169: where timecard_id = p_timecard_id;
170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;
173: l_detail_blocks hxc_timecard.block_list;
174: l_transaction_info hxc_timecard.transaction_info;
175: l_timecard_props hxc_timecard_prop_table_type;
176: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';

Line 173: l_detail_blocks hxc_timecard.block_list;

169: where timecard_id = p_timecard_id;
170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;
173: l_detail_blocks hxc_timecard.block_list;
174: l_transaction_info hxc_timecard.transaction_info;
175: l_timecard_props hxc_timecard_prop_table_type;
176: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
177: l_timecard_index number;

Line 174: l_transaction_info hxc_timecard.transaction_info;

170:
171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;
173: l_detail_blocks hxc_timecard.block_list;
174: l_transaction_info hxc_timecard.transaction_info;
175: l_timecard_props hxc_timecard_prop_table_type;
176: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
177: l_timecard_index number;
178:

Line 175: l_timecard_props hxc_timecard_prop_table_type;

171: l_timecard_blocks hxc_timecard.block_list;
172: l_day_blocks hxc_timecard.block_list;
173: l_detail_blocks hxc_timecard.block_list;
174: l_transaction_info hxc_timecard.transaction_info;
175: l_timecard_props hxc_timecard_prop_table_type;
176: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
177: l_timecard_index number;
178:
179: l_old_style_blks hxc_self_service_time_deposit.timecard_info;

Line 183: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

179: l_old_style_blks hxc_self_service_time_deposit.timecard_info;
180: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
181: l_old_messages hxc_self_service_time_deposit.message_table;
182:
183: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;
184:
185: l_rollback BOOLEAN := FALSE;
186: l_status_error BOOLEAN := FALSE;
187: e_timekeeper_check EXCEPTION;

Line 191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

187: e_timekeeper_check EXCEPTION;
188:
189: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
190:
191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
193:
194: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
195: tk_audit_process_name VARCHAR2(50) :=NULL;

Line 192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

188:
189: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
190:
191: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
192: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
193:
194: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
195: tk_audit_process_name VARCHAR2(50) :=NULL;
196:

Line 224: hxc_timecard_message_helper.initializeerrors;

220: g_debug := hr_utility.debug_enabled;
221: ----------------------------------------------------------------------------
222: -- Timecard Preparation
223: ----------------------------------------------------------------------------
224: hxc_timecard_message_helper.initializeerrors;
225:
226: p_messages := hxc_message_table_type ();
227:
228: -- create savepoint

Line 231: hxc_timecard_block_utils.initialize_timecard_index;

227:
228: -- create savepoint
229: savepoint TK_SAVE_SAVEPOINT;
230:
231: hxc_timecard_block_utils.initialize_timecard_index;
232:
233: --
234: -- Check input parameters
235: --

Line 239: ,p_deposit_mode => hxc_timecard_deposit_common.c_save

235: --
236: hxc_deposit_checks.check_inputs
237: (p_blocks => p_blocks
238: ,p_attributes => p_attributes
239: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
240: ,p_template => hxc_timecard_deposit_common.c_no
241: ,p_messages => p_messages
242: );
243: /*

Line 240: ,p_template => hxc_timecard_deposit_common.c_no

236: hxc_deposit_checks.check_inputs
237: (p_blocks => p_blocks
238: ,p_attributes => p_attributes
239: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
240: ,p_template => hxc_timecard_deposit_common.c_no
241: ,p_messages => p_messages
242: );
243: /*
244: -- debug

Line 249: hxc_timecard_message_helper.processerrors

245: IF g_debug THEN
246: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',20);
247: END IF;
248: */
249: hxc_timecard_message_helper.processerrors
250: (p_messages => p_messages);
251:
252: --
253: -- First we are getting the preference

Line 257: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

253: -- First we are getting the preference
254: -- for the resource of the timecard
255: --
256:
257: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
258:
259: -- this procedure has the otl setup validation
260: hxc_timecard_properties.get_preference_properties
261: (p_validate => hxc_timecard_deposit_common.c_yes

Line 260: hxc_timecard_properties.get_preference_properties

256:
257: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
258:
259: -- this procedure has the otl setup validation
260: hxc_timecard_properties.get_preference_properties
261: (p_validate => hxc_timecard_deposit_common.c_yes
262: ,p_resource_id => p_blocks(l_timecard_index).resource_id
263: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
264: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)

Line 261: (p_validate => hxc_timecard_deposit_common.c_yes

257: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
258:
259: -- this procedure has the otl setup validation
260: hxc_timecard_properties.get_preference_properties
261: (p_validate => hxc_timecard_deposit_common.c_yes
262: ,p_resource_id => p_blocks(l_timecard_index).resource_id
263: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
264: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)
265: ,p_for_timecard => false

Line 275: hxc_timecard_message_helper.processerrors

271: IF g_debug THEN
272: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',30);
273: END IF;
274: */
275: hxc_timecard_message_helper.processerrors
276: (p_messages => p_messages);
277:
278: --
279: -- Sort blocks

Line 281: hxc_timecard_block_utils.sort_blocks

277:
278: --
279: -- Sort blocks
280: --
281: hxc_timecard_block_utils.sort_blocks
282: (p_blocks => p_blocks
283: ,p_timecard_blocks => l_timecard_blocks
284: ,p_day_blocks => l_day_blocks
285: ,p_detail_blocks => l_detail_blocks

Line 308: hxc_timecard_message_helper.processerrors

304: IF g_debug THEN
305: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',40);
306: END IF;
307: */
308: hxc_timecard_message_helper.processerrors
309: (p_messages => p_messages);
310:
311: ----------------------------------------------------------------------------
312: -- Timecard Preparation

Line 326: hxc_timecard_message_helper.processerrors

322: ,p_timecard_props => l_timecard_props
323: ,p_messages => p_messages
324: );
325:
326: hxc_timecard_message_helper.processerrors
327: (p_messages => p_messages);
328: --
329: -- Translate any aliases
330: --

Line 331: hxc_timecard_deposit_common.alias_translation

327: (p_messages => p_messages);
328: --
329: -- Translate any aliases
330: --
331: hxc_timecard_deposit_common.alias_translation
332: (p_blocks => p_blocks
333: ,p_attributes => p_attributes
334: ,p_messages => p_messages
335: );

Line 342: hxc_timecard_message_helper.processerrors

338: IF g_debug THEN
339: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',50);
340: END IF;
341: */
342: hxc_timecard_message_helper.processerrors
343: (p_messages => p_messages);
344:
345: --
346: -- Set the block and attribute update process flags

Line 358: hxc_timecard_attribute_utils.remove_deleted_attributes

354: --
355: -- Removed any deleted attributes
356: --
357:
358: hxc_timecard_attribute_utils.remove_deleted_attributes
359: (p_attributes => p_attributes);
360:
361: remove_blank_attribute_rows (p_attributes => p_attributes);
362:

Line 370: hxc_timecard_deposit_common.validate_setup

366: --
367: -- Validate the set up for the user
368: --
369: /*
370: hxc_timecard_deposit_common.validate_setup
371: (p_deposit_mode => hxc_timecard.c_save
372: ,p_blocks => p_blocks
373: ,p_attributes => p_attributes
374: ,p_messages => p_messages

Line 371: (p_deposit_mode => hxc_timecard.c_save

367: -- Validate the set up for the user
368: --
369: /*
370: hxc_timecard_deposit_common.validate_setup
371: (p_deposit_mode => hxc_timecard.c_save
372: ,p_blocks => p_blocks
373: ,p_attributes => p_attributes
374: ,p_messages => p_messages
375: );

Line 382: hxc_timecard_message_helper.processerrors

378: IF g_debug THEN
379: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',60);
380: END IF;
381:
382: hxc_timecard_message_helper.processerrors
383: (p_messages => p_messages);
384: */
385: /*
386: Call time entry rules for save

Line 390: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks

386: Call time entry rules for save
387: */
388:
389: /*
390: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
391: (p_blocks);
392:
393: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
394: (p_attributes);

Line 393: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes

389: /*
390: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
391: (p_blocks);
392:
393: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
394: (p_attributes);
395:
396: HXC_TIME_ENTRY_RULES_UTILS_PKG.EXECUTE_TIME_ENTRY_RULES
397: (P_OPERATION => hxc_timecard_deposit_common.c_save

Line 397: (P_OPERATION => hxc_timecard_deposit_common.c_save

393: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
394: (p_attributes);
395:
396: HXC_TIME_ENTRY_RULES_UTILS_PKG.EXECUTE_TIME_ENTRY_RULES
397: (P_OPERATION => hxc_timecard_deposit_common.c_save
398: ,P_TIME_BUILDING_BLOCKS => l_old_style_blks
399: ,P_TIME_ATTRIBUTES => l_old_style_attrs
400: ,P_MESSAGES => l_old_messages
401: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no

Line 401: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no

397: (P_OPERATION => hxc_timecard_deposit_common.c_save
398: ,P_TIME_BUILDING_BLOCKS => l_old_style_blks
399: ,P_TIME_ATTRIBUTES => l_old_style_attrs
400: ,P_MESSAGES => l_old_messages
401: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no
402: );
403:
404: hxc_timecard_message_utils.append_old_messages
405: (p_messages => p_messages

Line 404: hxc_timecard_message_utils.append_old_messages

400: ,P_MESSAGES => l_old_messages
401: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no
402: );
403:
404: hxc_timecard_message_utils.append_old_messages
405: (p_messages => p_messages
406: ,p_old_messages => l_old_messages
407: ,p_retrieval_process_id => null
408: );

Line 410: hxc_timecard_message_helper.processerrors

406: ,p_old_messages => l_old_messages
407: ,p_retrieval_process_id => null
408: );
409:
410: hxc_timecard_message_helper.processerrors
411: (p_messages => p_messages);
412: */
413:
414: --

Line 417: hxc_timecard_validation.recipients_update_validation

413:
414: --
415: -- call the application validation
416: --
417: hxc_timecard_validation.recipients_update_validation
418: (p_blocks => p_blocks
419: ,p_attributes => p_attributes
420: ,p_messages => p_messages
421: ,p_props => l_timecard_props

Line 422: ,p_deposit_mode => hxc_timecard_deposit_common.c_save

418: (p_blocks => p_blocks
419: ,p_attributes => p_attributes
420: ,p_messages => p_messages
421: ,p_props => l_timecard_props
422: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
423: ,p_resubmit => l_resubmit);
424:
425: /* Added for bug 8775740 HR Absence Integration
426:

Line 583: hxc_timecard_message_helper.processerrors

579: end if;
580:
581:
582:
583: hxc_timecard_message_helper.processerrors
584: (p_messages => p_messages);
585:
586:
587: HXC_RETRIEVE_ABSENCES.verify_view_only_absences

Line 904: hxc_timecard_message_helper.processerrors

900: end if;
901:
902:
903:
904: hxc_timecard_message_helper.processerrors
905: (p_messages => p_messages);
906:
907:
908: IF g_debug THEN

Line 1079: hxc_timecard_block_utils.sort_blocks

1075:
1076: /* end of fix for bug 6130457 */
1077:
1078: /* fix by senthil for bug 5099360*/
1079: hxc_timecard_block_utils.sort_blocks
1080: (p_blocks => p_blocks
1081: ,p_timecard_blocks => l_timecard_blocks
1082: ,p_day_blocks => l_day_blocks
1083: ,p_detail_blocks => l_detail_blocks

Line 1087: hxc_timecard_message_helper.processerrors

1083: ,p_detail_blocks => l_detail_blocks
1084: );
1085: /* end of fix for bug 5099360*/
1086:
1087: hxc_timecard_message_helper.processerrors
1088: (p_messages => p_messages);
1089:
1090: hxc_timecard_validation.data_set_validation
1091: (p_blocks => p_blocks

Line 1090: hxc_timecard_validation.data_set_validation

1086:
1087: hxc_timecard_message_helper.processerrors
1088: (p_messages => p_messages);
1089:
1090: hxc_timecard_validation.data_set_validation
1091: (p_blocks => p_blocks
1092: ,p_messages => p_messages
1093: );
1094:

Line 1095: hxc_timecard_message_helper.processerrors

1091: (p_blocks => p_blocks
1092: ,p_messages => p_messages
1093: );
1094:
1095: hxc_timecard_message_helper.processerrors
1096: (p_messages => p_messages);
1097:
1098: --
1099: -- At this point of the process

Line 1103: p_messages := hxc_timecard_message_helper.getMessages;

1099: -- At this point of the process
1100: -- we know if the timecard needs to be in error.
1101: --
1102: -- get all the errors
1103: p_messages := hxc_timecard_message_helper.getMessages;
1104:
1105: --svg start Bug 9181950
1106: if NOT hxc_timecard_message_helper.noErrors then
1107: --HXC_SVG_LOG.record_log('Reached here:svg');

Line 1106: if NOT hxc_timecard_message_helper.noErrors then

1102: -- get all the errors
1103: p_messages := hxc_timecard_message_helper.getMessages;
1104:
1105: --svg start Bug 9181950
1106: if NOT hxc_timecard_message_helper.noErrors then
1107: --HXC_SVG_LOG.record_log('Reached here:svg');
1108: if g_debug then
1109: hr_utility.trace('SVG: Rollingback to savepoint TK_SAVE_SAVEPOINT for any Projects related updates');
1110: end if;

Line 1152: hxc_timecard_deposit.execute

1148: -- in order to main the -ve ids
1149: -- at this point p_messages is not delete
1150: -- so we still have the full message structures
1151:
1152: hxc_timecard_deposit.execute
1153: (p_blocks => p_blocks
1154: ,p_attributes => p_attributes
1155: ,p_timecard_blocks => l_timecard_blocks
1156: ,p_day_blocks => l_day_blocks

Line 1163: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

1159: ,p_transaction_info => l_transaction_info
1160: );
1161:
1162: p_timecard_id :=
1163: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1164: p_timecard_ovn:=
1165: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1166:
1167: hxc_timecard_audit.maintain_latest_details

Line 1165: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

1161:
1162: p_timecard_id :=
1163: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1164: p_timecard_ovn:=
1165: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1166:
1167: hxc_timecard_audit.maintain_latest_details
1168: (p_blocks => p_blocks );
1169:

Line 1167: hxc_timecard_audit.maintain_latest_details

1163: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1164: p_timecard_ovn:=
1165: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1166:
1167: hxc_timecard_audit.maintain_latest_details
1168: (p_blocks => p_blocks );
1169:
1170: /* Bug 8888904 */
1171:

Line 1172: hxc_timecard_audit.maintain_rdb_snapshot

1168: (p_blocks => p_blocks );
1169:
1170: /* Bug 8888904 */
1171:
1172: hxc_timecard_audit.maintain_rdb_snapshot
1173: (p_blocks => p_blocks,
1174: p_attributes => p_attributes);
1175:
1176:

Line 1199: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id

1195: l_item_key :=
1196: hxc_timekeeper_wf_pkg.begin_audit_process
1197: (p_timecard_id => p_timecard_id
1198: ,p_timecard_ovn => p_timecard_ovn
1199: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
1200: ,p_timekeeper_id => p_timekeeper_id
1201: ,p_tk_audit_enabled => p_tk_audit_enabled
1202: ,p_tk_notify_to => p_tk_notify_to
1203: ,p_tk_notify_type => p_tk_notify_type

Line 1213: --hxc_timecard_message_helper.processerrors

1209: tk_audit_process_name := 'HXC_TK_AUDIT_PROCESS';
1210: tk_audit_item_type := 'HXCTKWF';
1211: END IF;
1212:
1213: --hxc_timecard_message_helper.processerrors
1214: --(p_messages => p_messages);
1215:
1216: --
1217: -- Maintain summary table

Line 1220: hxc_timecard_summary_api.timecard_deposit

1216: --
1217: -- Maintain summary table
1218: --
1219:
1220: hxc_timecard_summary_api.timecard_deposit
1221: (p_blocks => p_blocks
1222: ,p_approval_item_type => NULL
1223: ,p_approval_process_name => NULL
1224: ,p_approval_item_key => NULL

Line 1230: hxc_timecard_audit.audit_deposit

1226: ,p_tk_audit_process_name => tk_audit_process_name
1227: ,p_tk_audit_item_key => l_item_key
1228: );
1229:
1230: hxc_timecard_audit.audit_deposit
1231: (p_transaction_info => l_transaction_info
1232: ,p_messages => p_messages
1233: );
1234:

Line 1247: -- p_messages := hxc_timecard_message_helper.getMessages;

1243: --
1244: -- store error
1245: --
1246: -- get all the errors
1247: -- p_messages := hxc_timecard_message_helper.getMessages;
1248:
1249: -- OTL-Absences Integration (Bug 8779478)
1250: -- Modified code to rollback in case on online retrieval errors (Bug 8888138)
1251: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN

Line 1252: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors) THEN

1248:
1249: -- OTL-Absences Integration (Bug 8779478)
1250: -- Modified code to rollback in case on online retrieval errors (Bug 8888138)
1251: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1252: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors) THEN
1253:
1254: IF g_debug THEN
1255: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.SAVE_TIMECARD');
1256: END IF;

Line 1301: hxc_timecard_message_helper.prepareErrors;

1297: --dbms_profiler.stop_profiler;
1298:
1299: EXCEPTION
1300: WHEN e_timekeeper_check then
1301: hxc_timecard_message_helper.prepareErrors;
1302: rollback;
1303:
1304: End save_timecard;
1305:

Line 1325: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

1321: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
1322: ) IS
1323:
1324: cursor c_previous_timecard(
1325: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1326: select tk_audit_item_key,tk_audit_item_type
1327: from hxc_timecard_summary
1328: where timecard_id = p_timecard_id;
1329:

Line 1327: from hxc_timecard_summary

1323:
1324: cursor c_previous_timecard(
1325: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1326: select tk_audit_item_key,tk_audit_item_type
1327: from hxc_timecard_summary
1328: where timecard_id = p_timecard_id;
1329:
1330:
1331: l_timecard_blocks hxc_timecard.block_list;

Line 1331: l_timecard_blocks hxc_timecard.block_list;

1327: from hxc_timecard_summary
1328: where timecard_id = p_timecard_id;
1329:
1330:
1331: l_timecard_blocks hxc_timecard.block_list;
1332: l_day_blocks hxc_timecard.block_list;
1333: l_detail_blocks hxc_timecard.block_list;
1334: l_transaction_info hxc_timecard.transaction_info;
1335: l_timecard_props hxc_timecard_prop_table_type;

Line 1332: l_day_blocks hxc_timecard.block_list;

1328: where timecard_id = p_timecard_id;
1329:
1330:
1331: l_timecard_blocks hxc_timecard.block_list;
1332: l_day_blocks hxc_timecard.block_list;
1333: l_detail_blocks hxc_timecard.block_list;
1334: l_transaction_info hxc_timecard.transaction_info;
1335: l_timecard_props hxc_timecard_prop_table_type;
1336:

Line 1333: l_detail_blocks hxc_timecard.block_list;

1329:
1330:
1331: l_timecard_blocks hxc_timecard.block_list;
1332: l_day_blocks hxc_timecard.block_list;
1333: l_detail_blocks hxc_timecard.block_list;
1334: l_transaction_info hxc_timecard.transaction_info;
1335: l_timecard_props hxc_timecard_prop_table_type;
1336:
1337: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';

Line 1334: l_transaction_info hxc_timecard.transaction_info;

1330:
1331: l_timecard_blocks hxc_timecard.block_list;
1332: l_day_blocks hxc_timecard.block_list;
1333: l_detail_blocks hxc_timecard.block_list;
1334: l_transaction_info hxc_timecard.transaction_info;
1335: l_timecard_props hxc_timecard_prop_table_type;
1336:
1337: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
1338: l_can_deposit boolean := true;

Line 1335: l_timecard_props hxc_timecard_prop_table_type;

1331: l_timecard_blocks hxc_timecard.block_list;
1332: l_day_blocks hxc_timecard.block_list;
1333: l_detail_blocks hxc_timecard.block_list;
1334: l_transaction_info hxc_timecard.transaction_info;
1335: l_timecard_props hxc_timecard_prop_table_type;
1336:
1337: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
1338: l_can_deposit boolean := true;
1339: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

Line 1339: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

1335: l_timecard_props hxc_timecard_prop_table_type;
1336:
1337: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
1338: l_can_deposit boolean := true;
1339: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;
1340: l_timecard_index number;
1341:
1342: l_rollback BOOLEAN := FALSE;
1343:

Line 1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

1347: tk_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
1348: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
1349: tk_audit_process_name VARCHAR2(50) :=NULL;
1350:
1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1353:
1354: l_index NUMBER;
1355:

Line 1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

1348: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
1349: tk_audit_process_name VARCHAR2(50) :=NULL;
1350:
1351: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1352: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1353:
1354: l_index NUMBER;
1355:
1356: l_resource_id NUMBER;

Line 1376: hxc_timecard_block_utils.initialize_timecard_index;

1372: ----------------------------------------------------------------------------
1373: -- Timecard Preparation
1374: ----------------------------------------------------------------------------
1375:
1376: hxc_timecard_block_utils.initialize_timecard_index;
1377:
1378: hxc_timecard_message_helper.initializeerrors;
1379:
1380: p_messages := hxc_message_table_type ();

Line 1378: hxc_timecard_message_helper.initializeerrors;

1374: ----------------------------------------------------------------------------
1375:
1376: hxc_timecard_block_utils.initialize_timecard_index;
1377:
1378: hxc_timecard_message_helper.initializeerrors;
1379:
1380: p_messages := hxc_message_table_type ();
1381:
1382: -- set savepoint

Line 1391: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

1387:
1388: hxc_deposit_checks.check_inputs
1389: (p_blocks => p_blocks
1390: ,p_attributes => p_attributes
1391: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1392: ,p_template => hxc_timecard_deposit_common.c_no
1393: ,p_messages => p_messages
1394: );
1395:

Line 1392: ,p_template => hxc_timecard_deposit_common.c_no

1388: hxc_deposit_checks.check_inputs
1389: (p_blocks => p_blocks
1390: ,p_attributes => p_attributes
1391: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1392: ,p_template => hxc_timecard_deposit_common.c_no
1393: ,p_messages => p_messages
1394: );
1395:
1396: hxc_timecard_message_helper.processerrors

Line 1396: hxc_timecard_message_helper.processerrors

1392: ,p_template => hxc_timecard_deposit_common.c_no
1393: ,p_messages => p_messages
1394: );
1395:
1396: hxc_timecard_message_helper.processerrors
1397: (p_messages => p_messages);
1398:
1399: --
1400: -- Determine if this is a resubmitted timecard

Line 1402: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

1398:
1399: --
1400: -- Determine if this is a resubmitted timecard
1401: --
1402: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1403:
1404: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
1405: = hr_general.end_of_time)
1406: then

Line 1404: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)

1400: -- Determine if this is a resubmitted timecard
1401: --
1402: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1403:
1404: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
1405: = hr_general.end_of_time)
1406: then
1407: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
1408: (p_blocks(l_timecard_index).time_building_block_id

Line 1407: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted

1403:
1404: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
1405: = hr_general.end_of_time)
1406: then
1407: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
1408: (p_blocks(l_timecard_index).time_building_block_id
1409: ,p_blocks(l_timecard_index).object_version_number
1410: ,p_blocks(l_timecard_index).resource_id
1411: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

Line 1411: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

1407: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
1408: (p_blocks(l_timecard_index).time_building_block_id
1409: ,p_blocks(l_timecard_index).object_version_number
1410: ,p_blocks(l_timecard_index).resource_id
1411: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
1412: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
1413: );
1414: else
1415: l_resubmit := hxc_timecard_deposit_common.c_delete;

Line 1412: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)

1408: (p_blocks(l_timecard_index).time_building_block_id
1409: ,p_blocks(l_timecard_index).object_version_number
1410: ,p_blocks(l_timecard_index).resource_id
1411: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
1412: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
1413: );
1414: else
1415: l_resubmit := hxc_timecard_deposit_common.c_delete;
1416: end if;

Line 1415: l_resubmit := hxc_timecard_deposit_common.c_delete;

1411: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
1412: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
1413: );
1414: else
1415: l_resubmit := hxc_timecard_deposit_common.c_delete;
1416: end if;
1417:
1418: --
1419: -- Obtain the timecard properties

Line 1426: hxc_timecard_properties.get_preference_properties

1422: -- middle tier, to avoid another
1423: -- pref evaluation
1424: --
1425:
1426: hxc_timecard_properties.get_preference_properties
1427: (p_validate => hxc_timecard_deposit_common.c_yes
1428: ,p_resource_id => p_blocks(l_timecard_index).resource_id
1429: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1430: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)

Line 1427: (p_validate => hxc_timecard_deposit_common.c_yes

1423: -- pref evaluation
1424: --
1425:
1426: hxc_timecard_properties.get_preference_properties
1427: (p_validate => hxc_timecard_deposit_common.c_yes
1428: ,p_resource_id => p_blocks(l_timecard_index).resource_id
1429: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1430: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)
1431: ,p_for_timecard => false

Line 1436: hxc_timecard_message_helper.processerrors

1432: ,p_messages => p_messages
1433: ,p_property_table => l_timecard_props
1434: );
1435:
1436: hxc_timecard_message_helper.processerrors
1437: (p_messages => p_messages);
1438:
1439: --
1440: -- Sort the blocks - needed for deposit

Line 1444: hxc_timecard_block_utils.sort_blocks

1440: -- Sort the blocks - needed for deposit
1441: -- and all sorts of short cuts!
1442: --
1443:
1444: hxc_timecard_block_utils.sort_blocks
1445: (p_blocks => p_blocks
1446: ,p_timecard_blocks => l_timecard_blocks
1447: ,p_day_blocks => l_day_blocks
1448: ,p_detail_blocks => l_detail_blocks

Line 1477: hxc_timecard_message_helper.processerrors

1473: ,p_details => l_detail_blocks
1474: ,p_messages => p_messages
1475: );
1476:
1477: hxc_timecard_message_helper.processerrors
1478: (p_messages => p_messages);
1479:
1480: --
1481: -- Add the security attributes

Line 1491: hxc_timecard_message_helper.processerrors

1487: p_timecard_props => l_timecard_props,
1488: p_messages => p_messages
1489: );
1490:
1491: hxc_timecard_message_helper.processerrors
1492: (p_messages => p_messages);
1493: --
1494: -- Translate any aliases
1495: --

Line 1496: hxc_timecard_deposit_common.alias_translation

1492: (p_messages => p_messages);
1493: --
1494: -- Translate any aliases
1495: --
1496: hxc_timecard_deposit_common.alias_translation
1497: (p_blocks => p_blocks
1498: ,p_attributes => p_attributes
1499: ,p_messages => p_messages
1500: );

Line 1502: hxc_timecard_message_helper.processerrors

1498: ,p_attributes => p_attributes
1499: ,p_messages => p_messages
1500: );
1501:
1502: hxc_timecard_message_helper.processerrors
1503: (p_messages => p_messages);
1504:
1505: --
1506: -- Set the block and attribute update process flags

Line 1518: hxc_timecard_attribute_utils.remove_deleted_attributes

1514: --
1515: -- Removed any deleted attributes
1516: --
1517:
1518: hxc_timecard_attribute_utils.remove_deleted_attributes
1519: (p_attributes => p_attributes);
1520:
1521:
1522: --

Line 1531: ,p_template => hxc_timecard_deposit_common.c_no

1527: ,p_attributes => p_attributes
1528: ,p_timecard_props => l_timecard_props
1529: ,p_days => l_day_blocks
1530: ,p_details => l_detail_blocks
1531: ,p_template => hxc_timecard_deposit_common.c_no
1532: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1533: ,p_messages => p_messages
1534: );
1535:

Line 1532: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

1528: ,p_timecard_props => l_timecard_props
1529: ,p_days => l_day_blocks
1530: ,p_details => l_detail_blocks
1531: ,p_template => hxc_timecard_deposit_common.c_no
1532: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1533: ,p_messages => p_messages
1534: );
1535:
1536: --in case of rejected TC again resubmit so remove the error raised

Line 1550: hxc_timecard_message_helper.processerrors

1546: );
1547: END IF;
1548:
1549:
1550: hxc_timecard_message_helper.processerrors
1551: (p_messages => p_messages);
1552: --
1553: -- Validate blocks, attributes
1554: --

Line 1556: hxc_timecard_validation.deposit_validation

1552: --
1553: -- Validate blocks, attributes
1554: --
1555: /*
1556: hxc_timecard_validation.deposit_validation
1557: (p_blocks => p_blocks
1558: ,p_attributes => p_attributes
1559: ,p_messages => p_messages
1560: ,p_props => l_timecard_props

Line 1561: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

1557: (p_blocks => p_blocks
1558: ,p_attributes => p_attributes
1559: ,p_messages => p_messages
1560: ,p_props => l_timecard_props
1561: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1562: ,p_template => hxc_timecard_deposit_common.c_no
1563: ,p_resubmit => l_resubmit
1564: ,p_can_deposit => l_can_deposit
1565: );

Line 1562: ,p_template => hxc_timecard_deposit_common.c_no

1558: ,p_attributes => p_attributes
1559: ,p_messages => p_messages
1560: ,p_props => l_timecard_props
1561: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1562: ,p_template => hxc_timecard_deposit_common.c_no
1563: ,p_resubmit => l_resubmit
1564: ,p_can_deposit => l_can_deposit
1565: );
1566: */

Line 1570: hxc_timecard_validation.recipients_update_validation

1566: */
1567:
1568:
1569:
1570: hxc_timecard_validation.recipients_update_validation
1571: (p_blocks => p_blocks
1572: ,p_attributes => p_attributes
1573: ,p_messages => p_messages
1574: ,p_props => l_timecard_props

Line 1575: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

1571: (p_blocks => p_blocks
1572: ,p_attributes => p_attributes
1573: ,p_messages => p_messages
1574: ,p_props => l_timecard_props
1575: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1576: ,p_resubmit => l_resubmit);
1577:
1578: hxc_timecard_message_helper.processerrors
1579: (p_messages => p_messages);

Line 1578: hxc_timecard_message_helper.processerrors

1574: ,p_props => l_timecard_props
1575: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
1576: ,p_resubmit => l_resubmit);
1577:
1578: hxc_timecard_message_helper.processerrors
1579: (p_messages => p_messages);
1580:
1581:
1582: hxc_timecard_validation.data_set_validation

Line 1582: hxc_timecard_validation.data_set_validation

1578: hxc_timecard_message_helper.processerrors
1579: (p_messages => p_messages);
1580:
1581:
1582: hxc_timecard_validation.data_set_validation
1583: (p_blocks => p_blocks
1584: ,p_messages => p_messages
1585: );
1586:

Line 1587: hxc_timecard_message_helper.processerrors

1583: (p_blocks => p_blocks
1584: ,p_messages => p_messages
1585: );
1586:
1587: hxc_timecard_message_helper.processerrors
1588: (p_messages => p_messages);
1589:
1590:
1591: --

Line 1597: hxc_timecard_deposit_common.validate_setup

1593: -- Do this only for timecards, and not
1594: -- for templates.
1595: --
1596: /*
1597: hxc_timecard_deposit_common.validate_setup
1598: (p_deposit_mode => hxc_timecard_deposit_common.c_submit
1599: ,p_blocks => p_blocks
1600: ,p_attributes => p_attributes
1601: ,p_messages => p_messages

Line 1598: (p_deposit_mode => hxc_timecard_deposit_common.c_submit

1594: -- for templates.
1595: --
1596: /*
1597: hxc_timecard_deposit_common.validate_setup
1598: (p_deposit_mode => hxc_timecard_deposit_common.c_submit
1599: ,p_blocks => p_blocks
1600: ,p_attributes => p_attributes
1601: ,p_messages => p_messages
1602: );

Line 1604: hxc_timecard_message_helper.processerrors

1600: ,p_attributes => p_attributes
1601: ,p_messages => p_messages
1602: );
1603:
1604: hxc_timecard_message_helper.processerrors
1605: (p_messages => p_messages);
1606: */
1607: --
1608: -- Reform time data, if required

Line 2101: hxc_timecard_message_helper.processerrors

2097: end if;
2098:
2099:
2100:
2101: hxc_timecard_message_helper.processerrors
2102: (p_messages => p_messages);
2103:
2104:
2105: IF g_debug THEN

Line 2267: hxc_timecard_message_helper.processerrors

2263:
2264: end if;
2265:
2266:
2267: hxc_timecard_message_helper.processerrors
2268: (p_messages => p_messages);
2269:
2270: -- change end
2271: -- Bug 8888138

Line 2274: p_messages := hxc_timecard_message_helper.getMessages;

2270: -- change end
2271: -- Bug 8888138
2272: -- Get_Messages should be used after verify_view_only
2273: -- get all the errors
2274: p_messages := hxc_timecard_message_helper.getMessages;
2275:
2276: --svg start Bug 9181950
2277: if NOT hxc_timecard_message_helper.noErrors then
2278: --HXC_SVG_LOG.record_log('Reached here:svg');

Line 2277: if NOT hxc_timecard_message_helper.noErrors then

2273: -- get all the errors
2274: p_messages := hxc_timecard_message_helper.getMessages;
2275:
2276: --svg start Bug 9181950
2277: if NOT hxc_timecard_message_helper.noErrors then
2278: --HXC_SVG_LOG.record_log('Reached here:svg');
2279: if g_debug then
2280: hr_utility.trace('SVG: Rollingback to savepoint TK_SUB_SAVEPOINT for any Projects related updates');
2281: end if;

Line 2303: hxc_timecard_deposit.execute

2299:
2300: --
2301: -- Store blocks and attributes
2302: --
2303: hxc_timecard_deposit.execute
2304: (p_blocks => p_blocks
2305: ,p_attributes => p_attributes
2306: ,p_timecard_blocks => l_timecard_blocks
2307: ,p_day_blocks => l_day_blocks

Line 2315: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

2311: );
2312:
2313:
2314: p_timecard_id :=
2315: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
2316: p_timecard_ovn:=
2317: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
2318:
2319: --hxc_timecard_message_helper.processerrors

Line 2317: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

2313:
2314: p_timecard_id :=
2315: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
2316: p_timecard_ovn:=
2317: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
2318:
2319: --hxc_timecard_message_helper.processerrors
2320: -- (p_messages => p_messages);
2321:

Line 2319: --hxc_timecard_message_helper.processerrors

2315: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
2316: p_timecard_ovn:=
2317: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
2318:
2319: --hxc_timecard_message_helper.processerrors
2320: -- (p_messages => p_messages);
2321:
2322: hxc_timecard_audit.maintain_latest_details
2323: (p_blocks => p_blocks );

Line 2322: hxc_timecard_audit.maintain_latest_details

2318:
2319: --hxc_timecard_message_helper.processerrors
2320: -- (p_messages => p_messages);
2321:
2322: hxc_timecard_audit.maintain_latest_details
2323: (p_blocks => p_blocks );
2324:
2325: /* Bug 8888904 */
2326:

Line 2327: hxc_timecard_audit.maintain_rdb_snapshot

2323: (p_blocks => p_blocks );
2324:
2325: /* Bug 8888904 */
2326:
2327: hxc_timecard_audit.maintain_rdb_snapshot
2328: (p_blocks => p_blocks,
2329: p_attributes => p_attributes);
2330:
2331:

Line 2354: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id

2350: tk_item_key :=
2351: hxc_timekeeper_wf_pkg.begin_audit_process
2352: (p_timecard_id => p_timecard_id
2353: ,p_timecard_ovn => p_timecard_ovn
2354: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
2355: ,p_timekeeper_id => p_timekeeper_id
2356: ,p_tk_audit_enabled => p_tk_audit_enabled
2357: ,p_tk_notify_to => p_tk_notify_to
2358: ,p_tk_notify_type => p_tk_notify_type

Line 2371: hxc_timecard_summary_api.timecard_deposit

2367: END IF;
2368: --
2369: -- Maintain summary table
2370: --
2371: hxc_timecard_summary_api.timecard_deposit
2372: (p_blocks => p_blocks
2373: ,p_approval_item_type => NULL
2374: ,p_approval_process_name => NULL
2375: ,p_approval_item_key => NULL

Line 2387: hxc_timecard_approval.begin_approval

2383: --
2384: IF not(l_status_error) THEN
2385:
2386: l_item_key :=
2387: hxc_timecard_approval.begin_approval
2388: (p_blocks => p_blocks
2389: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2390: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2391: ,p_resubmitted => l_resubmit

Line 2389: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype

2385:
2386: l_item_key :=
2387: hxc_timecard_approval.begin_approval
2388: (p_blocks => p_blocks
2389: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2390: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2391: ,p_resubmitted => l_resubmit
2392: ,p_timecard_props => l_timecard_props
2393: ,p_messages => p_messages

Line 2390: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess

2386: l_item_key :=
2387: hxc_timecard_approval.begin_approval
2388: (p_blocks => p_blocks
2389: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2390: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2391: ,p_resubmitted => l_resubmit
2392: ,p_timecard_props => l_timecard_props
2393: ,p_messages => p_messages
2394: );

Line 2405: hxc_timecard_audit.audit_deposit

2401: -- Audit this transaction
2402: --
2403: --p_messages.delete;
2404:
2405: hxc_timecard_audit.audit_deposit
2406: (p_transaction_info => l_transaction_info
2407: ,p_messages => p_messages
2408: );
2409:

Line 2412: --hxc_timecard_message_helper.processerrors

2408: );
2409:
2410:
2411:
2412: --hxc_timecard_message_helper.processerrors
2413: -- (p_messages => p_messages);
2414:
2415: -- get all the errors
2416: --p_messages := hxc_timecard_message_helper.getMessages;

Line 2416: --p_messages := hxc_timecard_message_helper.getMessages;

2412: --hxc_timecard_message_helper.processerrors
2413: -- (p_messages => p_messages);
2414:
2415: -- get all the errors
2416: --p_messages := hxc_timecard_message_helper.getMessages;
2417:
2418:
2419: -- set the out parameters --
2420:

Line 2421: hxc_timecard_summary_pkg.update_summary_row

2417:
2418:
2419: -- set the out parameters --
2420:
2421: hxc_timecard_summary_pkg.update_summary_row
2422: (p_timecard_id => p_timecard_id
2423: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2424: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2425: ,p_approval_item_key => l_item_key

Line 2423: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype

2419: -- set the out parameters --
2420:
2421: hxc_timecard_summary_pkg.update_summary_row
2422: (p_timecard_id => p_timecard_id
2423: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2424: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2425: ,p_approval_item_key => l_item_key
2426: );
2427:

Line 2424: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess

2420:
2421: hxc_timecard_summary_pkg.update_summary_row
2422: (p_timecard_id => p_timecard_id
2423: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
2424: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
2425: ,p_approval_item_key => l_item_key
2426: );
2427:
2428: hr_utility.trace('Calling maintain_errors');

Line 2444: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors ) THEN

2440:
2441: -- OTL-Absences Integration (Bug 8779478)
2442: -- Modified code to rollback in case on online retrieval errors (Bug 8888138)
2443: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
2444: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors ) THEN
2445:
2446: l_abs_ret_messages:= HXC_MESSAGE_TABLE_TYPE();
2447:
2448: IF g_debug THEN

Line 2500: hxc_timecard_deposit_common.delete_timecard

2496: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
2497: ) is
2498:
2499: /*
2500: hxc_timecard_deposit_common.delete_timecard
2501: (p_mode => 'DELETE'
2502: ,p_template => 'N'
2503: ,p_timecard_id => p_timecard_id
2504: );

Line 2508: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

2504: );
2505: */
2506:
2507: cursor c_previous_timecard(
2508: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
2509: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
2510: from hxc_timecard_summary
2511: where timecard_id = p_timecard_id;
2512:

Line 2510: from hxc_timecard_summary

2506:
2507: cursor c_previous_timecard(
2508: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
2509: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
2510: from hxc_timecard_summary
2511: where timecard_id = p_timecard_id;
2512:
2513: /*
2514: cursor c_timecard_ovn

Line 2538: l_timecard_blocks hxc_timecard.block_list;

2534: l_blocks hxc_block_table_type := hxc_block_table_type();
2535: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
2536: l_messages hxc_message_table_type := hxc_message_table_type();
2537:
2538: l_timecard_blocks hxc_timecard.block_list;
2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2541:
2542: l_transaction_info hxc_timecard.transaction_info;

Line 2539: l_day_blocks hxc_timecard.block_list;

2535: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
2536: l_messages hxc_message_table_type := hxc_message_table_type();
2537:
2538: l_timecard_blocks hxc_timecard.block_list;
2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2541:
2542: l_transaction_info hxc_timecard.transaction_info;
2543: l_timecard_props hxc_timecard_prop_table_type;

Line 2540: l_detail_blocks hxc_timecard.block_list;

2536: l_messages hxc_message_table_type := hxc_message_table_type();
2537:
2538: l_timecard_blocks hxc_timecard.block_list;
2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2541:
2542: l_transaction_info hxc_timecard.transaction_info;
2543: l_timecard_props hxc_timecard_prop_table_type;
2544:

Line 2542: l_transaction_info hxc_timecard.transaction_info;

2538: l_timecard_blocks hxc_timecard.block_list;
2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2541:
2542: l_transaction_info hxc_timecard.transaction_info;
2543: l_timecard_props hxc_timecard_prop_table_type;
2544:
2545: l_dummy boolean := true;
2546:

Line 2543: l_timecard_props hxc_timecard_prop_table_type;

2539: l_day_blocks hxc_timecard.block_list;
2540: l_detail_blocks hxc_timecard.block_list;
2541:
2542: l_transaction_info hxc_timecard.transaction_info;
2543: l_timecard_props hxc_timecard_prop_table_type;
2544:
2545: l_dummy boolean := true;
2546:
2547: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

Line 2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

2551:
2552: l_rollback BOOLEAN := FALSE;
2553: e_timekeeper_check EXCEPTION;
2554:
2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
2557:
2558: l_dummy_num NUMBER(1);
2559:

Line 2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

2552: l_rollback BOOLEAN := FALSE;
2553: e_timekeeper_check EXCEPTION;
2554:
2555: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
2556: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
2557:
2558: l_dummy_num NUMBER(1);
2559:
2560: l_resource_id NUMBER;

Line 2600: hxc_timecard_message_helper.initializeErrors;

2596: -- Initialize the message stack
2597: --
2598:
2599: fnd_msg_pub.initialize;
2600: hxc_timecard_message_helper.initializeErrors;
2601: --
2602: -- Get the timecard or timecard template blocks and attributes
2603: --
2604:

Line 2605: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);

2601: --
2602: -- Get the timecard or timecard template blocks and attributes
2603: --
2604:
2605: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);
2606: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);
2607:
2608: --
2609: -- Main delete processing

Line 2606: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);

2602: -- Get the timecard or timecard template blocks and attributes
2603: --
2604:
2605: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);
2606: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);
2607:
2608: --
2609: -- Main delete processing
2610: --

Line 2612: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);

2608: --
2609: -- Main delete processing
2610: --
2611:
2612: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
2613:
2614: -- we need to check if the timecard is in error and
2615: -- if it has been retrieved.
2616: IF (l_blocks(l_timecard_index).approval_status = 'ERROR')

Line 2626: hxc_timecard_message_helper.addErrorToCollection

2622: THEN
2623: close csr_chk_transfer;
2624:
2625: -- add the message in the message table
2626: hxc_timecard_message_helper.addErrorToCollection
2627: (p_messages,
2628: 'HXC_DEL_ERROR_RET',
2629: hxc_timecard.c_error,
2630: null,

Line 2629: hxc_timecard.c_error,

2625: -- add the message in the message table
2626: hxc_timecard_message_helper.addErrorToCollection
2627: (p_messages,
2628: 'HXC_DEL_ERROR_RET',
2629: hxc_timecard.c_error,
2630: null,
2631: null,
2632: hxc_timecard.c_hxc,
2633: null,

Line 2632: hxc_timecard.c_hxc,

2628: 'HXC_DEL_ERROR_RET',
2629: hxc_timecard.c_error,
2630: null,
2631: null,
2632: hxc_timecard.c_hxc,
2633: null,
2634: null,
2635: null,
2636: null

Line 2645: hxc_timecard_properties.get_preference_properties

2641:
2642: close csr_chk_transfer;
2643: END IF;
2644:
2645: hxc_timecard_properties.get_preference_properties
2646: (p_validate => hxc_timecard.c_yes
2647: ,p_resource_id => l_blocks(l_timecard_index).resource_id
2648: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
2649: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)

Line 2646: (p_validate => hxc_timecard.c_yes

2642: close csr_chk_transfer;
2643: END IF;
2644:
2645: hxc_timecard_properties.get_preference_properties
2646: (p_validate => hxc_timecard.c_yes
2647: ,p_resource_id => l_blocks(l_timecard_index).resource_id
2648: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
2649: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)
2650: ,p_for_timecard => false

Line 2655: hxc_timecard_message_helper.processerrors

2651: ,p_messages => l_messages
2652: ,p_property_table => l_timecard_props
2653: );
2654:
2655: hxc_timecard_message_helper.processerrors
2656: (p_messages => l_messages);
2657:
2658:
2659: hxc_timecard_block_utils.sort_blocks

Line 2659: hxc_timecard_block_utils.sort_blocks

2655: hxc_timecard_message_helper.processerrors
2656: (p_messages => l_messages);
2657:
2658:
2659: hxc_timecard_block_utils.sort_blocks
2660: (p_blocks => l_blocks
2661: ,p_timecard_blocks => l_timecard_blocks
2662: ,p_day_blocks => l_day_blocks
2663: ,p_detail_blocks => l_detail_blocks

Line 2671: hxc_timecard_validation.deposit_validation

2667: (p_blocks => l_blocks
2668: ,p_attributes => l_attributes
2669: );
2670:
2671: hxc_timecard_validation.deposit_validation
2672: (p_blocks => l_blocks
2673: ,p_attributes => l_attributes
2674: ,p_messages => l_messages
2675: ,p_props => l_timecard_props

Line 2676: ,p_deposit_mode => hxc_timecard.c_submit

2672: (p_blocks => l_blocks
2673: ,p_attributes => l_attributes
2674: ,p_messages => l_messages
2675: ,p_props => l_timecard_props
2676: ,p_deposit_mode => hxc_timecard.c_submit
2677: ,p_template => 'N'
2678: ,p_resubmit => hxc_timecard_deposit_common.c_delete
2679: ,p_can_deposit => l_dummy
2680: );

Line 2678: ,p_resubmit => hxc_timecard_deposit_common.c_delete

2674: ,p_messages => l_messages
2675: ,p_props => l_timecard_props
2676: ,p_deposit_mode => hxc_timecard.c_submit
2677: ,p_template => 'N'
2678: ,p_resubmit => hxc_timecard_deposit_common.c_delete
2679: ,p_can_deposit => l_dummy
2680: );
2681:
2682: hxc_timecard_message_helper.processerrors

Line 2682: hxc_timecard_message_helper.processerrors

2678: ,p_resubmit => hxc_timecard_deposit_common.c_delete
2679: ,p_can_deposit => l_dummy
2680: );
2681:
2682: hxc_timecard_message_helper.processerrors
2683: (p_messages => l_messages);
2684:
2685:
2686: -- get all the errors

Line 2687: l_messages := hxc_timecard_message_helper.getMessages;

2683: (p_messages => l_messages);
2684:
2685:
2686: -- get all the errors
2687: l_messages := hxc_timecard_message_helper.getMessages;
2688: /*
2689: -- debug
2690: IF g_debug THEN
2691: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);

Line 2696: if NOT hxc_timecard_message_helper.noErrors then

2692: END IF;
2693: */
2694:
2695: --svg start Bug 9181950
2696: if NOT hxc_timecard_message_helper.noErrors then
2697: --HXC_SVG_LOG.record_log('Reached here:svg');
2698: if g_debug then
2699: hr_utility.trace('SVG: Rollingback to savepoint TK_DEL_SAVEPOINT for any Projects related updates');
2700: end if;

Line 2728: hxc_timecard_deposit.execute

2724:
2725: ELSE
2726:
2727: --l_messages.delete;
2728: hxc_timecard_deposit.execute
2729: (p_blocks => l_blocks
2730: ,p_attributes => l_attributes
2731: ,p_timecard_blocks => l_timecard_blocks
2732: ,p_day_blocks => l_day_blocks

Line 2738: --hxc_timecard_message_helper.processerrors

2734: ,p_messages => l_messages
2735: ,p_transaction_info => l_transaction_info
2736: );
2737:
2738: --hxc_timecard_message_helper.processerrors
2739: --(p_messages => l_messages);
2740:
2741: end_date_app_period(p_timecard_id);
2742:

Line 2743: hxc_timecard_summary_api.delete_timecard

2739: --(p_messages => l_messages);
2740:
2741: end_date_app_period(p_timecard_id);
2742:
2743: hxc_timecard_summary_api.delete_timecard
2744: (p_blocks => l_blocks
2745: ,p_timecard_id => p_timecard_id
2746: );
2747:

Line 2749: hxc_timecard_audit.audit_deposit

2745: ,p_timecard_id => p_timecard_id
2746: );
2747:
2748: --l_messages.delete;
2749: hxc_timecard_audit.audit_deposit
2750: (p_transaction_info => l_transaction_info
2751: ,p_messages => l_messages
2752: );
2753: -- hxc_timecard_message_helper.processerrors

Line 2753: -- hxc_timecard_message_helper.processerrors

2749: hxc_timecard_audit.audit_deposit
2750: (p_transaction_info => l_transaction_info
2751: ,p_messages => l_messages
2752: );
2753: -- hxc_timecard_message_helper.processerrors
2754: -- (p_messages => l_messages);
2755:
2756: hxc_timecard_audit.maintain_latest_details
2757: (p_blocks => l_blocks );

Line 2756: hxc_timecard_audit.maintain_latest_details

2752: );
2753: -- hxc_timecard_message_helper.processerrors
2754: -- (p_messages => l_messages);
2755:
2756: hxc_timecard_audit.maintain_latest_details
2757: (p_blocks => l_blocks );
2758:
2759: /* Bug 8888904 */
2760: hxc_timecard_audit.maintain_rdb_snapshot

Line 2760: hxc_timecard_audit.maintain_rdb_snapshot

2756: hxc_timecard_audit.maintain_latest_details
2757: (p_blocks => l_blocks );
2758:
2759: /* Bug 8888904 */
2760: hxc_timecard_audit.maintain_rdb_snapshot
2761: (p_blocks => l_blocks,
2762: p_attributes => l_attributes);
2763:
2764: hr_utility.trace('Calling maintain_errors');

Line 2766: hxc_timecard_message_helper.prepareErrors;

2762: p_attributes => l_attributes);
2763:
2764: hr_utility.trace('Calling maintain_errors');
2765:
2766: hxc_timecard_message_helper.prepareErrors;
2767:
2768: hxc_timekeeper_errors.maintain_errors
2769: (p_messages => l_messages
2770: ,p_timecard_id => p_timecard_id

Line 2776: --l_messages := hxc_timecard_message_helper.getMessages;

2772:
2773:
2774:
2775: -- get all the errors
2776: --l_messages := hxc_timecard_message_helper.getMessages;
2777: /*
2778: if g_debug THEN
2779: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
2780: end if;

Line 2786: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors) THEN

2782:
2783: -- OTL-Absences Integration (Bug 8779478)
2784: -- Modified code to rollback in case on online retrieval errors (Bug 8888138)
2785: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
2786: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors) THEN
2787:
2788: IF g_debug THEN
2789: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMEKEEPER.DELETE_TIMECARD');
2790: END IF;

Line 2835: hxc_timecard_message_helper.prepareErrors;

2831:
2832:
2833: EXCEPTION
2834: WHEN e_timekeeper_check then
2835: hxc_timecard_message_helper.prepareErrors;
2836: rollback;
2837:
2838: End delete_timecard;
2839: