DBA Data[Home] [Help]

APPS.BIS_REPORT_PUB dependencies on BIS_COMMON_UTILS

Line 45: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');

41: if l_type = 'WWW' then
42: l_region := substr( substr( l_web_html_call, instr(l_web_html_call, '''')+1 ), 1, instr(substr( l_web_html_call, instr(l_web_html_call, '''')+1 ),'''')-1 );
43: if l_region is null then
44: -- Try parameters
45: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
46: end if;
47: elsif l_type = 'WEBPORTLET' then
48: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
49: else

Line 48: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');

44: -- Try parameters
45: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
46: end if;
47: elsif l_type = 'WEBPORTLET' then
48: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
49: else
50: -- Type = DBPORTLET
51: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
52:

Line 51: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');

47: elsif l_type = 'WEBPORTLET' then
48: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
49: else
50: -- Type = DBPORTLET
51: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
52:
53: -- Check if portlet is pointing to another function
54: -- Get region code from that function
55: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pFunctionName');

Line 55: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pFunctionName');

51: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
52:
53: -- Check if portlet is pointing to another function
54: -- Get region code from that function
55: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pFunctionName');
56: if l_ref_function_name is null then
57: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'FUNCTION_NAME');
58: end if;
59:

Line 57: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'FUNCTION_NAME');

53: -- Check if portlet is pointing to another function
54: -- Get region code from that function
55: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pFunctionName');
56: if l_ref_function_name is null then
57: l_ref_function_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'FUNCTION_NAME');
58: end if;
59:
60: if l_ref_function_name is not null and l_ref_function_name <> '' then
61: if c_form_func%ISOPEN then

Line 72: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');

68: if l_type = 'WWW' then
69: l_region := substr( substr( l_web_html_call, instr(l_web_html_call, '''')+1 ), 1, instr(substr( l_web_html_call, instr(l_web_html_call, '''')+1 ),'''')-1 );
70: if l_region is null then
71: -- Try parameters
72: l_region := BIS_COMMON_UTILS.getParameterValue(l_parameters, 'pRegionCode');
73: end if;
74: end if;
75: end if; -- l_ref_function_name is not null
76: end if;

Line 119: l_request_type := BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRequestType');

115: IF (upper(pType) = 'JSP' OR upper(pType) = 'WWW') THEN
116: RETURN fnd_message.get_string('BIS', 'BIS_REPORT_TITLE');
117: ELSE
118: IF (upper(pType) = 'WEBPORTLET') THEN
119: l_request_type := BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRequestType');
120: IF (l_request_type = 'T') THEN
121: RETURN fnd_message.get_string('BIS', 'BIS_TREND_TABLE');
122: ELSIF (l_request_type = 'G') THEN
123: RETURN fnd_message.get_string('BIS', 'BIS_TREND_GRAPH');

Line 141: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRequestType');

137: IF (upper(pType) = 'JSP' OR upper(pType) = 'WWW') THEN
138: RETURN 'R';
139: ELSE
140: IF (upper(pType) = 'WEBPORTLET') THEN
141: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRequestType');
142: ELSE
143: RETURN NULL;
144: END IF;
145: END IF;

Line 156: RETURN nvl(BIS_COMMON_UTILS.getParameterValue(webHtmlCall, 'regionCode'), BIS_COMMON_UTILS.getparametervalue(pParameters,'pRegionCode'));

152: FUNCTION getRegionCode(pType IN VARCHAR2, pParameters IN VARCHAR2, webHtmlCall IN VARCHAR2, functionName IN VARCHAR2) RETURN CHAR IS
153: l_request_type CHAR;
154: BEGIN
155: IF (pType = 'JSP') THEN
156: RETURN nvl(BIS_COMMON_UTILS.getParameterValue(webHtmlCall, 'regionCode'), BIS_COMMON_UTILS.getparametervalue(pParameters,'pRegionCode'));
157: ELSIF (pType = 'WWW') THEN
158: RETURN nvl(trim(BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode')), getRegionCode(functionName));
159: ELSIF (pType = 'WEBPORTLET') THEN
160: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode');

Line 158: RETURN nvl(trim(BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode')), getRegionCode(functionName));

154: BEGIN
155: IF (pType = 'JSP') THEN
156: RETURN nvl(BIS_COMMON_UTILS.getParameterValue(webHtmlCall, 'regionCode'), BIS_COMMON_UTILS.getparametervalue(pParameters,'pRegionCode'));
157: ELSIF (pType = 'WWW') THEN
158: RETURN nvl(trim(BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode')), getRegionCode(functionName));
159: ELSIF (pType = 'WEBPORTLET') THEN
160: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode');
161: END IF;
162:

Line 160: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode');

156: RETURN nvl(BIS_COMMON_UTILS.getParameterValue(webHtmlCall, 'regionCode'), BIS_COMMON_UTILS.getparametervalue(pParameters,'pRegionCode'));
157: ELSIF (pType = 'WWW') THEN
158: RETURN nvl(trim(BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode')), getRegionCode(functionName));
159: ELSIF (pType = 'WEBPORTLET') THEN
160: RETURN BIS_COMMON_UTILS.getParameterValue(pParameters, 'pRegionCode');
161: END IF;
162:
163: RETURN NULL;
164: