DBA Data[Home] [Help]

APPS.BIS_RSG_PMV_REPORT_PKG dependencies on FND_PROFILE

Line 151: return to_char(l_client_date,FND_PROFILE.value('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS');

147: ,from_tz => l_server_code
148: ,to_tz => l_client_code
149: );
150: --convert the date format
151: return to_char(l_client_date,FND_PROFILE.value('ICX_DATE_FORMAT_MASK') || ' HH24:MI:SS');
152: END date_to_charDTTZ;
153:
154: PROCEDURE request_set_perf_report
155: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

Line 783: fnd_profile.get('APPS_FRAMEWORK_AGENT', base);

779:
780: END LOOP;
781:
782: counter := 1;
783: fnd_profile.get('APPS_FRAMEWORK_AGENT', base);
784:
785: l_sql_stmt:='select distinct object_name BIS_REQUEST_OBJECT_NAME,
786: --BIS_REQUESTSET_VIEWHISTORY.get_bis_lookup_meaning( ''BIS_OBJECT_TYPE'',O.OBJECT_TYPE) BIS_REQUEST_OBJECT_TYPE,
787: CASE O.OBJECT_TYPE WHEN ''MV_LOG'' THEN BIS_REQUESTSET_VIEWHISTORY.get_sys_lookup_meaning( ''BIS_OBJECT_TYPE_RPT'',O.OBJECT_TYPE)

Line 930: fnd_profile.get('APPS_FRAMEWORK_AGENT', base);

926:
927: END LOOP;
928:
929: counter := 1;
930: fnd_profile.get('APPS_FRAMEWORK_AGENT', base);
931:
932: l_sql_stmt:='SELECT Distinct OBJECT_NAME BIS_REQUEST_OBJECT_NAME,
933: --BIS_REQUESTSET_VIEWHISTORY.get_bis_lookup_meaning( ''BIS_OBJECT_TYPE'',O.OBJECT_TYPE) BIS_REQUEST_OBJECT_TYPE,
934: CASE O.OBJECT_TYPE WHEN ''MV_LOG'' THEN BIS_REQUESTSET_VIEWHISTORY.get_sys_lookup_meaning( ''BIS_OBJECT_TYPE_RPT'',O.OBJECT_TYPE)