DBA Data[Home] [Help]

APPS.AMS_LIST_WORD_REPLACES_PVT dependencies on AMS_LIST_WORD_FIELDS

Line 411: SELECT * FROM AMS_LIST_WORD_FIELDS

407: l_api_name CONSTANT VARCHAR2(30) := 'delete_list_word_replace';
408: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
409:
410: CURSOR c_list_word_fields IS
411: SELECT * FROM AMS_LIST_WORD_FIELDS
412: WHERE LIST_WORD_REPLACES_ID = p_wrd_rpl_id;
413: l_return_status VARCHAR2(80);
414: l_msg_count NUMBER;
415: l_msg_data VARCHAR2(4000);

Line 470: AMS_LIST_word_FIELDS_PVT.delete_list_word_field(

466: END IF;
467:
468: FOR l_word_fields_rec IN c_list_word_fields
469: LOOP
470: AMS_LIST_word_FIELDS_PVT.delete_list_word_field(
471: p_api_version => l_api_version,
472: p_init_msg_list => FND_API.g_true,
473: x_return_status => l_return_status,
474: x_msg_count => l_msg_count,