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_UTIL dependencies on BIS_UTIL

Line 1: package body BIS_UTIL as

1: package body BIS_UTIL as
2: /* $Header: BISUTILB.pls 120.32 2007/12/27 13:36:24 lbodired ship $ */
3:
4: --/////////////////Added for Simulation Enhancement /////////////////
5:

Line 70: IF length(p_short_name) > BIS_UTIL.G_SHORT_NAME_LEN THEN

66: RETURN;
67: END IF;
68:
69: -- user entered short_name, use appropriate length check
70: IF length(p_short_name) > BIS_UTIL.G_SHORT_NAME_LEN THEN
71: FND_MESSAGE.Set_Name('BIS','BIS_SHORT_NAME_LEN');
72: fnd_msg_pub.add;
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;

Line 152: ,p_BIS_Report_Tbl IN BIS_UTIL.BIS_Report_Tbl_Type

148: ,p_exception_date IN date
149: ,p_item_type IN Varchar2
150: ,p_wf_process IN Varchar2
151: ,p_notify_resp_name IN Varchar2
152: ,p_BIS_Report_Tbl IN BIS_UTIL.BIS_Report_Tbl_Type
153: ,p_BIS_Cached_Report_Tbl IN BIS_UTIL.BIS_Cached_Report_Tbl_Type
154: ,x_return_status OUT NOCOPY Varchar2
155: )
156: IS

Line 153: ,p_BIS_Cached_Report_Tbl IN BIS_UTIL.BIS_Cached_Report_Tbl_Type

149: ,p_item_type IN Varchar2
150: ,p_wf_process IN Varchar2
151: ,p_notify_resp_name IN Varchar2
152: ,p_BIS_Report_Tbl IN BIS_UTIL.BIS_Report_Tbl_Type
153: ,p_BIS_Cached_Report_Tbl IN BIS_UTIL.BIS_Cached_Report_Tbl_Type
154: ,x_return_status OUT NOCOPY Varchar2
155: )
156: IS
157: l_live_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

Line 157: l_live_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

153: ,p_BIS_Cached_Report_Tbl IN BIS_UTIL.BIS_Cached_Report_Tbl_Type
154: ,x_return_status OUT NOCOPY Varchar2
155: )
156: IS
157: l_live_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
158: l_cached_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
159: l_count NUMBER := 0;
160:
161: BEGIN

Line 158: l_cached_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

154: ,x_return_status OUT NOCOPY Varchar2
155: )
156: IS
157: l_live_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
158: l_cached_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
159: l_count NUMBER := 0;
160:
161: BEGIN
162:

Line 167: BIS_UTIL.Build_Report_URL

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: FOR i IN 1..p_BIS_Report_Tbl.Count LOOP
166:
167: BIS_UTIL.Build_Report_URL
168: ( p_report_type => p_BIS_Report_Tbl(i).Report_Type
169: , p_reportFn_name => p_BIS_Report_Tbl(i).reportFN_Name
170: , p_region_code => p_BIS_Report_Tbl(i).region_code
171: , p_report_resp_id => p_BIS_Report_Tbl(i).report_resp_id

Line 182: BIS_UTIL.Build_Report_URL

178:
179:
180: FOR i IN 1..p_BIS_Cached_Report_Tbl.Count LOOP
181:
182: BIS_UTIL.Build_Report_URL
183: ( p_report_type => p_BIS_Cached_Report_Tbl(i).Report_Type
184: , p_report_identifier => p_BIS_Cached_Report_Tbl(i).report_identifier
185: , x_report_url => l_cached_url_tbl(i)
186: , x_return_status => x_return_status

Line 191: BIS_UTIL.Start_Workflow_Engine

187: );
188: END LOOP;
189:
190:
191: BIS_UTIL.Start_Workflow_Engine
192: ( p_exception_message => p_exception_message
193: , p_msg_subject => p_msg_subject
194: , p_exception_date => p_exception_date
195: , p_item_type => p_item_type

Line 219: ,p_Oracle_Report_Tbl IN BIS_UTIL.Oracle_Report_Tbl_Type

215: ,p_exception_date IN date
216: ,p_item_type IN Varchar2
217: ,p_wf_process IN Varchar2
218: ,p_notify_resp_name IN Varchar2
219: ,p_Oracle_Report_Tbl IN BIS_UTIL.Oracle_Report_Tbl_Type
220: ,x_return_status OUT NOCOPY Varchar2
221: )
222: IS
223: l_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

Line 223: l_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

219: ,p_Oracle_Report_Tbl IN BIS_UTIL.Oracle_Report_Tbl_Type
220: ,x_return_status OUT NOCOPY Varchar2
221: )
222: IS
223: l_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
224:
225: BEGIN
226:
227: FOR i IN 1..p_Oracle_Report_Tbl.Count LOOP

Line 228: BIS_UTIL.Build_Report_URL

224:
225: BEGIN
226:
227: FOR i IN 1..p_Oracle_Report_Tbl.Count LOOP
228: BIS_UTIL.Build_Report_URL
229: ( p_report_type => p_Oracle_Report_Tbl(i).Report_Type
230: , p_report_name => p_Oracle_Report_Tbl(i).report_name
231: , p_report_params => p_Oracle_Report_Tbl(i).report_params
232: , p_report_resp_id => p_Oracle_Report_Tbl(i).report_resp_id

Line 238: BIS_UTIL.Start_Workflow_Engine

234: , x_return_status => x_return_status
235: );
236: END LOOP;
237:
238: BIS_UTIL.Start_Workflow_Engine
239: ( p_exception_message => p_exception_message
240: , p_msg_subject => p_msg_subject
241: , p_exception_date => p_exception_date
242: , p_item_type => p_item_type

Line 285: l_url_tbl BIS_UTIL.Report_URL_Tbl_Type;

281: ,p_report_app3_id NUMBER default null
282: ,p_report_app4_id NUMBER default null
283: )
284: IS
285: l_url_tbl BIS_UTIL.Report_URL_Tbl_Type;
286:
287: BEGIN
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:

Line 292: BIS_UTIL.Build_Report_URL

288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: -- 11.5 only excepted up to 4 report URLs
291: --
292: BIS_UTIL.Build_Report_URL
293: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
294: , p_report_name => p_report_name1
295: , p_report_params => p_report_param1
296: , p_report_resp_id => p_report_resp1_id

Line 293: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE

289:
290: -- 11.5 only excepted up to 4 report URLs
291: --
292: BIS_UTIL.Build_Report_URL
293: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
294: , p_report_name => p_report_name1
295: , p_report_params => p_report_param1
296: , p_report_resp_id => p_report_resp1_id
297: , p_report_app_id => p_report_app1_id

Line 301: BIS_UTIL.Build_Report_URL

297: , p_report_app_id => p_report_app1_id
298: , x_report_url => l_url_tbl(1)
299: , x_return_status => x_return_status
300: );
301: BIS_UTIL.Build_Report_URL
302: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
303: , p_report_name => p_report_name2
304: , p_report_params => p_report_param2
305: , p_report_resp_id => p_report_resp2_id

Line 302: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE

298: , x_report_url => l_url_tbl(1)
299: , x_return_status => x_return_status
300: );
301: BIS_UTIL.Build_Report_URL
302: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
303: , p_report_name => p_report_name2
304: , p_report_params => p_report_param2
305: , p_report_resp_id => p_report_resp2_id
306: , p_report_app_id => p_report_app2_id

Line 310: BIS_UTIL.Build_Report_URL

306: , p_report_app_id => p_report_app2_id
307: , x_report_url => l_url_tbl(2)
308: , x_return_status => x_return_status
309: );
310: BIS_UTIL.Build_Report_URL
311: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
312: , p_report_name => p_report_name3
313: , p_report_params => p_report_param3
314: , p_report_resp_id => p_report_resp3_id

Line 311: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE

307: , x_report_url => l_url_tbl(2)
308: , x_return_status => x_return_status
309: );
310: BIS_UTIL.Build_Report_URL
311: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
312: , p_report_name => p_report_name3
313: , p_report_params => p_report_param3
314: , p_report_resp_id => p_report_resp3_id
315: , p_report_app_id => p_report_app3_id

Line 319: BIS_UTIL.Build_Report_URL

315: , p_report_app_id => p_report_app3_id
316: , x_report_url => l_url_tbl(3)
317: , x_return_status => x_return_status
318: );
319: BIS_UTIL.Build_Report_URL
320: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
321: , p_report_name => p_report_name4
322: , p_report_params => p_report_param4
323: , p_report_resp_id => p_report_resp4_id

Line 320: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE

316: , x_report_url => l_url_tbl(3)
317: , x_return_status => x_return_status
318: );
319: BIS_UTIL.Build_Report_URL
320: ( p_report_type => BIS_UTIL.G_ORACLE_REPORT_TYPE
321: , p_report_name => p_report_name4
322: , p_report_params => p_report_param4
323: , p_report_resp_id => p_report_resp4_id
324: , p_report_app_id => p_report_app4_id

Line 329: BIS_UTIL.Start_Workflow_Engine

325: , x_report_url => l_url_tbl(4)
326: , x_return_status => x_return_status
327: );
328:
329: BIS_UTIL.Start_Workflow_Engine
330: ( p_exception_message => p_exception_message
331: , p_msg_subject => p_msg_subject
332: , p_exception_date => p_exception_date
333: , p_item_type => p_item_type

Line 417: BIS_UTIL.Get_Time_Level_Value

413: IS
414:
415: BEGIN
416:
417: BIS_UTIL.Get_Time_Level_Value
418: ( p_Date => p_Date
419: , p_Target_Level_ID => p_Target_Level_id
420: , p_Organization_ID => TO_CHAR(p_Organization_ID)
421: , x_Time_Level_Value => x_Time_Level_value

Line 477: IF (BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_time_level)

473: -- then the default calendar is used.
474: --
475:
476: IF l_time_level <> 'TOTAL_TIME' THEN
477: IF (BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_time_level)
478: = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911
479: l_Is_OrgRel := TRUE;
480: l_select_stmt := ' SELECT PERIOD_SET_NAME, PERIOD_NAME, ID '||' '
481: ||'FROM '||l_view_name||' '

Line 478: = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911

474: --
475:
476: IF l_time_level <> 'TOTAL_TIME' THEN
477: IF (BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_time_level)
478: = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN --2684911
479: l_Is_OrgRel := TRUE;
480: l_select_stmt := ' SELECT PERIOD_SET_NAME, PERIOD_NAME, ID '||' '
481: ||'FROM '||l_view_name||' '
482: ||'WHERE ORGANIZATION_ID = :p_Organization_ID '

Line 679: ,p_live_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type

675: ,p_exception_date IN date
676: ,p_item_type IN Varchar2
677: ,p_wf_process IN Varchar2
678: ,p_notify_resp_name IN Varchar2
679: ,p_live_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type
680: Default G_DEF_Report_URL_Tbl
681: ,p_cached_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type
682: Default G_DEF_Report_URL_Tbl
683: ,x_return_status OUT NOCOPY VARCHAR2

Line 681: ,p_cached_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type

677: ,p_wf_process IN Varchar2
678: ,p_notify_resp_name IN Varchar2
679: ,p_live_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type
680: Default G_DEF_Report_URL_Tbl
681: ,p_cached_report_url_tbl IN BIS_UTIL.Report_URL_Tbl_Type
682: Default G_DEF_Report_URL_Tbl
683: ,x_return_status OUT NOCOPY VARCHAR2
684: )
685: IS

Line 815: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_BIS_REPORT_TYPE

811: 'http://ap804sun.us.oracle.com:778/dev115/plsql/bisviewer.ShowReport?pRegionCode=PRODUCT_QUALITYpFunctionName=BIS_PRODUCT_QUALITYpSessionId=134903pUserId=11788pResponsibilityId=21524'
812: */
813:
814: Procedure Build_Report_URL
815: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_BIS_REPORT_TYPE
816: , p_reportFn_name IN Varchar2
817: , p_region_code IN Varchar2
818: , p_report_resp_id IN VARCHAR2
819: , p_report_params IN VARCHAR2

Line 832: IF p_report_type = BIS_UTIL.G_BIS_REPORT_TYPE THEN

828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830: l_report_link := FND_PROFILE.value('ICX_REPORT_LINK');
831:
832: IF p_report_type = BIS_UTIL.G_BIS_REPORT_TYPE THEN
833:
834: IF p_report_params IS NOT NULL OR
835: p_report_params <> FND_API.G_MISS_CHAR THEN
836: l_report_url := l_report_link||

Line 871: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_BIS_CACHE_REPORT_TYPE

867: 'http://ap804sun.us.oracle.com:778/dev115/plsql/BIS_CACHING_PVT.Display_Cache?p_identifier=1234567'
868: */
869:
870: Procedure Build_Report_URL
871: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_BIS_CACHE_REPORT_TYPE
872: , p_report_identifier IN VARCHAR2
873: , x_report_url OUT NOCOPY VARCHAR2
874: , x_return_status OUT NOCOPY VARCHAR2
875: )

Line 882: IF p_report_type = BIS_UTIL.G_BIS_CACHE_REPORT_TYPE THEN

878:
879: BEGIN
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882: IF p_report_type = BIS_UTIL.G_BIS_CACHE_REPORT_TYPE THEN
883:
884: l_report_url := 'BIS_CACHING_PVT.Display_Cache?'||
885: 'p_identifier='||p_report_identifier;
886:

Line 903: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_ORACLE_REPORT_TYPE

899: -- Added new parameter at last to support old code calling this
900: -- API by numbers
901: --
902: Procedure Build_Report_URL
903: ( p_report_type IN VARCHAR2 default BIS_UTIL.G_ORACLE_REPORT_TYPE
904: , p_report_name IN Varchar2
905: , p_report_params IN Varchar2
906: , p_report_resp_id IN NUMBER
907: , x_report_url OUT NOCOPY VARCHAR2

Line 920: IF p_report_type = BIS_UTIL.G_ORACLE_REPORT_TYPE

916:
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: l_report_link := FND_PROFILE.value('ICX_REPORT_LINK');
919:
920: IF p_report_type = BIS_UTIL.G_ORACLE_REPORT_TYPE
921: AND p_report_name IS NOT NULL
922: THEN
923:
924: IF p_report_params IS NOT NULL OR

Line 932: IF (BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null(p_report_app_id) = FND_API.G_TRUE) THEN

928: || 'OracleOASIS.RunReport?report='|| p_report_name
929: || '¶meters=' || p_report_params
930: || '&responsibility_id=' || p_report_resp_id;
931:
932: IF (BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null(p_report_app_id) = FND_API.G_TRUE) THEN
933: l_report_url := l_report_url || '&responsibility_application_id=' || p_report_app_id;
934: END IF;
935:
936: ELSE

Line 942: IF (BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null(p_report_app_id) = FND_API.G_TRUE) THEN

938: l_report_url := l_report_link
939: || 'OracleOASIS.RunReport?report='|| p_report_name
940: || '&responsibility_id=' || p_report_resp_id;
941:
942: IF (BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null(p_report_app_id) = FND_API.G_TRUE) THEN
943: l_report_url := l_report_url || '&responsibility_application_id=' || p_report_app_id;
944: END IF;
945:
946: END IF;

Line 970: IF(p_application_id = 271 OR BIS_UTIL.is_internal_customer OR BIS_UTIL.is_Seeded(p_created_by,'Y','N') = 'N') THEN

966: -- currently we allow external customers to choose ONLY BSC (271) and
967: -- customer created application. If decision is changed later on to use
968: -- BIS, the number 271 should be changed to 191, or whatever application
969: -- id should be.
970: IF(p_application_id = 271 OR BIS_UTIL.is_internal_customer OR BIS_UTIL.is_Seeded(p_created_by,'Y','N') = 'N') THEN
971: RETURN 1;
972: ELSE
973: RETURN 0;
974: END IF;

Line 1010: IF(BIS_UTIL.is_dev_env_set OR BIS_UTIL.is_Seeded(FND_GLOBAL.USER_ID,'Y','N') = 'Y') THEN

1006: FUNCTION is_internal_customer
1007: RETURN BOOLEAN
1008: IS
1009: BEGIN
1010: IF(BIS_UTIL.is_dev_env_set OR BIS_UTIL.is_Seeded(FND_GLOBAL.USER_ID,'Y','N') = 'Y') THEN
1011: RETURN TRUE;
1012: ELSE
1013: RETURN FALSE;
1014: END IF;

Line 1031: IF(BIS_UTIL.is_internal_customer) THEN

1027: ORDER BY creation_date desc;
1028:
1029: l_app_id FND_APPLICATION_VL.application_id%TYPE;
1030: BEGIN
1031: IF(BIS_UTIL.is_internal_customer) THEN
1032: l_app_id := BIS_UTIL.G_BSC_APP_ID;
1033: ELSE
1034: IF(latest_creation_date_cur%ISOPEN) THEN
1035: CLOSE latest_creation_date_cur;

Line 1032: l_app_id := BIS_UTIL.G_BSC_APP_ID;

1028:
1029: l_app_id FND_APPLICATION_VL.application_id%TYPE;
1030: BEGIN
1031: IF(BIS_UTIL.is_internal_customer) THEN
1032: l_app_id := BIS_UTIL.G_BSC_APP_ID;
1033: ELSE
1034: IF(latest_creation_date_cur%ISOPEN) THEN
1035: CLOSE latest_creation_date_cur;
1036: END IF;

Line 1040: l_app_id := BIS_UTIL.G_BSC_APP_ID;

1036: END IF;
1037: OPEN latest_creation_date_cur;
1038: FETCH latest_creation_date_cur INTO l_app_id;
1039: IF(latest_creation_date_cur%NOTFOUND) THEN
1040: l_app_id := BIS_UTIL.G_BSC_APP_ID;
1041: END IF;
1042: CLOSE latest_creation_date_cur;
1043: END IF;
1044:

Line 1051: RETURN BIS_UTIL.G_BSC_APP_ID;

1047: WHEN OTHERS THEN
1048: IF(latest_creation_date_cur%ISOPEN) THEN
1049: CLOSE latest_creation_date_cur;
1050: END IF;
1051: RETURN BIS_UTIL.G_BSC_APP_ID;
1052: END get_default_application_id;
1053:
1054: FUNCTION get_object_type
1055: ( p_function_type IN FND_FORM_FUNCTIONS.type%TYPE

Line 1064: l_object_type := BIS_UTIL.G_FUNC_PARAMETER_PORTLET;

1060: IS
1061: l_object_type VARCHAR2(30);
1062: BEGIN
1063: IF ( (p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=P%') THEN
1064: l_object_type := BIS_UTIL.G_FUNC_PARAMETER_PORTLET;
1065: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=T%') THEN
1066: l_object_type := BIS_UTIL.G_FUNC_TABLE_PORTLET;
1067: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=G%') THEN
1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;

Line 1066: l_object_type := BIS_UTIL.G_FUNC_TABLE_PORTLET;

1062: BEGIN
1063: IF ( (p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=P%') THEN
1064: l_object_type := BIS_UTIL.G_FUNC_PARAMETER_PORTLET;
1065: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=T%') THEN
1066: l_object_type := BIS_UTIL.G_FUNC_TABLE_PORTLET;
1067: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=G%') THEN
1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;
1069: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_RELATED_LINK_LAYOUT%') THEN
1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;

Line 1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;

1064: l_object_type := BIS_UTIL.G_FUNC_PARAMETER_PORTLET;
1065: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=T%') THEN
1066: l_object_type := BIS_UTIL.G_FUNC_TABLE_PORTLET;
1067: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=G%') THEN
1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;
1069: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_RELATED_LINK_LAYOUT%') THEN
1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;
1071: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PMF_PORTLET_TABLE_LAYOUT%') THEN
1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;

Line 1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;

1066: l_object_type := BIS_UTIL.G_FUNC_TABLE_PORTLET;
1067: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_PORTLET_TABLE_LAYOUT%' AND p_parameters like '%pRequestType=G%') THEN
1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;
1069: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_RELATED_LINK_LAYOUT%') THEN
1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;
1071: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PMF_PORTLET_TABLE_LAYOUT%') THEN
1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;
1073: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BSC_PORTLET_CUSTOM_VIEW%' AND p_parameters like '%pRequestType=C%') THEN
1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;

Line 1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;

1068: l_object_type := BIS_UTIL.G_FUNC_GRAPH_PORTLET;
1069: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PM_RELATED_LINK_LAYOUT%') THEN
1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;
1071: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PMF_PORTLET_TABLE_LAYOUT%') THEN
1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;
1073: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BSC_PORTLET_CUSTOM_VIEW%' AND p_parameters like '%pRequestType=C%') THEN
1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;
1075: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_parameters like '%pRequestType=URL%') THEN
1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;

Line 1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;

1070: l_object_type := BIS_UTIL.G_FUNC_RELATED_LINKS_PORTLET;
1071: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_PMF_PORTLET_TABLE_LAYOUT%') THEN
1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;
1073: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BSC_PORTLET_CUSTOM_VIEW%' AND p_parameters like '%pRequestType=C%') THEN
1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;
1075: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_parameters like '%pRequestType=URL%') THEN
1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;
1077: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX')) THEN
1078: l_object_type := BIS_UTIL.G_FUNC_GENERIC_OA_PORTLET;

Line 1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;

1072: l_object_type := BIS_UTIL.G_FUNC_KPI_LIST;
1073: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_web_html_call like 'OA.jsp?akRegionCode=BSC_PORTLET_CUSTOM_VIEW%' AND p_parameters like '%pRequestType=C%') THEN
1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;
1075: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_parameters like '%pRequestType=URL%') THEN
1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;
1077: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX')) THEN
1078: l_object_type := BIS_UTIL.G_FUNC_GENERIC_OA_PORTLET;
1079: ELSIF (p_function_type = 'JSP' AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE%' AND p_parameters IS NOT NULL) THEN
1080: l_object_type := BIS_UTIL.G_FUNC_PAGE;

Line 1078: l_object_type := BIS_UTIL.G_FUNC_GENERIC_OA_PORTLET;

1074: l_object_type := BIS_UTIL.G_FUNC_CUSTOM_VIEW;
1075: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX') AND p_parameters like '%pRequestType=URL%') THEN
1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;
1077: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX')) THEN
1078: l_object_type := BIS_UTIL.G_FUNC_GENERIC_OA_PORTLET;
1079: ELSIF (p_function_type = 'JSP' AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE%' AND p_parameters IS NOT NULL) THEN
1080: l_object_type := BIS_UTIL.G_FUNC_PAGE;
1081: ELSIF (((lower(p_web_html_call) like 'bisviewm.jsp%' OR p_web_html_call like 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%') AND p_function_type = 'JSP')
1082: OR (lower(p_web_html_call) like 'bisviewer.showreport%' AND p_function_type = 'WWW')) THEN

Line 1080: l_object_type := BIS_UTIL.G_FUNC_PAGE;

1076: l_object_type := BIS_UTIL.G_FUNC_URL_PORTLET;
1077: ELSIF ((p_function_type = 'WEBPORTLET' OR p_function_type = 'WEBPORTLETX')) THEN
1078: l_object_type := BIS_UTIL.G_FUNC_GENERIC_OA_PORTLET;
1079: ELSIF (p_function_type = 'JSP' AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE%' AND p_parameters IS NOT NULL) THEN
1080: l_object_type := BIS_UTIL.G_FUNC_PAGE;
1081: ELSIF (((lower(p_web_html_call) like 'bisviewm.jsp%' OR p_web_html_call like 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%') AND p_function_type = 'JSP')
1082: OR (lower(p_web_html_call) like 'bisviewer.showreport%' AND p_function_type = 'WWW')) THEN
1083: l_object_type := BIS_UTIL.G_FUNC_REPORT;
1084: END IF;

Line 1083: l_object_type := BIS_UTIL.G_FUNC_REPORT;

1079: ELSIF (p_function_type = 'JSP' AND p_web_html_call like 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE%' AND p_parameters IS NOT NULL) THEN
1080: l_object_type := BIS_UTIL.G_FUNC_PAGE;
1081: ELSIF (((lower(p_web_html_call) like 'bisviewm.jsp%' OR p_web_html_call like 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%') AND p_function_type = 'JSP')
1082: OR (lower(p_web_html_call) like 'bisviewer.showreport%' AND p_function_type = 'WWW')) THEN
1083: l_object_type := BIS_UTIL.G_FUNC_REPORT;
1084: END IF;
1085:
1086: RETURN l_object_type;
1087: EXCEPTION

Line 1144: x_msg_data := x_msg_data ||' -> BIS_UTIL.Get_Update_Date_For_Owner ';

1140:
1141: WHEN OTHERS THEN
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143: IF (x_msg_data IS NOT NULL) THEN
1144: x_msg_data := x_msg_data ||' -> BIS_UTIL.Get_Update_Date_For_Owner ';
1145: ELSE
1146: x_msg_data := SQLERRM ||' at BIS_UTIL.Get_Update_Date_For_Owner ';
1147: END IF;
1148: RAISE;

Line 1146: x_msg_data := SQLERRM ||' at BIS_UTIL.Get_Update_Date_For_Owner ';

1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143: IF (x_msg_data IS NOT NULL) THEN
1144: x_msg_data := x_msg_data ||' -> BIS_UTIL.Get_Update_Date_For_Owner ';
1145: ELSE
1146: x_msg_data := SQLERRM ||' at BIS_UTIL.Get_Update_Date_For_Owner ';
1147: END IF;
1148: RAISE;
1149:
1150: END Get_Update_Date_For_Owner;

Line 1247: x_msg_data := x_msg_data ||' -> BIS_UTIL.Validate_For_Update ';

1243:
1244: WHEN OTHERS THEN
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: IF (x_msg_data IS NOT NULL) THEN
1247: x_msg_data := x_msg_data ||' -> BIS_UTIL.Validate_For_Update ';
1248: ELSE
1249: x_msg_data := SQLERRM ||' at BIS_UTIL.Validate_For_Update ';
1250: END IF;
1251: RAISE;

Line 1249: x_msg_data := SQLERRM ||' at BIS_UTIL.Validate_For_Update ';

1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: IF (x_msg_data IS NOT NULL) THEN
1247: x_msg_data := x_msg_data ||' -> BIS_UTIL.Validate_For_Update ';
1248: ELSE
1249: x_msg_data := SQLERRM ||' at BIS_UTIL.Validate_For_Update ';
1250: END IF;
1251: RAISE;
1252:
1253: END Validate_For_Update;

Line 1428: x_Msg_Data := x_msg_data||' -> BIS_UTIL.get_Pages_Using_ParamPortlet';

1424: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1425: WHEN OTHERS THEN
1426: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF (x_Msg_Data IS NOT NULL) THEN
1428: x_Msg_Data := x_msg_data||' -> BIS_UTIL.get_Pages_Using_ParamPortlet';
1429: ELSE
1430: x_Msg_Data := SQLERRM||' at BIS_UTIL.get_Pages_Using_ParamPortlet';
1431: END IF;
1432: END get_Pages_Using_ParamPortlet;

Line 1430: x_Msg_Data := SQLERRM||' at BIS_UTIL.get_Pages_Using_ParamPortlet';

1426: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF (x_Msg_Data IS NOT NULL) THEN
1428: x_Msg_Data := x_msg_data||' -> BIS_UTIL.get_Pages_Using_ParamPortlet';
1429: ELSE
1430: x_Msg_Data := SQLERRM||' at BIS_UTIL.get_Pages_Using_ParamPortlet';
1431: END IF;
1432: END get_Pages_Using_ParamPortlet;
1433:
1434: FUNCTION get_value

Line 1565: x_value := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ALL');

1561: OPEN c_all_enabled;
1562: FETCH c_all_enabled INTO l_all_enabled_rec;
1563: IF(c_all_enabled%FOUND AND l_all_enabled_rec.total_flag = -1) THEN
1564: x_id := 'All';
1565: x_value := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ALL');
1566: ELSE
1567: FOR l_view_name_rec IN c_view_name LOOP -- Only 1 record should be returned
1568: l_sql_stmt := ' SELECT id, value FROM ' || l_view_name_rec.level_values_view_name || ' WHERE rownum < 2 ';
1569: EXECUTE IMMEDIATE l_sql_stmt INTO x_id, x_value;

Line 1594: BIS_UTIL.get_parent_objects

1590: , x_msg_data OUT NOCOPY VARCHAR2
1591: ) IS
1592: l_parent_user_objects VARCHAR(15000) := NULL;
1593: BEGIN
1594: BIS_UTIL.get_parent_objects
1595: ( p_dep_object_name
1596: , p_dep_object_type
1597: , p_parent_object_type
1598: , x_parent_objects

Line 1680: x_msg_data := x_msg_data || ' -> BIS_UTIL.get_parent_objects';

1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: WHEN OTHERS THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF (x_msg_data IS NOT NULL) THEN
1680: x_msg_data := x_msg_data || ' -> BIS_UTIL.get_parent_objects';
1681: ELSE
1682: x_msg_data := SQLERRM || ' at BIS_UTIL.get_parent_objects';
1683: END IF;
1684: END get_parent_objects;

Line 1682: x_msg_data := SQLERRM || ' at BIS_UTIL.get_parent_objects';

1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF (x_msg_data IS NOT NULL) THEN
1680: x_msg_data := x_msg_data || ' -> BIS_UTIL.get_parent_objects';
1681: ELSE
1682: x_msg_data := SQLERRM || ' at BIS_UTIL.get_parent_objects';
1683: END IF;
1684: END get_parent_objects;
1685:
1686: /*This function uses PMV Function BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby to retrieve Dimension Short Name

Line 1839: BIS_UTIL.Check_Portlet_Dependency(p_portlet_func_name => l_portlet_func_name,

1835: FOR cd_portlet IN c_portlets LOOP
1836: l_portlet_name := cd_portlet.user_function_name;
1837: l_portlet_func_name := cd_portlet.function_name;
1838:
1839: BIS_UTIL.Check_Portlet_Dependency(p_portlet_func_name => l_portlet_func_name,
1840: p_portlet_type => p_obj_portlet_type,
1841: x_parent_obj_exist => l_exist_dependency,
1842: x_parent_obj_list => l_temp_list,
1843: x_return_status => l_return_status,

Line 2695: AND BIS_UTIL.Is_Simulation_Report(region_code) <> FND_API.G_TRUE

2691: WHERE attribute2 = p_measure_short_name
2692: AND attribute1 IN ('MEASURE_NOTARGET', 'MEASURE')
2693: AND NOT(region_code = p_current_region_code AND region_application_id = p_current_region_appid)
2694: AND NVL(BIS_REPORT_PUB.getRegionDataSourceType(p_current_region_code),' ') <> 'MULTIPLE_DATA_SOURCE'
2695: AND BIS_UTIL.Is_Simulation_Report(region_code) <> FND_API.G_TRUE
2696: AND rownum < 2 ;
2697:
2698: CURSOR c_compare_to_col(p_region_code VARCHAR2, p_region_appid NUMBER, p_measure_attrcode VARCHAR2) IS
2699: SELECT attribute_code, attribute_application_id

Line 2758: AND bis_util.is_seeded(dim_group.created_by,'Y','N') = 'Y';

2754: WHERE
2755: dim_lev.short_name=p_dim_lev_short_name
2756: AND dim_lev_by_group.dim_level_id = dim_lev.dim_level_id
2757: AND dim_lev_by_group.dim_group_id = dim_group.dim_group_id
2758: AND bis_util.is_seeded(dim_group.created_by,'Y','N') = 'Y';
2759:
2760: BEGIN
2761: FOR c_dimensions_rec IN c_dimensions LOOP
2762: IF (l_dim_names IS NULL) THEN

Line 2802: l_posPParamsStart := INSTR(p_parameters,BIS_UTIL.C_FF_PARAM_PARAMETERS);

2798: l_default_value :=NULL;
2799:
2800: IF((p_parameters IS NOT NULL) AND (p_attribute2 IS NOT NULL)) THEN
2801:
2802: l_posPParamsStart := INSTR(p_parameters,BIS_UTIL.C_FF_PARAM_PARAMETERS);
2803: IF(l_posPParamsStart >=0) THEN
2804: l_posAttr2 := INSTR(p_parameters,REPLACE(p_attribute2,BIS_UTIL.C_CHAR_PLUS,BIS_UTIL.C_CHAR_CARROT) || BIS_UTIL.C_CHAR_AT_THE_RATE,l_posPParamsStart);
2805: l_posPParamsEnd := INSTR(p_parameters,BIS_UTIL.C_PARAM_SEP,l_posAttr2);
2806:

Line 2804: l_posAttr2 := INSTR(p_parameters,REPLACE(p_attribute2,BIS_UTIL.C_CHAR_PLUS,BIS_UTIL.C_CHAR_CARROT) || BIS_UTIL.C_CHAR_AT_THE_RATE,l_posPParamsStart);

2800: IF((p_parameters IS NOT NULL) AND (p_attribute2 IS NOT NULL)) THEN
2801:
2802: l_posPParamsStart := INSTR(p_parameters,BIS_UTIL.C_FF_PARAM_PARAMETERS);
2803: IF(l_posPParamsStart >=0) THEN
2804: l_posAttr2 := INSTR(p_parameters,REPLACE(p_attribute2,BIS_UTIL.C_CHAR_PLUS,BIS_UTIL.C_CHAR_CARROT) || BIS_UTIL.C_CHAR_AT_THE_RATE,l_posPParamsStart);
2805: l_posPParamsEnd := INSTR(p_parameters,BIS_UTIL.C_PARAM_SEP,l_posAttr2);
2806:
2807: IF(l_posPParamsEnd=0)THEN
2808: l_posPParamsEnd := LENGTH(p_parameters);

Line 2805: l_posPParamsEnd := INSTR(p_parameters,BIS_UTIL.C_PARAM_SEP,l_posAttr2);

2801:
2802: l_posPParamsStart := INSTR(p_parameters,BIS_UTIL.C_FF_PARAM_PARAMETERS);
2803: IF(l_posPParamsStart >=0) THEN
2804: l_posAttr2 := INSTR(p_parameters,REPLACE(p_attribute2,BIS_UTIL.C_CHAR_PLUS,BIS_UTIL.C_CHAR_CARROT) || BIS_UTIL.C_CHAR_AT_THE_RATE,l_posPParamsStart);
2805: l_posPParamsEnd := INSTR(p_parameters,BIS_UTIL.C_PARAM_SEP,l_posAttr2);
2806:
2807: IF(l_posPParamsEnd=0)THEN
2808: l_posPParamsEnd := LENGTH(p_parameters);
2809: END IF;

Line 2813: l_start := INSTR(p_parameters,BIS_UTIL.C_CHAR_AT_THE_RATE,l_posAttr2) +1;

2809: END IF;
2810:
2811: IF(l_posAttr2 >0 AND l_posAttr2 < l_posPParamsEnd) THEN
2812:
2813: l_start := INSTR(p_parameters,BIS_UTIL.C_CHAR_AT_THE_RATE,l_posAttr2) +1;
2814: l_end := INSTR(p_parameters,BIS_UTIL.C_CHAR_TILDE,l_posAttr2);
2815: IF(l_end =0)THEN
2816: l_end :=l_posPParamsEnd;
2817: END IF;

Line 2814: l_end := INSTR(p_parameters,BIS_UTIL.C_CHAR_TILDE,l_posAttr2);

2810:
2811: IF(l_posAttr2 >0 AND l_posAttr2 < l_posPParamsEnd) THEN
2812:
2813: l_start := INSTR(p_parameters,BIS_UTIL.C_CHAR_AT_THE_RATE,l_posAttr2) +1;
2814: l_end := INSTR(p_parameters,BIS_UTIL.C_CHAR_TILDE,l_posAttr2);
2815: IF(l_end =0)THEN
2816: l_end :=l_posPParamsEnd;
2817: END IF;
2818:

Line 2835: END BIS_UTIL;

2831: WHEN OTHERS THEN
2832: RETURN NULL;
2833: END Get_Default_Value_From_Params;
2834:
2835: END BIS_UTIL;