APPS.AMS_IMPORT_XML_PVT dependencies on AMS_IMP_DOCUMENTS

Line 217: x_file_type OUT NOCOPY AMS_IMP_DOCUMENTS.FILE_TYPE%TYPE,

213: -- Initial version: 1.0
214: -- End of comments
215: PROCEDURE Get_File_Type (
216: p_import_list_header_id IN NUMBER,
217: x_file_type OUT NOCOPY AMS_IMP_DOCUMENTS.FILE_TYPE%TYPE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_data OUT NOCOPY VARCHAR2
220: )
221: IS

Line 227: FROM AMS_IMP_DOCUMENTS

223: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
224:
225: CURSOR c_file_type (p_import_list_header_id NUMBER) IS
226: SELECT FILE_TYPE
227: FROM AMS_IMP_DOCUMENTS
228: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
229: BEGIN
230:
231: --

Line 288: FROM AMS_IMP_DOCUMENTS

284: SELECT *
285: FROM AMS_IMP_XML_ELEMENTS
286: WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
287: AND EXISTS (SELECT 1
288: FROM AMS_IMP_DOCUMENTS
289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id
290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);
291: BEGIN
292:

Line 289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id

285: FROM AMS_IMP_XML_ELEMENTS
286: WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
287: AND EXISTS (SELECT 1
288: FROM AMS_IMP_DOCUMENTS
289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id
290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);
291: BEGIN
292:
293: --

Line 290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);

286: WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
287: AND EXISTS (SELECT 1
288: FROM AMS_IMP_DOCUMENTS
289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id
290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);
291: BEGIN
292:
293: --
294: -- Initialize API return status to success.

Line 901: FROM AMS_IMP_DOCUMENTS

897: ORDER BY LIST_SOURCE_FIELD_ID;
898:
899: CURSOR c_xml_doc_content (p_import_list_header_id NUMBER) IS
900: SELECT CONTENT_TEXT, IMP_DOCUMENT_ID
901: FROM AMS_IMP_DOCUMENTS
902: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
903:
904: XMLParseError EXCEPTION;
905: PRAGMA EXCEPTION_INIT (XMLParseError, -20100);

Line 959: FROM AMS_IMP_DOCUMENTS

955: p_source_col_name => '(' || l_actual_root_name || ')'
956: );
957:
958: SELECT FILTER_CONTENT_TEXT INTO l_result_xml_content
959: FROM AMS_IMP_DOCUMENTS
960: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id
961: FOR UPDATE;
962:
963: xmldom.writeToClob(l_dom_actual_root, l_result_xml_content);

Line 1108: FROM AMS_IMP_DOCUMENTS

1104: ORDER BY LIST_SOURCE_FIELD_ID;
1105:
1106: CURSOR c_xml_content (p_import_list_header_id NUMBER) IS
1107: SELECT CONTENT_TEXT
1108: FROM AMS_IMP_DOCUMENTS
1109: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
1110:
1111: XMLParseError EXCEPTION;
1112: PRAGMA EXCEPTION_INIT (XMLParseError, -20100);

Line 1188: FROM AMS_IMP_DOCUMENTS

1184: p_result_doc => l_temp_doc
1185: );
1186:
1187: SELECT FILTER_CONTENT_TEXT INTO l_result_xml_content
1188: FROM AMS_IMP_DOCUMENTS
1189: WHERE IMPORT_LIST_HEADER_ID = p_imp_list_header_id
1190: FOR UPDATE;
1191:
1192: xmldom.writeToClob (l_result_xml_node, l_result_xml_content);

Line 1551: FROM AMS_IMP_DOCUMENTS

1547: l_doc_id NUMBER;
1548:
1549: CURSOR c_doc_id (p_import_list_header_id NUMBER) IS
1550: SELECT IMP_DOCUMENT_ID
1551: FROM AMS_IMP_DOCUMENTS
1552: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
1553:
1554: CURSOR c_status_id
1555: IS SELECT user_status_id

Line 1673: FROM AMS_IMP_DOCUMENTS

1669: )
1670: IS
1671: CURSOR c_xml_doc (p_import_list_header_id NUMBER)
1672: IS SELECT CONTENT_TEXT
1673: FROM AMS_IMP_DOCUMENTS
1674: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
1675:
1676: l_xml_clob c_xml_doc%ROWTYPE;
1677: l_doc_length NUMBER;