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_PAGE_PUB dependencies on FND_FORM_FUNCTIONS

Line 40: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

36: ,x_msg_data OUT NOCOPY VARCHAR2
37: ) is
38:
39: l_count NUMBER;
40: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
41: l_app_short_name VARCHAR2(30);
42: l_type VARCHAR2(30);
43: begin
44:

Line 49: from fnd_form_functions

45: fnd_msg_pub.initialize;
46:
47: begin
48: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE) into l_type
49: from fnd_form_functions
50: where function_name = p_page_function_name;
51: exception
52: when no_data_found then l_type := null;
53: end;

Line 69: from fnd_form_functions

65: else
66: -- Check if either Form Function or Region code exists.
67:
68: select count(1) into l_count
69: from fnd_form_functions
70: where function_name = p_internal_name;
71:
72: if (l_count = 0) then
73: select count(1) into l_count

Line 155: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

151: ,x_msg_data OUT NOCOPY VARCHAR2
152: ) is
153:
154: l_count NUMBER;
155: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
156: l_app_short_name VARCHAR2(30);
157: l_new_internal_name VARCHAR2 (30);
158: l_new_application_id NUMBER;
159:

Line 202: from fnd_form_functions

198:
199: -- Check if form function/region exists
200:
201: select count(1) into l_count
202: from fnd_form_functions
203: where function_name = l_new_internal_name;
204:
205: if (l_count = 0) then
206: select count(1) into l_count

Line 244: select parameters into l_parameters from fnd_form_functions

240: select lower(application_short_name) into l_app_short_name
241: from fnd_application
242: where application_id = l_new_application_id;
243:
244: select parameters into l_parameters from fnd_form_functions
245: where function_id = p_page_id;
246:
247: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || l_new_internal_name);
248:

Line 250: UPDATE fnd_form_functions

246:
247: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || l_new_internal_name);
248:
249: if l_new_internal_name <> p_internal_name then
250: UPDATE fnd_form_functions
251: SET function_name = l_new_internal_name
252: WHERE function_id = p_page_id;
253: end if;
254:

Line 850: l_parameters FND_FORM_FUNCTIONS.Parameters%Type := null;

846: ,x_msg_data OUT NOCOPY VARCHAR2
847: ) is
848:
849: l_count NUMBER := 0;
850: l_parameters FND_FORM_FUNCTIONS.Parameters%Type := null;
851: l_function_id NUMBER := NULL;
852: l_menu_name FND_MENUS.Menu_Name%Type := NULL;
853: l_menu_id NUMBER := NULL;
854: l_attr_category VARCHAR2(30) := NULL;

Line 906: from fnd_form_functions

902: x_msg_data =>x_msg_data);
903:
904:
905: select parameters, function_id into l_parameters, l_function_id
906: from fnd_form_functions
907: where function_name = p_page_function_name;
908:
909: select lower(application_short_name) into l_app_short_name
910: from fnd_application

Line 931: UPDATE fnd_form_functions

927: x_msg_data =>x_msg_data);
928:
929: -- mdamle 02/03/2004 - Update function name
930: if p_page_function_name <> p_internal_name then
931: UPDATE fnd_form_functions
932: SET function_name = p_internal_name
933: WHERE function_id = l_function_id;
934: end if;
935:

Line 975: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

971: ,x_msg_data OUT NOCOPY VARCHAR2
972: ) is
973:
974: l_count NUMBER;
975: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
976: l_app_short_name VARCHAR2(30);
977: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
978: begin
979: fnd_msg_pub.initialize;

Line 977: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

973:
974: l_count NUMBER;
975: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
976: l_app_short_name VARCHAR2(30);
977: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
978: begin
979: fnd_msg_pub.initialize;
980:
981: select count(1) into l_count

Line 982: from fnd_form_functions

978: begin
979: fnd_msg_pub.initialize;
980:
981: select count(1) into l_count
982: from fnd_form_functions
983: where function_name = p_page_function_name;
984:
985: if (l_count > 0) then
986: -- Trying to update a non-page function.

Line 1061: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

1057: ) is
1058:
1059: l_count NUMBER;
1060: l_function_id NUMBER := 0;
1061: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
1062: l_app_short_name VARCHAR2(30);
1063: l_type VARCHAR2(30);
1064: l_page_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1065: l_application_id NUMBER;

Line 1064: l_page_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

1060: l_function_id NUMBER := 0;
1061: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
1062: l_app_short_name VARCHAR2(30);
1063: l_type VARCHAR2(30);
1064: l_page_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1065: l_application_id NUMBER;
1066: l_menu_name FND_MENUS.Menu_Name%Type := NULL;
1067: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1068: begin

Line 1067: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

1063: l_type VARCHAR2(30);
1064: l_page_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1065: l_application_id NUMBER;
1066: l_menu_name FND_MENUS.Menu_Name%Type := NULL;
1067: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1068: begin
1069: fnd_msg_pub.initialize;
1070:
1071: begin

Line 1076: from fnd_form_functions

1072: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE),
1073: function_id,
1074: parameters
1075: into l_type, l_function_id, l_parameters
1076: from fnd_form_functions
1077: where function_name = p_page_function_name;
1078: exception
1079: when no_data_found then l_type := null;
1080: end;

Line 1118: from fnd_form_functions

1114: -- Update form function
1115: if l_page_function_name <> p_page_function_name then
1116: -- Check if new function already exists.
1117: select count(1) into l_count
1118: from fnd_form_functions
1119: where function_name = l_page_function_name;
1120:
1121: if (l_count > 0) then
1122: -- Duplicate function name

Line 1128: UPDATE fnd_form_functions

1124: FND_MSG_PUB.ADD;
1125: RAISE FND_API.G_EXC_ERROR;
1126: end if;
1127:
1128: UPDATE fnd_form_functions
1129: SET function_name = l_page_function_name
1130: WHERE function_id = l_function_id;
1131: end if;
1132:

Line 1167: p_Function_Id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE

1163: end Update_Page_Function;
1164:
1165: FUNCTION Get_Custom_View_Name
1166: (
1167: p_Function_Id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE
1168: )RETURN VARCHAR2
1169: IS
1170: l_custom_view_name VARCHAR2(200); -- Should be greater than custom view name and tab name
1171: l_tab_id VARCHAR(10);

Line 1172: l_parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE; -- Parameters

1168: )RETURN VARCHAR2
1169: IS
1170: l_custom_view_name VARCHAR2(200); -- Should be greater than custom view name and tab name
1171: l_tab_id VARCHAR(10);
1172: l_parameters FND_FORM_FUNCTIONS.PARAMETERS%TYPE; -- Parameters
1173: l_start_pos NUMBER;
1174: l_end_pos NUMBER;
1175: l_tab_name BSC_TABS_VL.NAME%TYPE;
1176: BEGIN

Line 1179: FROM fnd_form_functions_vl

1175: l_tab_name BSC_TABS_VL.NAME%TYPE;
1176: BEGIN
1177: SELECT user_function_name,parameters
1178: INTO l_custom_view_name,l_parameters
1179: FROM fnd_form_functions_vl
1180: WHERE function_id = p_Function_Id;
1181:
1182: l_tab_id := BIS_COMMON_UTILS.getParameterValue(l_parameters,'pTabId');
1183: IF(l_tab_id IS NOT NULL) THEN

Line 1211: p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE

1207: /*******************************************************/
1208:
1209: FUNCTION Is_Simulatable_Cust_View
1210: (
1211: p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE
1212: ) RETURN NUMBER
1213: IS
1214: l_region_Code VARCHAR(100);
1215: l_return_value VARCHAR(3);