DBA Data[Home] [Help]

APPS.AMS_IMPORT_XML_PVT dependencies on AMS_IMP_XML_ELEMENTS

Line 50: TABLE OF AMS_IMP_XML_ELEMENTS%ROWTYPE INDEX BY BINARY_INTEGER;

46: TYPE xml_target_column_set_type IS
47: TABLE OF AMS_LIST_SRC_FIELDS.FIELD_COLUMN_NAME%TYPE INDEX BY BINARY_INTEGER;
48:
49: TYPE xml_element_set_type IS
50: TABLE OF AMS_IMP_XML_ELEMENTS%ROWTYPE INDEX BY BINARY_INTEGER;
51:
52: TYPE rc_type IS REF CURSOR RETURN AMS_IMP_XML_ELEMENTS%ROWTYPE;
53:
54: -- Start of comments

Line 52: TYPE rc_type IS REF CURSOR RETURN AMS_IMP_XML_ELEMENTS%ROWTYPE;

48:
49: TYPE xml_element_set_type IS
50: TABLE OF AMS_IMP_XML_ELEMENTS%ROWTYPE INDEX BY BINARY_INTEGER;
51:
52: TYPE rc_type IS REF CURSOR RETURN AMS_IMP_XML_ELEMENTS%ROWTYPE;
53:
54: -- Start of comments
55: -- API Name Store_XML_Util
56: -- Type Public

Line 138: -- "AMS_IMP_XML_ELEMENTS" table, given the

134: -- API Name Get_Root_Node
135: -- Type Public
136: -- Pre-reqs None.
137: -- Function Retrieve the information for the root node in the
138: -- "AMS_IMP_XML_ELEMENTS" table, given the
139: -- "import_list_header_id".
140: -- Parameters
141: -- IN
142: -- p_import_list_header_id NUMBER Required

Line 143: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

139: -- "import_list_header_id".
140: -- Parameters
141: -- IN
142: -- p_import_list_header_id NUMBER Required
143: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
144: -- x_return_status VARCHAR2
145: -- x_msg_data VARCHAR2
146: --
147: -- Version Current version: 1.0

Line 153: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

149: -- Initial version: 1.0
150: -- End of comments
151: PROCEDURE Get_Root_Node (
152: p_import_list_header_id IN NUMBER,
153: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_data OUT NOCOPY VARCHAR2
156: );
157:

Line 163: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

159: -- API Name Get_Parent_Node
160: -- Type Public
161: -- Pre-reqs None.
162: -- Function Retrieve the information for the parent node in the
163: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
164: -- Parameters
165: -- IN
166: -- p_imp_xml_element_id NUMBER Required
167: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 167: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

163: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
164: -- Parameters
165: -- IN
166: -- p_imp_xml_element_id NUMBER Required
167: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
168: -- x_return_status VARCHAR2
169: -- x_msg_data VARCHAR2
170: --
171: -- Version Current version: 1.0

Line 177: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

173: -- Initial version: 1.0
174: -- End of comments
175: PROCEDURE Get_Parent_Node (
176: p_imp_xml_element_id IN NUMBER,
177: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_data OUT NOCOPY VARCHAR2
180: );
181:

Line 187: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

183: -- API Name Get_First_Child_Node
184: -- Type Public
185: -- Pre-reqs None.
186: -- Function Retrieve the information for the first child node in the
187: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
188: -- Parameters
189: -- IN
190: -- p_imp_xml_element_id NUMBER Required
191: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 191: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

187: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
188: -- Parameters
189: -- IN
190: -- p_imp_xml_element_id NUMBER Required
191: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
192: -- x_return_status VARCHAR2
193: -- x_msg_data VARCHAR2
194: --
195: -- Version Current version: 1.0

Line 201: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

197: -- Initial version: 1.0
198: -- End of comments
199: PROCEDURE Get_First_Child_Node (
200: p_imp_xml_element_id IN NUMBER,
201: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_data OUT NOCOPY VARCHAR2
204: );
205:

Line 211: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

207: -- API Name Get_Next_Sibling_Node
208: -- Type Public
209: -- Pre-reqs None.
210: -- Function Retrieve the information for the next sibling node in the
211: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
212: -- Parameters
213: -- IN
214: -- p_imp_xml_element_id NUMBER Required
215: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 215: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

211: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
212: -- Parameters
213: -- IN
214: -- p_imp_xml_element_id NUMBER Required
215: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
216: -- x_return_status VARCHAR2
217: --
218: -- Version Current version: 1.0
219: -- Previous version: 1.0

Line 224: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

220: -- Initial version: 1.0
221: -- End of comments
222: PROCEDURE Get_Next_Sibling_Node (
223: p_imp_xml_element_id IN NUMBER,
224: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_data OUT NOCOPY VARCHAR2
227: );
228:

Line 251: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

247: -- API Name Get_Children_Nodes
248: -- Type Public
249: -- Pre-reqs None.
250: -- Function Retrieve the information for all child nodes in the
251: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
252: -- Parameters
253: -- IN
254: -- p_imp_xml_element_id NUMBER Required
255: -- OUT x_child_ids xml_element_key_set_type

Line 275: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

271: -- API Name Get_Children_Nodes
272: -- Type Public
273: -- Pre-reqs None.
274: -- Function Retrieve the information for all child nodes in the
275: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
276: -- Parameters
277: -- IN
278: -- p_imp_xml_element_id NUMBER Required
279: -- OUT x_child_set xml_element_key_set_type

Line 299: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

295: -- API Name Get_Children_Nodes
296: -- Type Public
297: -- Pre-reqs None.
298: -- Function Retrieve the information for all child nodes in the
299: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
300: -- Parameters
301: -- IN
302: -- p_imp_xml_element_id NUMBER Required
303: -- OUT x_rc_child_set rc_type