APPS.BIL_BI_OPDTL_F_PKG dependencies on BIS_REFRESH_LOG

Line 103: FROM bis_refresh_log

99: begin
100: l_proc := 'get_last_failure_period';
101:
102: SELECT MAX(period_to) INTO l_date
103: FROM bis_refresh_log
104: WHERE object_name = p_object_name AND
105: status='FAILURE' AND
106: last_update_date =(SELECT MAX(last_update_date)
107: FROM bis_refresh_log

Line 107: FROM bis_refresh_log

103: FROM bis_refresh_log
104: WHERE object_name = p_object_name AND
105: status='FAILURE' AND
106: last_update_date =(SELECT MAX(last_update_date)
107: FROM bis_refresh_log
108: WHERE object_name= p_object_name AND
109: status='FAILURE' ) ;
110:
111: IF (l_date IS NULL) THEN

Line 141: FROM bis_refresh_log

137: begin
138: l_proc := 'get_first_success_period';
139:
140: SELECT MIN(period_from) INTO l_date
141: FROM bis_refresh_log
142: WHERE object_name = p_object_name AND
143: status='SUCCESS' AND
144: last_update_date =(SELECT MIN(last_update_date)
145: FROM bis_refresh_log

Line 145: FROM bis_refresh_log

141: FROM bis_refresh_log
142: WHERE object_name = p_object_name AND
143: status='SUCCESS' AND
144: last_update_date =(SELECT MIN(last_update_date)
145: FROM bis_refresh_log
146: WHERE object_name= p_object_name AND
147: status='SUCCESS' ) ;
148:
149: IF (l_date IS NULL) THEN

Line 476: BIS_COLLECTION_UTILITIES.WRITE_BIS_REFRESH_LOG(

472:
473: l_bis_status := TRUE;
474: l_bis_message := 'Successful resumed from last run.';
475:
476: BIS_COLLECTION_UTILITIES.WRITE_BIS_REFRESH_LOG(
477: l_bis_status,
478: g_row_num ,
479: l_bis_message ,
480: g_start_date ,

Line 594: p_msg => 'L_max_date from bis_refresh_log:'||l_max_date);

590: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
591: bil_bi_util_collection_pkg.writeLog(
592: p_log_level => fnd_log.LEVEL_EVENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'L_max_date from bis_refresh_log:'||l_max_date);
595: END IF;
596:
597: IF (p_start_date IS NOT NULL) THEN
598: G_Start_date := l_max_date;