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 and irep_scope = 'PUBLIC';
172:
173: public_method_count pls_integer := 0;
174: p_base_class_name varchar2(430) := null;

Line 279: from fnd_form_functions_vl

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

Line 975: from fnd_form_functions

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

Line 981: select fnd_form_functions_s.nextval

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

Line 1001: insert into FND_FORM_FUNCTIONS

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

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

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

Line 1112: update fnd_form_functions

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

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

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

Line 1208: from fnd_form_functions_tl

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

Line 1213: from fnd_form_functions

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

Line 1278: from fnd_form_functions_tl

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

Line 1287: from fnd_form_functions

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

Line 1309: insert into FND_FORM_FUNCTIONS_TL

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

Line 1338: update fnd_form_functions_tl

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

Line 1696: from fnd_form_functions

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

Line 1808: from fnd_form_functions

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

Line 2051: select fnd_form_functions_s.nextval

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

Line 2113: insert into FND_FORM_FUNCTIONS

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