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.EDW_HR_PERSON_M_C dependencies on EDW_HR_PERSON_M_C

Line 1: Package Body EDW_HR_PERSON_M_C AS

1: Package Body EDW_HR_PERSON_M_C AS
2: /* $Header: hrieppsn.pkb 120.1 2005/06/07 05:59:25 anmajumd noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 363: EDW_HR_PERSON_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

359: Return;
360: END IF;
361:
362: IF (p_from_date IS NULL) THEN
363: EDW_HR_PERSON_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
364: EDW_COLLECTION_UTIL.g_offset;
365: ELSE
366: EDW_HR_PERSON_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
367: END IF;

Line 366: EDW_HR_PERSON_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');

362: IF (p_from_date IS NULL) THEN
363: EDW_HR_PERSON_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
364: EDW_COLLECTION_UTIL.g_offset;
365: ELSE
366: EDW_HR_PERSON_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
367: END IF;
368:
369: IF (p_to_date IS NULL) THEN
370: EDW_HR_PERSON_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

Line 370: EDW_HR_PERSON_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

366: EDW_HR_PERSON_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
367: END IF;
368:
369: IF (p_to_date IS NULL) THEN
370: EDW_HR_PERSON_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
371: ELSE
372: EDW_HR_PERSON_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
373: END IF;
374:

Line 372: EDW_HR_PERSON_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

368:
369: IF (p_to_date IS NULL) THEN
370: EDW_HR_PERSON_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
371: ELSE
372: EDW_HR_PERSON_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
373: END IF;
374:
375:
376: edw_log.put_line( 'The collection range is from '||

Line 377: to_char(EDW_HR_PERSON_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

373: END IF;
374:
375:
376: edw_log.put_line( 'The collection range is from '||
377: to_char(EDW_HR_PERSON_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
378: to_char(EDW_HR_PERSON_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
379: edw_log.put_line(' ');
380:
381:

Line 378: to_char(EDW_HR_PERSON_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

374:
375:
376: edw_log.put_line( 'The collection range is from '||
377: to_char(EDW_HR_PERSON_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
378: to_char(EDW_HR_PERSON_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
379: edw_log.put_line(' ');
380:
381:
382: -- -----------------------------------------------------------------------------

Line 411: EDW_HR_PERSON_M_C.Push_Tree(

407: edw_log.put_line( ' ' );
408: edw_log.put_line( 'About to call Supervisor Tree routine' );
409: edw_log.put_line( ' ' );
410:
411: EDW_HR_PERSON_M_C.Push_Tree(
412: p_from_date => g_push_date_range1,
413: p_to_date => g_push_date_range2,
414: p_tree => 1 );
415:

Line 426: Push_EDW_HR_PERM_ASSIGN_LSTG(EDW_HR_PERSON_M_C.g_push_date_range1, EDW_HR_PERSON_M_C.g_push_date_range2);

422: edw_log.put_line('Pushing data');
423:
424: l_temp_date := sysdate;
425:
426: Push_EDW_HR_PERM_ASSIGN_LSTG(EDW_HR_PERSON_M_C.g_push_date_range1, EDW_HR_PERSON_M_C.g_push_date_range2);
427:
428:
429: l_duration := sysdate - l_temp_date;
430:

Line 444: EDW_HR_PERSON_M_C.g_exception_msg := l_exception_msg;

440: Exception When others then
441: Errbuf:=sqlerrm;
442: Retcode:=sqlcode;
443: l_exception_msg := Retcode || ':' || Errbuf;
444: EDW_HR_PERSON_M_C.g_exception_msg := l_exception_msg;
445: rollback;
446: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PERSON_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
447:
448: commit;

Line 446: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PERSON_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

442: Retcode:=sqlcode;
443: l_exception_msg := Retcode || ':' || Errbuf;
444: EDW_HR_PERSON_M_C.g_exception_msg := l_exception_msg;
445: rollback;
446: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PERSON_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
447:
448: commit;
449: End;
450:

Line 603: EDW_HR_PERSON_M_C.g_row_count := EDW_HR_PERSON_M_C.g_row_count + l_rows_inserted ;

599: from EDW_HR_PERM_ASSIGN_LCV@APPS_TO_APPS plcv
600: where plcv.last_update_date between l_date1 and l_date2;
601: --
602: l_rows_inserted := sql%rowcount;
603: EDW_HR_PERSON_M_C.g_row_count := EDW_HR_PERSON_M_C.g_row_count + l_rows_inserted ;
604: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
605: ' rows into the EDW_HR_PERM_ASSIGN_LSTG staging table');
606: edw_log.put_line('Commiting records for EDW_HR_PERM_ASSIGN_LSTG');
607: commit;

Line 620: End EDW_HR_PERSON_M_C;

616:
617: SELECT instance_code INTO g_instance_code
618: FROM edw_local_instance;
619:
620: End EDW_HR_PERSON_M_C;