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_PMV_UTIL dependencies on BISVIEWER

Line 97: (p_attributeCode_tbl in OUT NOCOPY BISVIEWER.t_char

93:
94: END;
95: --
96: procedure sortAttributeCode
97: (p_attributeCode_tbl in OUT NOCOPY BISVIEWER.t_char
98: ,p_attributeValue_tbl in OUT NOCOPY BISVIEWER.t_char
99: ,x_return_status OUT NOCOPY VARCHAR2
100: ,x_msg_count OUT NOCOPY NUMBER
101: ,x_msg_data OUT NOCOPY VARCHAR2

Line 98: ,p_attributeValue_tbl in OUT NOCOPY BISVIEWER.t_char

94: END;
95: --
96: procedure sortAttributeCode
97: (p_attributeCode_tbl in OUT NOCOPY BISVIEWER.t_char
98: ,p_attributeValue_tbl in OUT NOCOPY BISVIEWER.t_char
99: ,x_return_status OUT NOCOPY VARCHAR2
100: ,x_msg_count OUT NOCOPY NUMBER
101: ,x_msg_data OUT NOCOPY VARCHAR2
102: )

Line 105: l_length_tbl BISVIEWER.t_num;

101: ,x_msg_data OUT NOCOPY VARCHAR2
102: )
103: IS
104: l_count NUMBER;
105: l_length_tbl BISVIEWER.t_num;
106: l_temp_attr VARCHAR2(32000);
107: l_temp_value VARCHAR2(32000);
108: l_temp_length NUMBER;
109:

Line 256: --bisviewer.displayError(235,SQLCODE,SQLERRM);

252: RETURN vElementId;
253: EXCEPTION
254: WHEN OTHERS THEN
255: --Supress the display of the error message if there is no hierarchy
256: --bisviewer.displayError(235,SQLCODE,SQLERRM);
257: return 0;
258: END getHierarchyElementId;
259:
260: FUNCTION getDimensionForAttribute(pAttributecode in varchar2,

Line 280: bisviewer.displayError(235,SQLCODE,SQLERRM);

276: CLOSE cAttr2;
277: RETURN l_attribute2;
278: EXCEPTION
279: WHEN OTHERS THEN
280: bisviewer.displayError(235,SQLCODE,SQLERRM);
281: return null;
282: END getDimensionForAttribute;
283:
284: FUNCTION getAttributeForDimension(pDimension in varchar2,

Line 303: bisviewer.displayError(235,SQLCODE,SQLERRM);

299: CLOSE cAttr2;
300: RETURN l_attribute_code;
301: EXCEPTION
302: WHEN OTHERS THEN
303: bisviewer.displayError(235,SQLCODE,SQLERRM);
304: return null;
305: END getAttributeForDimension;
306:
307: function encode (p_url in varchar2,

Line 846: x_bind_var_tbl out NOCOPY BISVIEWER.t_char)

842:
843:
844: PROCEDURE SETUP_BIND_VARIABLES
845: (p_bind_variables in varchar2,
846: x_bind_var_tbl out NOCOPY BISVIEWER.t_char)
847: is
848: l_startIndex NUMBER;
849: l_endIndex NUMBER;
850: l_bind_var VARCHAR2(32000);

Line 1091: FUNCTION getRoleIds(pPrivileges IN VARCHAR2) RETURN BISVIEWER.t_char IS

1087: return -1;
1088: END;
1089:
1090: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1091: FUNCTION getRoleIds(pPrivileges IN VARCHAR2) RETURN BISVIEWER.t_char IS
1092: l_sql VARCHAR2(3000);
1093: l_privileges VARCHAR2(2000);
1094: l_bind_values BISVIEWER.t_char;
1095: l_roleIds VARCHAR2(2000);

Line 1094: l_bind_values BISVIEWER.t_char;

1090: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1091: FUNCTION getRoleIds(pPrivileges IN VARCHAR2) RETURN BISVIEWER.t_char IS
1092: l_sql VARCHAR2(3000);
1093: l_privileges VARCHAR2(2000);
1094: l_bind_values BISVIEWER.t_char;
1095: l_roleIds VARCHAR2(2000);
1096: l_cursor INTEGER;
1097: ignore INTEGER;
1098: l_bind_col varchar2(200);

Line 1100: l_menu_id_tbl BISVIEWER.t_char;

1096: l_cursor INTEGER;
1097: ignore INTEGER;
1098: l_bind_col varchar2(200);
1099: l_menu_id NUMBER;
1100: l_menu_id_tbl BISVIEWER.t_char;
1101: l_count NUMBER := 1;
1102: BEGIN
1103: l_sql := 'SELECT DISTINCT menu_id FROM fnd_menu_entries where function_id in (';
1104: l_privileges := replace(pPrivileges, ',', '~');

Line 1150: pRoleIdsTbl IN BISVIEWER.t_char

1146: END getRoleIds;
1147:
1148: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1149: PROCEDURE getDelegations(
1150: pRoleIdsTbl IN BISVIEWER.t_char
1151: , pParamName IN VARCHAR2
1152: , pParameterView IN VARCHAR2
1153: , pAsOfDate IN DATE
1154: , xDelegatorIdTbl OUT NOCOPY BISVIEWER.t_char

Line 1154: , xDelegatorIdTbl OUT NOCOPY BISVIEWER.t_char

1150: pRoleIdsTbl IN BISVIEWER.t_char
1151: , pParamName IN VARCHAR2
1152: , pParameterView IN VARCHAR2
1153: , pAsOfDate IN DATE
1154: , xDelegatorIdTbl OUT NOCOPY BISVIEWER.t_char
1155: , xDelegatorValueTbl OUT NOCOPY BISVIEWER.t_char
1156: ) IS
1157: l_sql VARCHAR2(5000);
1158: l_cursor INTEGER;

Line 1155: , xDelegatorValueTbl OUT NOCOPY BISVIEWER.t_char

1151: , pParamName IN VARCHAR2
1152: , pParameterView IN VARCHAR2
1153: , pAsOfDate IN DATE
1154: , xDelegatorIdTbl OUT NOCOPY BISVIEWER.t_char
1155: , xDelegatorValueTbl OUT NOCOPY BISVIEWER.t_char
1156: ) IS
1157: l_sql VARCHAR2(5000);
1158: l_cursor INTEGER;
1159: ignore INTEGER;