DBA Data[Home] [Help]

APPS.AMS_IMPORT_XML_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 894: FROM ams_list_src_fields A, ams_imp_list_headers_all b

890: l_dom_actual_root xmldom.DOMNode;
891:
892: CURSOR c_import_source_fields (p_import_list_header_id NUMBER) IS
893: SELECT A.SOURCE_COLUMN_NAME
894: FROM ams_list_src_fields A, ams_imp_list_headers_all b
895: WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
896: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
897: ORDER BY LIST_SOURCE_FIELD_ID;
898:

Line 1101: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1097: l_dom_actual_root xmldom.DOMNode;
1098:
1099: CURSOR c_import_mapping_fields (p_import_list_header_id NUMBER) IS
1100: SELECT A.SOURCE_COLUMN_NAME, A.FIELD_COLUMN_NAME
1101: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1102: WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
1103: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1104: ORDER BY LIST_SOURCE_FIELD_ID;
1105:

Line 1605: UPDATE AMS_IMP_LIST_HEADERS_ALL

1601: OPEN c_status_id;
1602: FETCH c_status_id INTO l_user_status_id;
1603: CLOSE c_status_id;
1604:
1605: UPDATE AMS_IMP_LIST_HEADERS_ALL
1606: SET STATUS_CODE = 'STAGED', USER_STATUS_ID = l_user_status_id
1607: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
1608: END IF;
1609: