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.BIS_COLLECTION_UTILITIES dependencies on BIS_REFRESH_LOG

Line 155: PROCEDURE WRITE_BIS_REFRESH_LOG(

151:
152: /*
153: * Added for enhancement 3428371
154: */
155: PROCEDURE WRITE_BIS_REFRESH_LOG(
156: p_status IN BOOLEAN,
157: p_count IN NUMBER ,
158: p_message IN VARCHAR2 ,
159: p_period_from IN DATE ,

Line 186: insert into bis_refresh_log(

182: if p_status then l_status:='SUCCESS';
183: else l_status:='FAILURE';
184: end if;
185:
186: insert into bis_refresh_log(
187: Request_id,
188: Concurrent_id,
189: Object_name,
190: Status,

Line 225: log('Exception in WRITE_BIS_REFRESH_LOG '||sqlerrm,0);

221: p_attribute9, p_attribute10 );
222: commit;
223: Exception when others then
224: g_status_message:=sqlerrm;
225: log('Exception in WRITE_BIS_REFRESH_LOG '||sqlerrm,0);
226: END WRITE_BIS_REFRESH_LOG;
227:
228: ----This function checks if the program exists or not
229: function program_exist(p_program_short_name in varchar2, p_program_application_id in number) return varchar2 is

Line 226: END WRITE_BIS_REFRESH_LOG;

222: commit;
223: Exception when others then
224: g_status_message:=sqlerrm;
225: log('Exception in WRITE_BIS_REFRESH_LOG '||sqlerrm,0);
226: END WRITE_BIS_REFRESH_LOG;
227:
228: ----This function checks if the program exists or not
229: function program_exist(p_program_short_name in varchar2, p_program_application_id in number) return varchar2 is
230: l_exist_flag varchar2(1);

Line 278: WRITE_BIS_REFRESH_LOG(

274: BEGIN
275: commit;
276: disableParallelDML;
277:
278: WRITE_BIS_REFRESH_LOG(
279: p_status,
280: p_count,
281: p_message,
282: p_period_from,

Line 344: FROM bis_refresh_log

340: begin
341: /* will NOT raise a no_data_found because of MAX */
342:
343: SELECT MAX(period_to) INTO l_date
344: FROM bis_refresh_log
345: WHERE object_name = p_object_name AND
346: status='SUCCESS' AND
347: last_update_date =
348: (SELECT MAX(last_update_date)

Line 349: FROM bis_refresh_log

345: WHERE object_name = p_object_name AND
346: status='SUCCESS' AND
347: last_update_date =
348: (SELECT MAX(last_update_date)
349: FROM bis_refresh_log
350: WHERE object_name= p_object_name AND
351: status='SUCCESS' ) ;
352:
353: IF (l_date IS NULL) THEN

Line 375: from bis_refresh_log

371: p_period_to OUT NOCOPY DATE
372: ) is
373: cursor last_refresh_date_cursor(p_obj_name varchar2) is
374: select start_date, last_update_date, period_from, period_to
375: from bis_refresh_log
376: where object_name = p_obj_name and status='SUCCESS'
377: and last_update_date =( select max(last_update_date)
378: from bis_refresh_log
379: where object_name= p_obj_name and status='SUCCESS' ) ;

Line 378: from bis_refresh_log

374: select start_date, last_update_date, period_from, period_to
375: from bis_refresh_log
376: where object_name = p_obj_name and status='SUCCESS'
377: and last_update_date =( select max(last_update_date)
378: from bis_refresh_log
379: where object_name= p_obj_name and status='SUCCESS' ) ;
380: begin
381: open last_refresh_date_cursor(p_object_name);
382: fetch last_refresh_date_cursor into p_start_date, p_end_date, p_period_from, p_period_to;

Line 418: from bis_refresh_log

414: into p_attribute_table(1), p_attribute_table(2), p_attribute_table(3),
415: p_attribute_table(4), p_attribute_table(5), p_attribute_table(6),
416: p_attribute_table(7), p_attribute_table(8), p_attribute_table(9),
417: p_attribute_table(10), l_allattribute
418: from bis_refresh_log
419: where object_name = p_object_name and status='SUCCESS'
420: and last_update_date =( select max(last_update_date)
421: from bis_refresh_log
422: where object_name= p_object_name and status='SUCCESS' ) ;

Line 421: from bis_refresh_log

417: p_attribute_table(10), l_allattribute
418: from bis_refresh_log
419: where object_name = p_object_name and status='SUCCESS'
420: and last_update_date =( select max(last_update_date)
421: from bis_refresh_log
422: where object_name= p_object_name and status='SUCCESS' ) ;
423:
424: if (l_allattribute is null) then p_count:=0;
425: else p_count:=10;

Line 859: EXECUTE IMMEDIATE 'delete from bis_refresh_log where upper(object_name)=upper(:1) and error_type is null' using p_object_name;

855:
856: Procedure deleteLogForObject(p_object_name varchar2) IS
857:
858: BEGIN
859: EXECUTE IMMEDIATE 'delete from bis_refresh_log where upper(object_name)=upper(:1) and error_type is null' using p_object_name;
860:
861: END;
862:
863: FUNCTION getAppsSchema return VARCHAR2 IS

Line 1077: FROM bis_refresh_log

1073: l_date_disp varchar2(100);
1074: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';
1075: begin
1076: SELECT MAX(period_to) INTO l_date
1077: FROM bis_refresh_log
1078: WHERE object_name = p_object_name AND
1079: status='FAILURE' AND
1080: last_update_date = (
1081: SELECT MAX(last_update_date)

Line 1082: FROM bis_refresh_log

1078: WHERE object_name = p_object_name AND
1079: status='FAILURE' AND
1080: last_update_date = (
1081: SELECT MAX(last_update_date)
1082: FROM bis_refresh_log
1083: WHERE object_name= p_object_name AND
1084: status='FAILURE' ) ;
1085: IF (l_date IS NULL) THEN
1086: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');

Line 1116: FROM bis_refresh_log

1112:
1113: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';
1114: begin
1115: SELECT period_to, period_from INTO l_date_to,l_date_from
1116: FROM bis_refresh_log
1117: WHERE object_name = p_object_name AND
1118: status='FAILURE' AND
1119: last_update_date = (
1120: SELECT MAX(last_update_date)

Line 1121: FROM bis_refresh_log

1117: WHERE object_name = p_object_name AND
1118: status='FAILURE' AND
1119: last_update_date = (
1120: SELECT MAX(last_update_date)
1121: FROM bis_refresh_log
1122: WHERE object_name= p_object_name AND
1123: status='FAILURE' )AND
1124: rownum = 1
1125: ORDER BY period_to desc ;