APPS.EDW_HR_PERSON_M_C dependencies on EDW_COLLECTION_UTIL

Line 356: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN

352: -- -------------------------------------------
353: Begin
354: Errbuf :=NULL;
355: Retcode:=0;
356: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
357: errbuf := fnd_message.get;
358: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
359: Return;
360: END IF;

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 364: EDW_COLLECTION_UTIL.g_offset;

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;
368:

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 437: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );

433: edw_log.put_line(' ');
434: -- ---------------------------------------------------------------------------
435: -- END OF Collection , Developer Customizable Section
436: -- ---------------------------------------------------------------------------
437: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );
438: commit;
439:
440: Exception When others then
441: Errbuf:=sqlerrm;

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: