[Home] [Help]
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: /*
8: Procedure which will dump data into temporary table
9: hxc_tcd_timecards and hxc_tcd_status_count.
10: */
11: PROCEDURE go(p_recurring_period IN varchar2 default Null,
12: p_supervisor_id IN Number,
13: p_reptng_emp IN varchar2,
417:
418: DELETE FROM HXC_TCD_TIMECARDS
419: WHERE user_id = p_user_id;
420:
421: DELETE FROM HXC_TCD_STATUS_COUNT
422: WHERE user_id = p_user_id;
423:
424: COMMIT;
425:
462: DELETE FROM HXC_TCD_TIMECARDS
463: WHERE user_id = l_login_ids(i);
464:
465: FORALL i IN l_login_ids.FIRST..l_login_ids.LAST
466: DELETE FROM HXC_TCD_STATUS_COUNT
467: WHERE user_id = l_login_ids(i);
468:
469: END LOOP;
470: CLOSE c_get_inactive_sessions;
2520:
2521: END insert_timecard_not_exist;
2522:
2523: /*
2524: Procedure to insert data in temporary table hxc_tcd_status_count
2525: for timecard's count
2526: */
2527:
2528: --- *** Add Login id into the tables here.
2535: l_proc := g_package||'insert_timecard_count';
2536: hr_utility.set_location('Entering:'|| l_proc, 10);
2537: END IF;
2538:
2539: INSERT INTO HXC_TCD_STATUS_COUNT(supervisor_id,supervisor_name,not_enetered,working,error, submitted,rejected,approved,user_id)
2540: SELECT
2541: supervisor_id,
2542: supervisor,
2543: max(decode(approval_status
2592:
2593: END insert_timecard_count;
2594:
2595: /*
2596: Procedure to update total in temporary table hxc_tcd_status_count
2597:
2598: */
2599: PROCEDURE update_total(p_user_id IN number)
2600: AS
2602: IS
2603: SELECT
2604: not_enetered + working + error + submitted + rejected + approved "Total", supervisor_id
2605: FROM
2606: hxc_tcd_status_count
2607: WHERE user_id = p_user_id;
2608:
2609: l_supervisor_ids NUMBERTAB;
2610: l_totals NUMBERTAB;
2618: END LOOP;
2619: CLOSE c_calc_total;
2620:
2621: FORALL i IN l_totals.FIRST..l_totals.LAST
2622: UPDATE hxc_tcd_status_count
2623: SET total = l_totals(i)
2624: WHERE user_id = p_user_id
2625: AND supervisor_id = l_supervisor_ids(i);
2626: