APPS.IES_SVY_DEPLOYMENT_PVT dependencies on AMS_LIST_ENTRIES

Line 362: FROM AMS_LIST_ENTRIES

358: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
359:
360: CURSOR CEMAILADD IS
361: SELECT EMAIL_ADDRESS
362: FROM AMS_LIST_ENTRIES
363: WHERE LIST_ENTRY_ID = p_list_entry_id;
364:
365: CURSOR CEMAILSUBJECTHEADING IS
366: SELECT EMAIL_SUBJECT_HEADING

Line 751: l_list_entry_id ams_list_entries.list_entry_id%type;

747: l_content_type NUMBER;
748: l_content_type_text VARCHAR2(30);
749: v_count NUMBER;
750: l_list_header_id ies_svy_deplyments_all.list_header_id%type;
751: l_list_entry_id ams_list_entries.list_entry_id%type;
752:
753: l_anonymous_code VARCHAR2(10) := 'NO';
754: l_max_responses_per_person NUMBER;
755: l_no_of_responses_recd NUMBER := 0;

Line 1141: l_list_entry_id AMS_LIST_ENTRIES.LIST_ENTRY_ID%TYPE ;

1137: l_Error_Msg VARCHAR2(2000) ;
1138: l_random_number BINARY_INTEGER ;
1139: l_total_list_entries NUMBER := 0 ;
1140: l_list_header_id IES_SVY_DEPLYMENTS_ALL.LIST_HEADER_ID%TYPE ;
1141: l_list_entry_id AMS_LIST_ENTRIES.LIST_ENTRY_ID%TYPE ;
1142: l_seed NUMBER ;
1143: l_time_in_sec NUMBER ;
1144: l_api_name VARCHAR2(30) := 'Populate_Survey_List_Entries' ;
1145: l_count_value NUMBER ;

Line 1150: FROM AMS_LIST_ENTRIES

1146: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1147:
1148: CURSOR CLISTENTRYID IS
1149: SELECT LIST_ENTRY_ID
1150: FROM AMS_LIST_ENTRIES
1151: WHERE LIST_HEADER_ID = l_list_header_id
1152: AND ENABLED_FLAG = 'Y';
1153: BEGIN
1154:

Line 1208: FROM AMS_LIST_ENTRIES

1204: END;
1205:
1206: BEGIN
1207: SELECT COUNT(*) INTO l_total_list_entries
1208: FROM AMS_LIST_ENTRIES
1209: WHERE LIST_HEADER_ID = l_list_header_id;
1210:
1211: EXCEPTION
1212: WHEN NO_DATA_FOUND THEN

Line 1213: l_Error_Msg := 'AMS_LIST_ENTRIES doesn''t have list_header_id';

1209: WHERE LIST_HEADER_ID = l_list_header_id;
1210:
1211: EXCEPTION
1212: WHEN NO_DATA_FOUND THEN
1213: l_Error_Msg := 'AMS_LIST_ENTRIES doesn''t have list_header_id';
1214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1215: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1216: FND_MSG_PUB.Add;
1217: END IF;