APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 57: FROM AMS_IMP_LIST_HEADERS_ALL

53: where list_source_type_id = p_src_type_id ;
54:
55: CURSOR c_get_import_type(p_import_list_header_id number) is
56: SELECT import_type, b2b_flag
57: FROM AMS_IMP_LIST_HEADERS_ALL
58: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
59: l_import_type c_get_import_type%ROWTYPE;
60:
61: CURSOR c_get_list_source_name(name VARCHAR2) IS

Line 228: update ams_imp_list_headers_all

224:
225: l_list_source_type_id := px_src_type_id ;
226: ****/
227: IF p_source_name = l_old_map_name THEN
228: update ams_imp_list_headers_all
229: set LIST_SOURCE_TYPE_ID = px_src_type_id,
230: last_update_date= SYSDATE
231: where IMPORT_LIST_HEADER_ID = p_imp_list_header_id;
232: RETURN;

Line 428: update ams_imp_list_headers_all

424: FND_MSG_PUB.Add;
425: RAISE FND_API.g_exc_error;
426: end if;
427:
428: update ams_imp_list_headers_all
429: set LIST_SOURCE_TYPE_ID = l_list_source_type_id
430: where IMPORT_LIST_HEADER_ID = p_imp_list_header_id ;
431:
432: IF x_return_status = fnd_api.g_ret_sts_error THEN