APPS.ECX_UTILS dependencies on ECX_OBJECTS

Line 109: i_root_element ecx_objects.root_element%TYPE;

105: is
106: i_method_name varchar2(2000) := 'ecx_utils.load_objects';
107: i_counter pls_integer :=0;
108: k pls_integer;
109: i_root_element ecx_objects.root_element%TYPE;
110: i_fullpath ecx_objects.fullpath%TYPE;
111: i_dtd_path varchar2(200);
112: l_clob clob;
113:

Line 110: i_fullpath ecx_objects.fullpath%TYPE;

106: i_method_name varchar2(2000) := 'ecx_utils.load_objects';
107: i_counter pls_integer :=0;
108: k pls_integer;
109: i_root_element ecx_objects.root_element%TYPE;
110: i_fullpath ecx_objects.fullpath%TYPE;
111: i_dtd_path varchar2(200);
112: l_clob clob;
113:
114: begin

Line 1576: from ecx_objects eobj

1572: p_object_id IN pls_integer) IS
1573: select eobj.root_element,
1574: eobj.fullpath,
1575: eobj.runtime_location
1576: from ecx_objects eobj
1577: where eobj.object_id = p_object_id
1578: and eobj.map_id = p_map_id;
1579:
1580: cursor getDtdClob

Line 1595: l_fullpath ecx_objects.fullpath%TYPE;

1591: and ( version = p_location or p_location is null );
1592:
1593: i_dtdpayload CLOB;
1594: l_dtd_path Varchar2(200);
1595: l_fullpath ecx_objects.fullpath%TYPE;
1596: l_root_element ecx_objects.root_element%TYPE;
1597: l_doctype xmlDOM.DOMDocumentType;
1598: l_runtime_location varchar2(200);
1599:

Line 1596: l_root_element ecx_objects.root_element%TYPE;

1592:
1593: i_dtdpayload CLOB;
1594: l_dtd_path Varchar2(200);
1595: l_fullpath ecx_objects.fullpath%TYPE;
1596: l_root_element ecx_objects.root_element%TYPE;
1597: l_doctype xmlDOM.DOMDocumentType;
1598: l_runtime_location varchar2(200);
1599:
1600: t_dtdpayload CLOB;

Line 1601: t_fullpath ecx_objects.fullpath%TYPE;

1597: l_doctype xmlDOM.DOMDocumentType;
1598: l_runtime_location varchar2(200);
1599:
1600: t_dtdpayload CLOB;
1601: t_fullpath ecx_objects.fullpath%TYPE;
1602: t_root_element ecx_objects.root_element%TYPE;
1603: t_doctype xmlDOM.DOMDocumentType;
1604: t_runtime_location varchar2(200);
1605: i_tar_obj_type varchar2(200);

Line 1602: t_root_element ecx_objects.root_element%TYPE;

1598: l_runtime_location varchar2(200);
1599:
1600: t_dtdpayload CLOB;
1601: t_fullpath ecx_objects.fullpath%TYPE;
1602: t_root_element ecx_objects.root_element%TYPE;
1603: t_doctype xmlDOM.DOMDocumentType;
1604: t_runtime_location varchar2(200);
1605: i_tar_obj_type varchar2(200);
1606:

Line 1724: FROM ecx_objects

1720: end if;
1721: -- check if it is a pure Inbound case
1722: SELECT object_type
1723: INTO i_tar_obj_type
1724: FROM ecx_objects
1725: WHERE map_id = i_map_id
1726: AND object_id = 2;
1727:
1728: if (i_tar_obj_type not in ('DB'))