DBA Data[Home] [Help]

APPS.SOA_GENERATE dependencies on FND_OBJECTS

Line 753: select fnd_objects_s.nextval

749: and class_type = c_entry_type
750: for update ;
751:
752: cursor c_irep_class_id is
753: select fnd_objects_s.nextval
754: from dual;
755:
756: l_class_id number;
757:

Line 1683: from fnd_objects

1679: is
1680:
1681: cursor c_object(c_object_id in number) is
1682: select count(*) l_count
1683: from fnd_objects
1684: where object_id = c_object_id;
1685:
1686:
1687: cursor c_object_name(c_object_id in number) is

Line 1689: from fnd_objects

1685:
1686:
1687: cursor c_object_name(c_object_id in number) is
1688: select obj_name ,irep_name
1689: from fnd_objects
1690: where object_id = c_object_id;
1691:
1692: c_object_rec c_object%ROWTYPE;
1693:

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,

Line 1801: from fnd_objects_vl

1797: is
1798:
1799: cursor c_base_object_entry(c_base_object_id in number) is
1800: select *
1801: from fnd_objects_vl
1802: where object_id = c_base_object_id;
1803:
1804: c_base_object_entry_rec c_base_object_entry%ROWTYPE;
1805:

Line 2044: from fnd_objects

2040: is
2041:
2042: cursor c_base_object_entry(c_base_object_id in number) is
2043: select *
2044: from fnd_objects
2045: where object_id = c_base_object_id;
2046:
2047: c_base_object_entry_rec c_base_object_entry%ROWTYPE;
2048: