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 FND_FORM_FUNCTIONS

Line 58: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;

54:
55: l_new_function_id NUMBER;
56:
57: begin
58: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
59:
60: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
61: X_ROWID => X_ROWID,
62: X_FUNCTION_ID => l_new_function_id,

Line 60: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(

56:
57: begin
58: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
59:
60: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
61: X_ROWID => X_ROWID,
62: X_FUNCTION_ID => l_new_function_id,
63: X_WEB_HOST_NAME => null,
64: X_WEB_AGENT_NAME => null,

Line 121: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;

117: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
118: l_custom_functional_area_id number;
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;

Line 136: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(

132: l_application_id := p_application_id;
133: end if;
134:
135:
136: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
137: X_ROWID => l_ROWID,
138: X_FUNCTION_ID => l_new_function_id,
139: X_WEB_HOST_NAME => null,
140: X_WEB_AGENT_NAME => null,

Line 222: from fnd_form_functions_vl

218: application_id,
219: form_id,
220: maintenance_mode_support,
221: context_dependence
222: from fnd_form_functions_vl
223: where function_id = X_FUNCTION_ID;
224:
225: begin
226:

Line 251: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW(

247: l_formFunction_rec.maintenance_mode_support,
248: l_formFunction_rec.context_dependence;
249: CLOSE cFormFunction;
250:
251: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW(
252: X_FUNCTION_ID => X_FUNCTION_ID,
253: X_WEB_HOST_NAME => l_formFunction_rec.web_host_name,
254: X_WEB_AGENT_NAME => l_formFunction_rec.web_agent_name,
255: X_WEB_HTML_CALL => l_formFunction_rec.web_html_call,

Line 297: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

293:
294: l_formFunction_rec FormFunction_Rec_Type;
295: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
296: l_custom_functional_area_id number;
297: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
298: l_count number;
299:
300: cursor cFormFunction is
301: select function_name,

Line 319: from fnd_form_functions_vl

315: context_dependence,
316: user_function_name,
317: description,
318: parameters
319: from fnd_form_functions_vl
320: where function_id = p_FUNCTION_ID;
321:
322: begin
323:

Line 368: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW(

364:
365: l_formFunction_rec.region_code := p_REGION_CODE; --We need to update with null even in update case
366: l_formFunction_rec.region_application_id := p_REGION_APPLICATION_ID;
367:
368: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW(
369: X_FUNCTION_ID => p_FUNCTION_ID,
370: X_WEB_HOST_NAME => l_formFunction_rec.web_host_name,
371: X_WEB_AGENT_NAME => l_formFunction_rec.web_agent_name,
372: X_WEB_HTML_CALL => l_formFunction_rec.web_html_call,

Line 393: from fnd_form_functions_vl

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);
396: l_Form_Func_Extn_Rec.object_type := p_object_type;
397: l_Form_Func_Extn_Rec.object_name := upper(l_function_name);

Line 442: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

438: ,x_return_status OUT NOCOPY VARCHAR2
439: ,x_msg_count OUT NOCOPY NUMBER
440: ,x_msg_data OUT NOCOPY VARCHAR2
441: ) IS
442: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
443: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
444: l_count number;
445:
446: BEGIN

Line 449: from fnd_form_functions

445:
446: BEGIN
447:
448: select function_name into l_function_name
449: from fnd_form_functions
450: where function_id = p_function_id;
451:
452: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
453: X_FUNCTION_ID => p_FUNCTION_ID

Line 452: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(

448: select function_name into l_function_name
449: from fnd_form_functions
450: where function_id = p_function_id;
451:
452: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
453: X_FUNCTION_ID => p_FUNCTION_ID
454: );
455:
456: -- mdamle 01/03/2005 - Integrate with extension table

Line 493: l_function_id fnd_form_functions.function_id%TYPE;

489: ,x_msg_count OUT NOCOPY NUMBER
490: ,x_msg_data OUT NOCOPY VARCHAR2
491: )
492: IS
493: l_function_id fnd_form_functions.function_id%TYPE;
494:
495: CURSOR function_id_crsr IS
496: SELECT function_id
497: FROM fnd_form_functions

Line 497: FROM fnd_form_functions

493: l_function_id fnd_form_functions.function_id%TYPE;
494:
495: CURSOR function_id_crsr IS
496: SELECT function_id
497: FROM fnd_form_functions
498: WHERE function_name = p_function_name;
499:
500: CURSOR c_menu_entries (p_function_id fnd_menu_entries.function_id%TYPE) IS
501: SELECT menu_id, entry_sequence

Line 583: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(

579: x_msg_data => l_msg_data);
580:
581: end loop;
582:
583: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
584: X_FUNCTION_ID => p_FUNCTION_ID
585: );
586:
587: EXCEPTION

Line 612: from fnd_form_functions

608:
609: l_last_update_date date;
610:
611: cursor cFunction is select last_update_date
612: from fnd_form_functions
613: where function_id = p_function_id
614: for update of function_id nowait;
615:
616: BEGIN

Line 699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;

695: x_return_status OUT nocopy VARCHAR2,
696: x_Msg_Count OUT NOCOPY NUMBER,
697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN

Line 700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;

696: x_Msg_Count OUT NOCOPY NUMBER,
697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN
704: SAVEPOINT FormFunctionObsoleteUpdate;

Line 701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;

697: x_msg_data OUT nocopy VARCHAR2
698: ) IS
699: l_form_func_parameters FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
700: l_form_function_id FND_FORM_FUNCTIONS_VL.FUNCTION_ID%TYPE;
701: l_form_func_description FND_FORM_FUNCTIONS_VL.DESCRIPTION%TYPE;
702:
703: BEGIN
704: SAVEPOINT FormFunctionObsoleteUpdate;
705: IF (p_func_name IS NULL OR p_func_name = '') THEN

Line 719: FROM fnd_form_functions_vl

715: END IF;
716:
717: SELECT function_id,parameters,description
718: INTO l_form_function_id,l_form_func_parameters,l_form_func_description
719: FROM fnd_form_functions_vl
720: WHERE function_name = p_func_name;
721:
722: IF (p_obsolete = 'Y') THEN
723: l_form_func_parameters := l_form_func_parameters || '&pObsoleteFlag=Y';