DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SUMMARY_API dependencies on HXC_TIMECARD_SUMMARY_PKG

Line 6: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

2: /* $Header: hxctcsumapi.pkb 120.2.12020000.2 2012/07/04 09:36:11 amnaraya ship $ */
3: Procedure delete_timecard
4: (p_blocks in hxc_block_table_type
5: ,p_timecard_id in number
6: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
7: ) is
8:
9: l_index number;
10: l_previous_status hxc_timecard_summary.approval_status%type;

Line 54: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

50: -- indicating that there might still be an open notification
51: -- that requires cancellation.
52:
53: --
54: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
55: open c_previously_submitted(p_timecard_id);
56: fetch c_previously_submitted into l_previous_status;
57: if (c_previously_submitted%found) then
58: /*

Line 101: hxc_timecard_summary_pkg.delete_summary_row

97:
98: -- 2. Delete the existing timecard information in the summary
99: --
100:
101: hxc_timecard_summary_pkg.delete_summary_row
102: (p_timecard_id => p_timecard_id);
103:
104: End delete_timecard;
105:

Line 108: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

104: End delete_timecard;
105:
106: Procedure delete_timecard
107: (p_timecard_id in hxc_timecard_summary.timecard_id%type
108: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
109: ) is
110:
111: l_index number;
112:

Line 145: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

141: --
142: -- 0. Close all nofications associated with this timecard, only
143: -- if we're not migrating.
144: --
145: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then
146:
147:
148: open c_previously_submitted(p_timecard_id);
149: fetch c_previously_submitted into l_dummy;

Line 192: hxc_timecard_summary_pkg.delete_summary_row

188: end if;
189:
190: -- 2. Delete the existing timecard information in the summary
191:
192: hxc_timecard_summary_pkg.delete_summary_row
193: (p_timecard_id => p_timecard_id);
194:
195: End delete_timecard;
196:

Line 251: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

247: End cleanup_timecards;
248:
249: procedure timecard_deposit
250: (p_blocks in hxc_block_table_type
251: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
252: ,p_approval_item_type in varchar2
253: ,p_approval_process_name in varchar2
254: ,p_approval_item_key in varchar2
255: ,p_tk_audit_item_type in varchar2

Line 274: hxc_timecard_summary_pkg.insert_summary_row

270: cleanup_timecards(p_blocks);
271: --
272: -- 3. Create timecard summary info
273: --
274: hxc_timecard_summary_pkg.insert_summary_row
275: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id
276: ,p_mode => p_mode
277: ,p_approval_item_type => p_approval_item_type
278: ,p_approval_process_name => p_approval_process_name

Line 288: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then

284: --
285: -- 4. Create the link information if the
286: -- mode is migration
287: --
288: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then
289: hxc_tc_ap_links_pkg.create_timecard_links
290: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id);
291: end if;
292: End timecard_deposit;

Line 296: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

292: End timecard_deposit;
293:
294: Procedure timecard_deposit
295: (p_timecard_id in hxc_timecard_summary.timecard_id%type
296: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
297: ,p_approval_item_type in varchar2
298: ,p_approval_process_name in varchar2
299: ,p_approval_item_key in varchar2
300: ,p_tk_audit_item_type in varchar2

Line 316: hxc_timecard_summary_pkg.insert_summary_row

312: delete_timecard(p_timecard_id, p_mode);
313: --
314: -- 3. Create timecard summary info
315: --
316: hxc_timecard_summary_pkg.insert_summary_row
317: (p_timecard_id => p_timecard_id
318: ,p_mode => p_mode
319: ,p_approval_item_type => p_approval_item_type
320: ,p_approval_process_name => p_approval_process_name

Line 338: delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);

334: Begin
335:
336: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
337:
338: delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);
339:
340: End timecard_delete;
341:
342: Procedure timecard_delete

Line 347: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);

343: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
344:
345: Begin
346:
347: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);
348:
349: End timecard_delete;
350:
351: procedure reject_timecards

Line 371: hxc_timecard_summary_pkg.reject_timecard(tc_rec.timecard_id);

367:
368: Begin
369:
370: for tc_rec in c_timecards(p_application_period_id) loop
371: hxc_timecard_summary_pkg.reject_timecard(tc_rec.timecard_id);
372: end loop;
373:
374: End reject_timecards;
375:

Line 405: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);

401: --
402: -- It doesn't matter about the other approval periods
403: -- just set the timecards to submitted.
404: --
405: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
406: elsif(tc_check.approval_status = hxc_timecard.c_rejected_status) then
407: --
408: -- It must be rejected, therefore we should check to see if we
409: -- can upgrade to submitted status (since we only look for APPROVED

Line 418: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);

414: if (c_any_reject_app_periods%notfound) then
415: --
416: -- There are no more REJECTED app periods update to
417: -- submitted.
418: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
419: end if;
420: close c_any_reject_app_periods;
421: else
422: -- Timecard status should not be changed if it is submitted or

Line 467: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);

463: close c_any_non_approved_app_periods;
464: --
465: -- We can appprove this timecard!
466: --
467: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
468: else
469: close c_any_non_approved_app_periods;
470: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
471: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);

Line 471: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);

467: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
468: else
469: close c_any_non_approved_app_periods;
470: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
471: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);
472: end if;
473: end if;
474: end loop;
475: