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.0.12010000.3 2008/08/05 12:06:35 ubhat 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 242: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

238: End cleanup_timecards;
239:
240: procedure timecard_deposit
241: (p_blocks in hxc_block_table_type
242: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
243: ,p_approval_item_type in varchar2
244: ,p_approval_process_name in varchar2
245: ,p_approval_item_key in varchar2
246: ,p_tk_audit_item_type in varchar2

Line 265: hxc_timecard_summary_pkg.insert_summary_row

261: cleanup_timecards(p_blocks);
262: --
263: -- 3. Create timecard summary info
264: --
265: hxc_timecard_summary_pkg.insert_summary_row
266: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id
267: ,p_mode => p_mode
268: ,p_approval_item_type => p_approval_item_type
269: ,p_approval_process_name => p_approval_process_name

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

275: --
276: -- 4. Create the link information if the
277: -- mode is migration
278: --
279: if(p_mode = hxc_timecard_summary_pkg.c_migration_mode) then
280: hxc_tc_ap_links_pkg.create_timecard_links
281: (p_timecard_id => p_blocks(l_timecard_index).time_building_block_id);
282: end if;
283: End timecard_deposit;

Line 287: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode

283: End timecard_deposit;
284:
285: Procedure timecard_deposit
286: (p_timecard_id in hxc_timecard_summary.timecard_id%type
287: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
288: ,p_approval_item_type in varchar2
289: ,p_approval_process_name in varchar2
290: ,p_approval_item_key in varchar2
291: ,p_tk_audit_item_type in varchar2

Line 307: hxc_timecard_summary_pkg.insert_summary_row

303: delete_timecard(p_timecard_id, p_mode);
304: --
305: -- 3. Create timecard summary info
306: --
307: hxc_timecard_summary_pkg.insert_summary_row
308: (p_timecard_id => p_timecard_id
309: ,p_mode => p_mode
310: ,p_approval_item_type => p_approval_item_type
311: ,p_approval_process_name => p_approval_process_name

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

325: Begin
326:
327: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
328:
329: delete_timecard(p_blocks,l_timecard_index, hxc_timecard_summary_pkg.c_normal_mode);
330:
331: End timecard_delete;
332:
333: Procedure timecard_delete

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

334: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
335:
336: Begin
337:
338: delete_timecard(p_timecard_id, hxc_timecard_summary_pkg.c_normal_mode);
339:
340: End timecard_delete;
341:
342: procedure reject_timecards

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

358:
359: Begin
360:
361: for tc_rec in c_timecards(p_application_period_id) loop
362: hxc_timecard_summary_pkg.reject_timecard(tc_rec.timecard_id);
363: end loop;
364:
365: End reject_timecards;
366:

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

392: --
393: -- It doesn't matter about the other approval periods
394: -- just set the timecards to submitted.
395: --
396: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
397: elsif(tc_check.approval_status = hxc_timecard.c_rejected_status) then
398: --
399: -- It must be rejected, therefore we should check to see if we
400: -- can upgrade to submitted status (since we only look for APPROVED

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

405: if (c_any_reject_app_periods%notfound) then
406: --
407: -- There are no more REJECTED app periods update to
408: -- submitted.
409: hxc_timecard_summary_pkg.submit_timecard(tc_check.timecard_id);
410: end if;
411: close c_any_reject_app_periods;
412: else
413: -- Timecard status should not be changed if it is submitted or

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

454: close c_any_non_approved_app_periods;
455: --
456: -- We can appprove this timecard!
457: --
458: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
459: else
460: close c_any_non_approved_app_periods;
461: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
462: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);

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

458: hxc_timecard_summary_pkg.approve_timecard(tc_check.timecard_id);
459: else
460: close c_any_non_approved_app_periods;
461: if(l_dummy_approval = hxc_timecard.c_rejected_status) then
462: hxc_timecard_summary_pkg.reject_timecard(tc_check.timecard_id);
463: end if;
464: end if;
465: end loop;
466: