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_FORM_FUNCTIONS_PUB dependencies on BIS_COMMON_UTILS

Line 105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

101: ,x_FUNCTION_ID OUT NOCOPY NUMBER
102: ,x_return_status OUT NOCOPY VARCHAR2
103: ,x_msg_count OUT NOCOPY NUMBER
104: ,x_msg_data OUT NOCOPY VARCHAR2
105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

Line 106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

102: ,x_return_status OUT NOCOPY VARCHAR2
103: ,x_msg_count OUT NOCOPY NUMBER
104: ,x_msg_data OUT NOCOPY VARCHAR2
105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
110: ) is

Line 107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

103: ,x_msg_count OUT NOCOPY NUMBER
104: ,x_msg_data OUT NOCOPY VARCHAR2
105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
110: ) is
111:

Line 108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

104: ,x_msg_data OUT NOCOPY VARCHAR2
105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
110: ) is
111:
112: l_rowid VARCHAR2(30);

Line 109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

105: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
106: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
107: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
108: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
109: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
110: ) is
111:
112: l_rowid VARCHAR2(30);
113: l_new_function_id NUMBER;

Line 123: if p_region_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then

119:
120: begin
121: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
122:
123: if p_region_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
124: l_region_application_id := p_region_application_id;
125: end if;
126:
127: if p_region_code <> BIS_COMMON_UTILS.G_DEF_CHAR then

Line 127: if p_region_code <> BIS_COMMON_UTILS.G_DEF_CHAR then

123: if p_region_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
124: l_region_application_id := p_region_application_id;
125: end if;
126:
127: if p_region_code <> BIS_COMMON_UTILS.G_DEF_CHAR then
128: l_region_code := p_region_code;
129: end if;
130:
131: if p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then

Line 131: if p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then

127: if p_region_code <> BIS_COMMON_UTILS.G_DEF_CHAR then
128: l_region_code := p_region_code;
129: end if;
130:
131: if p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
132: l_application_id := p_application_id;
133: end if;
134:
135:

Line 168: if p_functional_area_id <> BIS_COMMON_UTILS.G_DEF_NUM and p_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR and p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then

164: x_FUNCTION_ID := l_new_function_id;
165: end if;
166:
167: -- mdamle 01/03/2005 - Integrate with extension table
168: if p_functional_area_id <> BIS_COMMON_UTILS.G_DEF_NUM and p_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR and p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
169: l_Form_Func_Extn_Rec.object_type := p_object_type;
170: l_Form_Func_Extn_Rec.object_name := upper(p_FUNCTION_NAME);
171: l_Form_Func_Extn_Rec.application_id := l_application_id;
172: l_Form_Func_Extn_Rec.func_area_id := p_functional_area_id;

Line 280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

276:
277: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
278: PROCEDURE UPDATE_ROW (
279: p_FUNCTION_ID IN NUMBER
280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

Line 281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

277: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
278: PROCEDURE UPDATE_ROW (
279: p_FUNCTION_ID IN NUMBER
280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

Line 282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

278: PROCEDURE UPDATE_ROW (
279: p_FUNCTION_ID IN NUMBER
280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

Line 283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

279: p_FUNCTION_ID IN NUMBER
280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2

Line 284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

280: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2
288: ,x_msg_count OUT NOCOPY NUMBER

Line 285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR

281: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2
288: ,x_msg_count OUT NOCOPY NUMBER
289: ,x_msg_data OUT NOCOPY VARCHAR2

Line 286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM

282: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
283: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
284: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
285: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
286: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
287: ,x_return_status OUT NOCOPY VARCHAR2
288: ,x_msg_count OUT NOCOPY NUMBER
289: ,x_msg_data OUT NOCOPY VARCHAR2
290: ,p_REGION_CODE IN VARCHAR2 := NULL

Line 350: if (p_user_function_name <> BIS_COMMON_UTILS.G_DEF_CHAR) then

346: l_formFunction_rec.description,
347: l_formFunction_rec.parameters;
348: CLOSE cFormFunction;
349:
350: if (p_user_function_name <> BIS_COMMON_UTILS.G_DEF_CHAR) then
351: l_formFunction_rec.user_function_name := p_user_function_name;
352: end if;
353: if (p_description IS NULL ) THEN
354: l_formFunction_rec.description := NULL;

Line 355: elsif (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then

351: l_formFunction_rec.user_function_name := p_user_function_name;
352: end if;
353: if (p_description IS NULL ) THEN
354: l_formFunction_rec.description := NULL;
355: elsif (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
356: l_formFunction_rec.description := p_description;
357: end if;
358: if (p_parameters <> BIS_COMMON_UTILS.G_DEF_CHAR) then
359: l_formFunction_rec.parameters := p_parameters;

Line 358: if (p_parameters <> BIS_COMMON_UTILS.G_DEF_CHAR) then

354: l_formFunction_rec.description := NULL;
355: elsif (p_description <> BIS_COMMON_UTILS.G_DEF_CHAR) then
356: l_formFunction_rec.description := p_description;
357: end if;
358: if (p_parameters <> BIS_COMMON_UTILS.G_DEF_CHAR) then
359: l_formFunction_rec.parameters := p_parameters;
360: end if;
361: if (p_web_html_call <> BIS_COMMON_UTILS.G_DEF_CHAR) then
362: l_formFunction_rec.web_html_call := p_web_html_call;

Line 361: if (p_web_html_call <> BIS_COMMON_UTILS.G_DEF_CHAR) then

357: end if;
358: if (p_parameters <> BIS_COMMON_UTILS.G_DEF_CHAR) then
359: l_formFunction_rec.parameters := p_parameters;
360: end if;
361: if (p_web_html_call <> BIS_COMMON_UTILS.G_DEF_CHAR) then
362: l_formFunction_rec.web_html_call := p_web_html_call;
363: end if;
364:
365: l_formFunction_rec.region_code := p_REGION_CODE; --We need to update with null even in update case

Line 391: if p_functional_area_id <> BIS_COMMON_UTILS.G_DEF_NUM and p_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR and p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then

387: X_LAST_UPDATED_BY => fnd_global.user_id,
388: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
389: X_MAINTENANCE_MODE_SUPPORT => l_formFunction_rec.maintenance_mode_support,
390: X_CONTEXT_DEPENDENCE => l_formFunction_rec.context_dependence);
391: if p_functional_area_id <> BIS_COMMON_UTILS.G_DEF_NUM and p_object_type <> BIS_COMMON_UTILS.G_DEF_CHAR and p_application_id <> BIS_COMMON_UTILS.G_DEF_NUM then
392: select function_name into l_function_name
393: from fnd_form_functions_vl
394: where function_id = p_FUNCTION_ID;
395: select count(1) into l_count from bis_form_function_extension where upper(object_name) = upper(l_function_name);