APPS.WF_WS_GEN dependencies on FND_FORM_FUNCTIONS

Line 302: from fnd_form_functions

298: c_class_rec c_class%ROWTYPE;
299:
300: cursor c_methods(c_class_id in number) is
301: select function_id
302: from fnd_form_functions
303: where irep_class_id = c_class_id ;
304:
305: method_count pls_integer := 0;
306: p_base_class_name varchar2(430) := null;

Line 407: from fnd_form_functions_vl

403: c_base_class_entry_rec c_base_class_entry%ROWTYPE;
404:
405: cursor c_base_function_entry(c_base_function_id in number) is
406: select *
407: from fnd_form_functions_vl
408: where function_id = c_base_function_id;
409:
410: c_base_function_entry_rec c_base_function_entry%ROWTYPE;
411:

Line 1098: from fnd_form_functions

1094: )
1095: is
1096: cursor c_derived_method(c_function_name in varchar) is
1097: select *
1098: from fnd_form_functions
1099: where function_name = c_function_name
1100: and type = 'INTERFACE'
1101: for update;
1102:

Line 1104: select fnd_form_functions_s.nextval

1100: and type = 'INTERFACE'
1101: for update;
1102:
1103: cursor c_irep_function_id is
1104: select fnd_form_functions_s.nextval
1105: from dual;
1106:
1107: l_function_id number := 0;
1108:

Line 1124: insert into FND_FORM_FUNCTIONS

1120: open c_irep_function_id;
1121: fetch c_irep_function_id into l_function_id;
1122: close c_irep_function_id;
1123:
1124: insert into FND_FORM_FUNCTIONS
1125: (
1126: FUNCTION_ID,
1127: FUNCTION_NAME,
1128: APPLICATION_ID,

Line 1226: p_err_message := 'Error in inserting to fnd_form_functions'||SQLERRM;

1222: when program_exit then
1223: raise program_exit;
1224: when others then
1225: p_err_code := -1;
1226: p_err_message := 'Error in inserting to fnd_form_functions'||SQLERRM;
1227: raise program_exit;
1228: end;
1229:
1230:

Line 1235: update fnd_form_functions

1231:
1232: elsif c_derived_method%FOUND then
1233: --Update the existing entry
1234: begin
1235: update fnd_form_functions
1236: set
1237: APPLICATION_ID = p_application_id,
1238: FORM_ID = p_form_id,
1239: PARAMETERS = p_parameters,

Line 1297: p_err_message := 'Error in Updating fnd_form_functions'||SQLERRM;

1293: when program_exit then
1294: raise program_exit;
1295: when others then
1296: p_err_code := -1;
1297: p_err_message := 'Error in Updating fnd_form_functions'||SQLERRM;
1298: raise program_exit;
1299: end;
1300:
1301: end if;

Line 1332: from fnd_form_functions_tl

1328:
1329: is
1330: cursor c_base_function_tl(c_base_function_id in pls_integer) is
1331: select *
1332: from fnd_form_functions_tl
1333: where function_id = c_base_function_id;
1334:
1335: cursor c_function_name(c_function_id in number) is
1336: select function_name

Line 1337: from fnd_form_functions

1333: where function_id = c_base_function_id;
1334:
1335: cursor c_function_name(c_function_id in number) is
1336: select function_name
1337: from fnd_form_functions
1338: where function_id = c_function_id;
1339:
1340: p_function_name varchar2(430) := null;
1341: c_base_function_tl_rec c_base_function_tl%ROWTYPE;

Line 1402: from fnd_form_functions_tl

1398: c_function_id number,
1399: c_language in varchar2
1400: ) is
1401: select *
1402: from fnd_form_functions_tl
1403: where function_id = c_function_id
1404: and language = c_language
1405: for update ;
1406:

Line 1411: from fnd_form_functions

1407: c_function_language_rec c_function_language%ROWTYPE;
1408:
1409: cursor c_function_name(c_function_id in number) is
1410: select function_name
1411: from fnd_form_functions
1412: where function_id = c_function_id;
1413:
1414: p_function_name varchar2(430) := null;
1415:

Line 1433: insert into FND_FORM_FUNCTIONS_TL

1429: fetch c_function_language into c_function_language_rec;
1430:
1431: if c_function_language%NOTFOUND then
1432:
1433: insert into FND_FORM_FUNCTIONS_TL
1434: (
1435: LANGUAGE,
1436: FUNCTION_ID,
1437: USER_FUNCTION_NAME,

Line 1462: update fnd_form_functions_tl

1458: );
1459:
1460: elsif c_function_language%FOUND then
1461:
1462: update fnd_form_functions_tl
1463: set user_function_name = p_user_function_name,
1464: description = p_description,
1465: source_lang = p_source_lang,
1466: last_update_date = sysdate,

Line 1912: from fnd_form_functions

1908: for update;
1909:
1910: cursor c_function_name(c_function_id in number) is
1911: select function_name
1912: from fnd_form_functions
1913: where function_id = c_function_id;
1914:
1915: p_function_name varchar2(430) := null;
1916: