APPS.SOA_GENERATE dependencies on FND_FORM_FUNCTIONS

Line 170: from fnd_form_functions

166: c_class_rec c_class%ROWTYPE;
167:
168: cursor c_methods(c_class_id in number) is
169: select function_id
170: from fnd_form_functions
171: where irep_class_id = c_class_id ;
172:
173: method_count pls_integer := 0;
174: p_base_class_name varchar2(430) := null;

Line 277: from fnd_form_functions_vl

273: c_base_class_entry_rec c_base_class_entry%ROWTYPE;
274:
275: cursor c_base_function_entry(c_base_function_id in number) is
276: select *
277: from fnd_form_functions_vl
278: where function_id = c_base_function_id;
279:
280: c_base_function_entry_rec c_base_function_entry%ROWTYPE;
281:

Line 973: from fnd_form_functions

969: )
970: is
971: cursor c_derived_method(c_function_name in varchar) is
972: select *
973: from fnd_form_functions
974: where function_name = c_function_name
975: and type = 'INTERFACE'
976: for update;
977:

Line 979: select fnd_form_functions_s.nextval

975: and type = 'INTERFACE'
976: for update;
977:
978: cursor c_irep_function_id is
979: select fnd_form_functions_s.nextval
980: from dual;
981:
982: l_function_id number := 0;
983:

Line 999: insert into FND_FORM_FUNCTIONS

995: open c_irep_function_id;
996: fetch c_irep_function_id into l_function_id;
997: close c_irep_function_id;
998:
999: insert into FND_FORM_FUNCTIONS
1000: (
1001: FUNCTION_ID,
1002: FUNCTION_NAME,
1003: APPLICATION_ID,

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

1097: when program_exit then
1098: raise program_exit;
1099: when others then
1100: p_err_code := -1;
1101: p_err_message := 'Error in inserting to fnd_form_functions'||SQLERRM;
1102: raise program_exit;
1103: end;
1104:
1105:

Line 1110: update fnd_form_functions

1106:
1107: elsif c_derived_method%FOUND then
1108: --Update the existing entry
1109: begin
1110: update fnd_form_functions
1111: set
1112: APPLICATION_ID = p_application_id,
1113: FORM_ID = p_form_id,
1114: PARAMETERS = p_parameters,

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

1168: when program_exit then
1169: raise program_exit;
1170: when others then
1171: p_err_code := -1;
1172: p_err_message := 'Error in Updating fnd_form_functions'||SQLERRM;
1173: raise program_exit;
1174: end;
1175:
1176: end if;

Line 1206: from fnd_form_functions_tl

1202:
1203: is
1204: cursor c_base_function_tl(c_base_function_id in pls_integer) is
1205: select *
1206: from fnd_form_functions_tl
1207: where function_id = c_base_function_id;
1208:
1209: cursor c_function_name(c_function_id in number) is
1210: select function_name

Line 1211: from fnd_form_functions

1207: where function_id = c_base_function_id;
1208:
1209: cursor c_function_name(c_function_id in number) is
1210: select function_name
1211: from fnd_form_functions
1212: where function_id = c_function_id;
1213:
1214: p_function_name varchar2(430) := null;
1215: c_base_function_tl_rec c_base_function_tl%ROWTYPE;

Line 1276: from fnd_form_functions_tl

1272: c_function_id number,
1273: c_language in varchar2
1274: ) is
1275: select *
1276: from fnd_form_functions_tl
1277: where function_id = c_function_id
1278: and language = c_language
1279: for update ;
1280:

Line 1285: from fnd_form_functions

1281: c_function_language_rec c_function_language%ROWTYPE;
1282:
1283: cursor c_function_name(c_function_id in number) is
1284: select function_name
1285: from fnd_form_functions
1286: where function_id = c_function_id;
1287:
1288: p_function_name varchar2(430) := null;
1289:

Line 1307: insert into FND_FORM_FUNCTIONS_TL

1303: fetch c_function_language into c_function_language_rec;
1304:
1305: if c_function_language%NOTFOUND then
1306:
1307: insert into FND_FORM_FUNCTIONS_TL
1308: (
1309: LANGUAGE,
1310: FUNCTION_ID,
1311: USER_FUNCTION_NAME,

Line 1336: update fnd_form_functions_tl

1332: );
1333:
1334: elsif c_function_language%FOUND then
1335:
1336: update fnd_form_functions_tl
1337: set user_function_name = p_user_function_name,
1338: description = p_description,
1339: source_lang = p_source_lang,
1340: last_update_date = sysdate,

Line 1694: from fnd_form_functions

1690: c_object_rec c_object%ROWTYPE;
1691:
1692: cursor c_methods(c_object_id in number) is
1693: select function_id
1694: from fnd_form_functions
1695: where irep_class_id = c_object_id ;
1696:
1697: method_count pls_integer := 0;
1698: p_base_object_name varchar2(430) := null;

Line 1806: from fnd_form_functions

1802: c_base_object_entry_rec c_base_object_entry%ROWTYPE;
1803:
1804: cursor c_base_function_entry(c_base_function_id in number) is
1805: select *
1806: from fnd_form_functions
1807: where function_id = c_base_function_id;
1808:
1809: c_base_function_entry_rec c_base_function_entry%ROWTYPE;
1810:

Line 2049: select fnd_form_functions_s.nextval

2045: c_base_object_entry_rec c_base_object_entry%ROWTYPE;
2046:
2047:
2048: cursor c_irep_function_id is
2049: select fnd_form_functions_s.nextval
2050: from dual;
2051:
2052: --l_function_id number := 0;
2053:

Line 2111: insert into FND_FORM_FUNCTIONS

2107:
2108: open c_irep_function_id;
2109: fetch c_irep_function_id into l_function_id;
2110: close c_irep_function_id;
2111: insert into FND_FORM_FUNCTIONS
2112: (
2113: FUNCTION_ID,
2114: FUNCTION_NAME,
2115: APPLICATION_ID,