APPS.WF_WS_GEN dependencies on FND_IREP_CLASSES

Line 168: from fnd_irep_classes

164: is
165:
166: cursor c_classes(c_module_name in varchar) is
167: select class_id,class_type
168: from fnd_irep_classes
169: where class_type = c_module_name ;
170:
171: l_count pls_integer := 0;
172:

Line 228: from fnd_irep_classes

224: )
225: is
226: cursor c_class_id(c_irep_class_name in varchar2) is
227: select class_id
228: from fnd_irep_classes
229: where irep_name = c_irep_class_name;
230:
231: l_derived_interface_name varchar2(2000) := null;
232: l_count pls_integer := 0;

Line 290: from fnd_irep_classes

286:
287: is
288: cursor c_class(c_class_id in number) is
289: select count(*) l_count
290: from fnd_irep_classes
291: where class_id = c_class_id;
292:
293: cursor c_class_name(c_class_id in number) is
294: select class_name ,irep_name

Line 295: from fnd_irep_classes

291: where class_id = c_class_id;
292:
293: cursor c_class_name(c_class_id in number) is
294: select class_name ,irep_name
295: from fnd_irep_classes
296: where class_id = c_class_id;
297:
298: c_class_rec c_class%ROWTYPE;
299:

Line 400: from fnd_irep_classes_vl

396: is
397:
398: cursor c_base_class_entry(c_base_class_id in number) is
399: select *
400: from fnd_irep_classes_vl
401: where class_id = c_base_class_id;
402:
403: c_base_class_entry_rec c_base_class_entry%ROWTYPE;
404:

Line 870: from fnd_irep_classes

866: )
867: is
868: cursor c_derived_class(c_class_name in varchar) is
869: select *
870: from fnd_irep_classes
871: where class_name = c_class_name
872: and class_type = 'WEBSERVICEDOC'
873: for update ;
874:

Line 903: insert into FND_IREP_CLASSES

899: open c_irep_class_id;
900: fetch c_irep_class_id into l_class_id;
901: close c_irep_class_id;
902:
903: insert into FND_IREP_CLASSES
904: (
905: CLASS_ID,
906: CLASS_NAME,
907: IREP_NAME,

Line 994: update fnd_irep_classes

990: elsif c_derived_class%FOUND then
991: --Update the existing record
992:
993: begin
994: update fnd_irep_classes
995: set irep_name = p_irep_name,
996: last_updated_by = 0,
997: last_update_date = sysdate,
998: last_update_login = 0,

Line 1508: from fnd_irep_classes_tl

1504: c_class_id number,
1505: c_language in varchar2
1506: ) is
1507: select *
1508: from fnd_irep_classes_tl
1509: where class_id = c_class_id
1510: and language = c_language
1511: for update ;
1512:

Line 1517: from fnd_irep_classes

1513: c_class_language_rec c_class_language%ROWTYPE;
1514:
1515: cursor c_class_name(c_class_id in number) is
1516: select class_name
1517: from fnd_irep_classes
1518: where class_id = c_class_id;
1519:
1520: p_derived_class_name varchar2(430) := null;
1521:

Line 1538: insert into FND_IREP_CLASSES_TL

1534: fetch c_class_language into c_class_language_rec;
1535:
1536: if c_class_language%NOTFOUND then
1537:
1538: insert into FND_IREP_CLASSES_TL
1539: (
1540: CLASS_ID,
1541: LANGUAGE,
1542: SOURCE_LANG,

Line 1569: update fnd_irep_classes_tl

1565: );
1566:
1567: elsif c_class_language%FOUND then
1568:
1569: update fnd_irep_classes_tl
1570: set display_name = p_display_name,
1571: short_description = p_short_description,
1572: source_lang = p_source_lang,
1573: last_update_date = sysdate,

Line 1610: from fnd_irep_classes_tl

1606:
1607: is
1608: cursor c_base_class_tl(c_base_class_id in pls_integer) is
1609: select *
1610: from fnd_irep_classes_tl
1611: where class_id = c_base_class_id;
1612:
1613: c_base_class_tl_rec c_base_class_tl%ROWTYPE;
1614:

Line 1617: from fnd_irep_classes

1613: c_base_class_tl_rec c_base_class_tl%ROWTYPE;
1614:
1615: cursor c_class_name(c_class_id in number) is
1616: select class_name
1617: from fnd_irep_classes
1618: where class_id = c_class_id;
1619:
1620: p_derived_class_name varchar2(430) := null;
1621:

Line 1771: where obj_name = 'FND_IREP_CLASSES'

1767:
1768: cursor c1(c_base_class_id in number) is
1769: select *
1770: from fnd_lookup_assignments
1771: where obj_name = 'FND_IREP_CLASSES'
1772: and lookup_type = 'BUSINESS_ENTITY'
1773: and instance_pk1_value = c_base_class_id;
1774:
1775: c1_rec c1%ROWTYPE;

Line 1784: where obj_name = 'FND_IREP_CLASSES'

1780: c_lookup_code in varchar2
1781: ) is
1782: select *
1783: from fnd_lookup_assignments
1784: where obj_name = 'FND_IREP_CLASSES'
1785: and lookup_type = 'BUSINESS_ENTITY'
1786: and instance_pk1_value = c_derived_class_id
1787: and lookup_code = c_lookup_code
1788: for update ;

Line 1800: from fnd_irep_classes

1796: c3_rec c3%ROWTYPE;
1797:
1798: cursor c_class_name(c_class_id in number) is
1799: select class_name
1800: from fnd_irep_classes
1801: where class_id = c_class_id;
1802:
1803: p_derived_class_name varchar2(430) := null;
1804: