APPS.SOA_GENERATE dependencies on FND_IREP_CLASSES

Line 158: from fnd_irep_classes

154:
155: is
156: cursor c_class(c_class_id in number) is
157: select count(*) l_count
158: from fnd_irep_classes
159: where class_id = c_class_id;
160:
161: cursor c_class_name(c_class_id in number) is
162: select class_name ,irep_name

Line 163: from fnd_irep_classes

159: where class_id = c_class_id;
160:
161: cursor c_class_name(c_class_id in number) is
162: select class_name ,irep_name
163: from fnd_irep_classes
164: where class_id = c_class_id;
165:
166: c_class_rec c_class%ROWTYPE;
167:

Line 272: from fnd_irep_classes_vl

268: is
269:
270: cursor c_base_class_entry(c_base_class_id in number) is
271: select *
272: from fnd_irep_classes_vl
273: where class_id = c_base_class_id;
274:
275: c_base_class_entry_rec c_base_class_entry%ROWTYPE;
276:

Line 747: from fnd_irep_classes

743: )
744: is
745: cursor c_derived_class(c_class_name in varchar, c_entry_type in varchar) is
746: select *
747: from fnd_irep_classes
748: where class_name = c_class_name
749: and class_type = c_entry_type
750: for update ;
751:

Line 780: insert into fnd_irep_classes

776: open c_irep_class_id;
777: fetch c_irep_class_id into l_class_id;
778: close c_irep_class_id;
779:
780: insert into fnd_irep_classes
781: (
782: CLASS_ID,
783: CLASS_NAME,
784: IREP_NAME,

Line 871: update fnd_irep_classes

867: elsif c_derived_class%FOUND then
868: --Update the existing record
869:
870: begin
871: update fnd_irep_classes
872: set irep_name = p_irep_name,
873: last_updated_by = 0,
874: last_update_date = sysdate,
875: last_update_login = 0,

Line 1384: from fnd_irep_classes_tl

1380: c_class_id number,
1381: c_language in varchar2
1382: ) is
1383: select *
1384: from fnd_irep_classes_tl
1385: where class_id = c_class_id
1386: and language = c_language
1387: for update ;
1388:

Line 1393: from fnd_irep_classes

1389: c_class_language_rec c_class_language%ROWTYPE;
1390:
1391: cursor c_class_name(c_class_id in number) is
1392: select class_name
1393: from fnd_irep_classes
1394: where class_id = c_class_id;
1395:
1396: p_derived_class_name varchar2(430) := null;
1397:

Line 1414: insert into fnd_irep_classes_TL

1410: fetch c_class_language into c_class_language_rec;
1411:
1412: if c_class_language%NOTFOUND then
1413:
1414: insert into fnd_irep_classes_TL
1415: (
1416: CLASS_ID,
1417: LANGUAGE,
1418: SOURCE_LANG,

Line 1445: update fnd_irep_classes_tl

1441: );
1442:
1443: elsif c_class_language%FOUND then
1444:
1445: update fnd_irep_classes_tl
1446: set display_name = p_display_name,
1447: short_description = p_short_description,
1448: source_lang = p_source_lang,
1449: last_update_date = sysdate,

Line 1486: from fnd_irep_classes_tl

1482:
1483: is
1484: cursor c_base_class_tl(c_base_class_id in pls_integer) is
1485: select *
1486: from fnd_irep_classes_tl
1487: where class_id = c_base_class_id;
1488:
1489: c_base_class_tl_rec c_base_class_tl%ROWTYPE;
1490:

Line 1493: from fnd_irep_classes

1489: c_base_class_tl_rec c_base_class_tl%ROWTYPE;
1490:
1491: cursor c_class_name(c_class_id in number) is
1492: select class_name
1493: from fnd_irep_classes
1494: where class_id = c_class_id;
1495:
1496: p_derived_class_name varchar2(430) := null;
1497:

Line 1785: Base entry is in fnd_objects and its derived entry would be made in fnd_irep_classes

1781: end create_object_derived_entry;
1782:
1783: /**
1784: Procedure for creating a Derived Entry for all functions of a base Object Entry
1785: Base entry is in fnd_objects and its derived entry would be made in fnd_irep_classes
1786: **/
1787: procedure create_obj_func_derived_entry
1788: (
1789: p_base_object_id in pls_integer,