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

Line 327: from bis_obj_properties

323: is
324: CURSOR C_OBJ_LST_REFDAT(p_obj_name VARCHAR2, p_obj_type VARCHAR2)
325: IS
326: select last_refresh_date
327: from bis_obj_properties
328: where object_name= p_obj_name
329: and object_type= p_obj_type;
330: l_date DATE;
331: l_module varchar2(300) := 'bis.GET_LAST_REFRESH_DATE.'||p_obj_type||'.'||p_obj_name;

Line 336: log(l_module, 'Got ' || l_date || ' from bis_obj_properties.last_refresh_date for (' || p_obj_name ||','|| p_obj_type ||')' );

332: begin
333: open C_OBJ_LST_REFDAT(p_obj_name, p_obj_type);
334: fetch C_OBJ_LST_REFDAT into l_date;
335: close C_OBJ_LST_REFDAT;
336: log(l_module, 'Got ' || l_date || ' from bis_obj_properties.last_refresh_date for (' || p_obj_name ||','|| p_obj_type ||')' );
337: bis_collection_utilities.put_line(' '||p_obj_type||'.'||p_obj_name||': '||to_char(l_date,'DD-MON-YYYY'));
338: if (l_date is null ) then
339: return get_obj_refresh_date_old(p_obj_type,p_obj_owner,p_obj_name);
340: else

Line 392: bis_obj_properties objp

388: --- objdep.object_owner object_owner,
389: objp.object_type object_type,
390: objp.object_name object_name
391: from
392: bis_obj_properties objp
393: where objp.object_name=p_object_name
394: and objp.object_type = p_object_type;
395:
396:

Line 499: from bis_obj_properties

495:
496: function get_portlet_report_date(p_object_name in varchar2,p_object_type in varchar2) return date is
497: cursor c_direct_date is
498: select LAST_REFRESH_DATE,object_name
499: from bis_obj_properties
500: where object_name= p_object_name
501: and object_type in ('REPORT','PORTLET');
502: --and object_type=p_object_type;
503:

Line 505: l_object_name bis_obj_properties.object_name%type; --enhancement 4106617

501: and object_type in ('REPORT','PORTLET');
502: --and object_type=p_object_type;
503:
504: l_date date;
505: l_object_name bis_obj_properties.object_name%type; --enhancement 4106617
506:
507: begin
508: open c_direct_date;
509: fetch c_direct_date into l_date,l_object_name;

Line 534: bis_obj_properties table whenever the request set is re-generated in 4.0.7 and gets run

530: ---a real date, null or '01-01-1900'
531: return l_date;
532: /** Per management requirement, remove the backward compatible logic
533: We no longer derive last refresh date on the fly. The last refresh date will be updated to
534: bis_obj_properties table whenever the request set is re-generated in 4.0.7 and gets run
535: successfully
536:
537: if l_date is not null then
538: return l_date;

Line 657: from bis_obj_properties

653: /**The following cursor has the correct logic
654: but it caused number of sqls being executed exceed 10
655: cursor c_direct_date is
656: select LAST_REFRESH_DATE
657: from bis_obj_properties
658: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_page_name)
659: and object_type='PAGE';
660: **/
661:

Line 667: from bis_obj_properties

663: It can't handle the case where form function A and
664: A_OA exist for two OA pages, then two rows will be returned
665: cursor c_direct_date is
666: select LAST_REFRESH_DATE
667: from bis_obj_properties
668: where object_name=p_page_name||'_OA'
669: and object_type='PAGE'
670: union
671: select LAST_REFRESH_DATE

Line 672: from bis_obj_properties

668: where object_name=p_page_name||'_OA'
669: and object_type='PAGE'
670: union
671: select LAST_REFRESH_DATE
672: from bis_obj_properties
673: where object_name=p_page_name
674: and object_type='PAGE';
675: **/
676: cursor c_direct_date1 is

Line 678: from bis_obj_properties

674: and object_type='PAGE';
675: **/
676: cursor c_direct_date1 is
677: select LAST_REFRESH_DATE,object_name
678: from bis_obj_properties
679: where object_name=p_page_name
680: and object_type='PAGE';
681:
682: cursor c_direct_date2 is

Line 684: from bis_obj_properties

680: and object_type='PAGE';
681:
682: cursor c_direct_date2 is
683: select LAST_REFRESH_DATE,object_name
684: from bis_obj_properties
685: where object_name=p_page_name||'_OA'
686: and object_type='PAGE';
687:
688:

Line 690: l_object_name bis_obj_properties.object_name%type; --Enhancement 4106617

686: and object_type='PAGE';
687:
688:
689: l_date date;
690: l_object_name bis_obj_properties.object_name%type; --Enhancement 4106617
691:
692: begin
693: open c_direct_date1;
694: fetch c_direct_date1 into l_date,l_object_name;

Line 706: /** Bug 4257955. Return whatever date in bis_Obj_properties

702:
703:
704: -----The following code is changed for enhancement 3426538
705: if l_object_name is not null then ----the page exists in RSG
706: /** Bug 4257955. Return whatever date in bis_Obj_properties
707: The logic of '01-01-1900' is moved to update last
708: refresh date program for individual object
709: if l_date is null then
710: l_date:=to_date('01-01-1900','DD-MM-YYYY');

Line 1017: from bis_obj_properties

1013: l_indirect_obj_rec C_OBJ_TO_BE_UPDATED%rowtype;
1014:
1015: cursor c_page_name(p_name varchar2) is
1016: select object_name
1017: from bis_obj_properties
1018: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_name)
1019: and object_type='PAGE';
1020:
1021: ----This cursor is added for bug 4257955

Line 1053: l_last_refresh_date BIS_OBJ_PROPERTIES.LAST_REFRESH_DATE%TYPE;

1049: and object_type='MV';
1050:
1051:
1052:
1053: l_last_refresh_date BIS_OBJ_PROPERTIES.LAST_REFRESH_DATE%TYPE;
1054: l_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;

Line 1054: l_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;

1050:
1051:
1052:
1053: l_last_refresh_date BIS_OBJ_PROPERTIES.LAST_REFRESH_DATE%TYPE;
1054: l_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);

Line 1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;

1051:
1052:
1053: l_last_refresh_date BIS_OBJ_PROPERTIES.LAST_REFRESH_DATE%TYPE;
1054: l_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);
1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;

Line 1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;

1052:
1053: l_last_refresh_date BIS_OBJ_PROPERTIES.LAST_REFRESH_DATE%TYPE;
1054: l_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);
1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1060: l_top_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;

Line 1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;

1055: l_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);
1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1060: l_top_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1061: l_top_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1062: l_sql varchar2(2000);
1063: l_request_id_this number;

Line 1060: l_top_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;

1056: l_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);
1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1060: l_top_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1061: l_top_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1062: l_sql varchar2(2000);
1063: l_request_id_this number;
1064:

Line 1061: l_top_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;

1057: l_request_id NUMBER;
1058: l_obj_has_program varchar2(1);
1059: l_top_obj_name BIS_OBJ_PROPERTIES.OBJECT_NAME%TYPE;
1060: l_top_obj_type BIS_OBJ_PROPERTIES.OBJECT_TYPE%TYPE;
1061: l_top_obj_owner BIS_OBJ_PROPERTIES.OBJECT_OWNER%TYPE;
1062: l_sql varchar2(2000);
1063: l_request_id_this number;
1064:
1065: begin

Line 1261: ---(4) The API will return null if the object has last refresh date as null in bis_obj_properties

1257: ---Bug 4257955. Modify the function so that it has the following behavior
1258: ---(1) It is the only public API that should be called to get last refreshed date for any object
1259: ---(2) It will return string with hyper link and/or html tags
1260: ------if p_url_flag is set to 'Y'; Otherwise, it will just return the String itself
1261: ---(4) The API will return null if the object has last refresh date as null in bis_obj_properties
1262: -------OR if the object doesn't exist in RSG at all
1263: ----(5) The API will return 'Date not available' if the object has last refresh date as '01-01-1900' in
1264: --------bis_obj_properties
1265: function get_last_refreshdate_url(p_obj_type in varchar2,

Line 1264: --------bis_obj_properties

1260: ------if p_url_flag is set to 'Y'; Otherwise, it will just return the String itself
1261: ---(4) The API will return null if the object has last refresh date as null in bis_obj_properties
1262: -------OR if the object doesn't exist in RSG at all
1263: ----(5) The API will return 'Date not available' if the object has last refresh date as '01-01-1900' in
1264: --------bis_obj_properties
1265: function get_last_refreshdate_url(p_obj_type in varchar2,
1266: p_obj_owner in varchar2,
1267: p_obj_name in varchar2,
1268: p_url_flag in varchar2 default 'Y',