APPS.BIS_REPORT_XML_PUB dependencies on FND_FORM_FUNCTIONS

Line 33: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

29: ,x_msg_data OUT NOCOPY VARCHAR2
30: ) is
31:
32: l_count NUMBER;
33: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
34: l_app_short_name VARCHAR2(30);
35: l_report_xml_name VARCHAR2(30);
36:
37: begin

Line 42: from fnd_form_functions

38:
39: fnd_msg_pub.initialize;
40:
41: select count(*) into l_count
42: from fnd_form_functions
43: where function_name = p_report_function_name;
44:
45: if (l_count > 0) then
46: -- Trying to update a non-report function.

Line 131: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;

127: ) is
128:
129: l_count NUMBER;
130: l_function_id NUMBER := 0;
131: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
132: l_app_short_name VARCHAR2(30);
133: l_type VARCHAR2(30);
134: l_report_function_name fnd_form_functions.function_name%TYPE;
135: l_application_id NUMBER;

Line 134: l_report_function_name fnd_form_functions.function_name%TYPE;

130: l_function_id NUMBER := 0;
131: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
132: l_app_short_name VARCHAR2(30);
133: l_type VARCHAR2(30);
134: l_report_function_name fnd_form_functions.function_name%TYPE;
135: l_application_id NUMBER;
136: l_menu_name FND_MENUS.Menu_Name%Type := NULL;
137: l_report_xml_name VARCHAR2(30);
138: begin

Line 146: from fnd_form_functions

142: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE),
143: function_id,
144: parameters
145: into l_type, l_function_id, l_parameters
146: from fnd_form_functions
147: where function_name = p_report_function_name;
148: exception
149: when no_data_found then l_type := null;
150: end;

Line 183: from fnd_form_functions

179: -- Update form function
180: if l_report_function_name <> p_report_function_name then
181: -- Check if new function already exists.
182: select count(*) into l_count
183: from fnd_form_functions
184: where function_name = l_report_function_name;
185:
186: if (l_count > 0) then
187: -- Duplicate function name

Line 193: UPDATE fnd_form_functions

189: FND_MSG_PUB.ADD;
190: RAISE FND_API.G_EXC_ERROR;
191: end if;
192:
193: UPDATE fnd_form_functions
194: SET function_name = l_report_function_name
195: WHERE function_id = l_function_id;
196: end if;
197: