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 270: from fnd_irep_classes_vl

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

Line 745: from fnd_irep_classes

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

Line 778: insert into fnd_irep_classes

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

Line 869: update fnd_irep_classes

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

Line 1382: from fnd_irep_classes_tl

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

Line 1391: from fnd_irep_classes

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

Line 1412: insert into fnd_irep_classes_TL

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

Line 1443: update fnd_irep_classes_tl

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

Line 1484: from fnd_irep_classes_tl

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

Line 1491: from fnd_irep_classes

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

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

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