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_BIA_RSG_LOG_MGMNT dependencies on BIS_OBJ_PROPERTIES

Line 98: update bis_obj_properties set snapshot_log_sql= p_snapshot_log_sql

94: procedure update_mv_log_sql(p_base_object_name in varchar2,
95: p_base_object_type in varchar2,
96: p_snapshot_log_sql in CLOB) is
97: begin
98: update bis_obj_properties set snapshot_log_sql= p_snapshot_log_sql
99: where object_name=p_base_object_name
100: and object_type=p_base_object_type;
101: commit;
102: exception

Line 112: update bis_obj_properties

108: procedure update_mv_log_status(p_base_object_name in varchar2,
109: p_base_object_type in varchar2,
110: p_status in varchar2) is
111: begin
112: update bis_obj_properties
113: set mv_log_status=p_status,
114: status_time_stamp=sysdate
115: where object_name=p_base_object_name
116: and object_type=p_base_object_type;

Line 161: from bis_obj_properties

157: OR filename = LOWER(p_base_object_name) || '.xdf'
158: )
159: and acf.creation_date>
160: (select STATUS_TIME_STAMP
161: from bis_obj_properties
162: where object_name=upper(p_base_object_name)
163: and object_type=p_base_object_type)
164: GROUP BY af.filename;
165:

Line 178: from bis_obj_properties

174: OR filename = LOWER(p_base_object_name)||'_mlog'|| '.xdf'
175: )
176: and acf.creation_date>
177: (select STATUS_TIME_STAMP
178: from bis_obj_properties
179: where object_name=upper(p_base_object_name)
180: and object_type=p_base_object_type)
181: GROUP BY af.filename;
182:

Line 216: from bis_obj_properties

212: function check_obj_recreated (p_base_object_name in varchar2,p_base_object_type in varchar2,P_base_object_schema in varchar2) return varchar2 is
213:
214: cursor c_mv_creation_date_in_rsg is
215: select OBJECT_CREATION_DATE
216: from bis_obj_properties
217: where object_name=p_base_object_name
218: and object_type=p_base_object_type;
219:
220: l_mv_creation_date_dd date;

Line 246: update bis_obj_properties

242:
243: procedure update_obj_creation_date(p_base_object_name in varchar2,p_base_object_type in varchar2,p_base_object_schema in varchar2) is
244:
245: begin
246: update bis_obj_properties
247: set OBJECT_CREATION_DATE=get_mv_creation_date_dd(p_base_object_name,p_base_object_type,p_base_object_schema)
248: where object_type=p_base_object_type
249: and object_name=p_base_object_name;
250:

Line 339: from bis_obj_properties

335: ); END;
336: ';
337: cursor c_obj_properties is
338: select snapshot_log_sql,mv_log_status
339: from bis_obj_properties
340: where object_name=p_base_object_name
341: and object_type=P_base_object_type;
342:
343: cursor log_exist is

Line 352: l_mv_log_status bis_obj_properties.mv_log_status%type;

348: from all_snapshot_logs
349: where master=p_base_object_name
350: and log_owner=p_base_object_schema);
351:
352: l_mv_log_status bis_obj_properties.mv_log_status%type;
353: l_mv_log_sql_stored bis_obj_properties.snapshot_log_sql%type;
354: l_program_status boolean:=true;
355: l_log_exist varchar2(1);
356: l_mv_log_name VARCHAR2(30);

Line 353: l_mv_log_sql_stored bis_obj_properties.snapshot_log_sql%type;

349: where master=p_base_object_name
350: and log_owner=p_base_object_schema);
351:
352: l_mv_log_status bis_obj_properties.mv_log_status%type;
353: l_mv_log_sql_stored bis_obj_properties.snapshot_log_sql%type;
354: l_program_status boolean:=true;
355: l_log_exist varchar2(1);
356: l_mv_log_name VARCHAR2(30);
357:

Line 468: WRITELOG('Update BIS_OBJ_PROPERTIES TABLE with captured MV log definition');

464: p_base_object_type ,
465: 'CAPTURED') ;
466:
467: WRITELOG('Captured MV log definition for '|| form_triplet(p_base_object_name, P_base_object_schema, P_base_object_type) || 'is not null');
468: WRITELOG('Update BIS_OBJ_PROPERTIES TABLE with captured MV log definition');
469: -- aguwalan: bug#4898446 :Capture Index(if any) on MVLog
470: l_mv_log_name := get_mview_log_name(p_base_object_name, P_base_object_schema);
471: WRITELOG('Capturing Index on MV log '|| form_triplet(l_mv_log_name, P_base_object_schema, 'MVLog'));
472: capture_mv_log_index(l_mv_log_name, P_base_object_schema);

Line 582: bis_obj_properties PRP,

578: l_index integer := 0;
579: l_stmt varchar2(32767) := 'BEGIN
580: select count(*) into :l_count
581: from
582: bis_obj_properties PRP,
583: All_SNAPSHOT_LOGS LOG
584: where
585: log.master = PRP.object_name
586: and OBJECT_TYPE = :P_base_object_type

Line 619: from bis_obj_properties

615:
616: setTimer(l_time);
617: begin
618: select snapshot_log_sql into l_snapshot_log_sql_handle
619: from bis_obj_properties
620: where object_name = p_base_object_name
621: and object_type = P_base_object_type;
622: exception when no_data_found then
623: WRITELOG(form_triplet(p_base_object_name, P_base_object_schema, P_base_object_type) || ' not seeded in RSG,

Line 752: from bis_obj_properties

748: return;
749: end if;
750:
751: select implementation_flag into l_impl
752: from bis_obj_properties
753: where object_name = P_OBJ_NAME
754: and object_type = 'TABLE';
755: if (l_impl <> 'Y') then
756: WRITELOG( P_OBJ_NAME || 'is not implemented, No further action performed!');

Line 810: from bis_obj_properties

806: return;
807: end if;
808:
809: select implementation_flag into l_impl
810: from bis_obj_properties
811: where object_name = P_OBJ_NAME
812: and object_type = 'TABLE';
813: if (l_impl <> 'Y') then
814: WRITELOG( P_OBJ_NAME || 'is not implemented, no further action performed!');

Line 870: BIS_OBJ_PROPERTIES P

866: connect by object_name = prior depend_object_name
867: and object_type = prior depend_object_type
868: and enabled_flag = ''Y''
869: ) PRP,
870: BIS_OBJ_PROPERTIES P
871: where prp.object_name = p.object_name
872: and prp.object_type = p.object_type
873: and p.implementation_flag = ''Y''
874: order by PRP.object_type, PRP.object_name

Line 877: l_object_name bis_obj_properties.object_name%type;

873: and p.implementation_flag = ''Y''
874: order by PRP.object_type, PRP.object_name
875: ';
876:
877: l_object_name bis_obj_properties.object_name%type;
878: l_object_type bis_obj_properties.object_type%type;
879: l_object_owner all_objects.owner%type;
880: BEGIN
881: errbuf := NULL;

Line 878: l_object_type bis_obj_properties.object_type%type;

874: order by PRP.object_type, PRP.object_name
875: ';
876:
877: l_object_name bis_obj_properties.object_name%type;
878: l_object_type bis_obj_properties.object_type%type;
879: l_object_owner all_objects.owner%type;
880: BEGIN
881: errbuf := NULL;
882: retcode := '0';

Line 951: l_object_name bis_obj_properties.object_name%type;

947: and object_type = prior depend_object_type
948: ) PRP
949: order by object_type, object_name';
950:
951: l_object_name bis_obj_properties.object_name%type;
952: l_object_type bis_obj_properties.object_type%type;
953: l_object_owner all_objects.owner%type;
954: BEGIN
955: --OPEN c_all_log_base_obj(p_request_set_name);

Line 952: l_object_type bis_obj_properties.object_type%type;

948: ) PRP
949: order by object_type, object_name';
950:
951: l_object_name bis_obj_properties.object_name%type;
952: l_object_type bis_obj_properties.object_type%type;
953: l_object_owner all_objects.owner%type;
954: BEGIN
955: --OPEN c_all_log_base_obj(p_request_set_name);
956: WRITELOG('Executing the following: ' || l_stmt || '; using ' || p_request_set_name);