APPS.AMS_XML_ELEMENT_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 359: FROM AMS_IMP_LIST_HEADERS_ALL

355: -- Hint: Developer need to provide Where clause
356:
357: CURSOR c_get_import_type (p_header_id NUMBER) IS
358: SELECT IMPORT_TYPE
359: FROM AMS_IMP_LIST_HEADERS_ALL
360: WHERE IMPORT_LIST_HEADER_ID = p_header_id;
361:
362: CURSOR c_get_header_id (p_imp_xml_doc_id NUMBER ) IS
363: SELECT IMPORT_LIST_HEADER_ID

Line 510: UPDATE ams_imp_list_headers_all

506: write_msg(' a test 01::l_element_rec.imp_xml_element_id' || l_element_rec.imp_xml_element_id
507: || ' and the l_header_id.IMPORT_LIST_HEADER_ID::'
508: || l_header_id.IMPORT_LIST_HEADER_ID );
509: IF l_header_id.IMPORT_LIST_HEADER_ID IS NOT NULL THEN
510: UPDATE ams_imp_list_headers_all
511: SET execute_mode = 'R'
512: WHERE import_list_header_id = l_header_id.IMPORT_LIST_HEADER_ID;
513:
514: UPDATE ams_imp_source_lines

Line 855: FROM AMS_IMP_LIST_HEADERS_ALL

851: -- Hint: Developer need to provide Where clause
852:
853: CURSOR c_get_import_type (p_header_id NUMBER) IS
854: SELECT IMPORT_TYPE
855: FROM AMS_IMP_LIST_HEADERS_ALL
856: WHERE IMPORT_LIST_HEADER_ID = p_header_id;
857:
858: CURSOR c_get_header_id (p_imp_xml_doc_id NUMBER ) IS
859: SELECT IMPORT_LIST_HEADER_ID

Line 1024: UPDATE ams_imp_list_headers_all

1020: FETCH c_get_header_id INTO l_header_id;
1021: CLOSE c_get_header_id;
1022:
1023: IF l_header_id.IMPORT_LIST_HEADER_ID IS NOT NULL THEN
1024: UPDATE ams_imp_list_headers_all
1025: SET execute_mode = 'R'
1026: WHERE import_list_header_id = l_header_id.IMPORT_LIST_HEADER_ID;
1027: END IF;
1028: