APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_DEPLYMENTS_ALL

Line 186: UPDATE ies_svy_deplyments_all

182: Update_Dep_Status(p_dep_id => p_deployment_id,
183: p_status => 'PENDING',
184: p_reminder_type => p_reminder_type,
185: p_update_flag => 'Y');
186: UPDATE ies_svy_deplyments_all
187: SET concurrent_req_id = l_schedule_id
188: WHERE survey_deployment_id = p_deployment_id;
189: END IF;
190:

Line 367: FROM IES_SVY_DEPLYMENTS_ALL

363: WHERE LIST_ENTRY_ID = p_list_entry_id;
364:
365: CURSOR CEMAILSUBJECTHEADING IS
366: SELECT EMAIL_SUBJECT_HEADING
367: FROM IES_SVY_DEPLYMENTS_ALL
368: WHERE SURVEY_DEPLOYMENT_ID = p_deployment_id;
369:
370: BEGIN
371: SAVEPOINT FM_Request_From_Survey;

Line 750: l_list_header_id ies_svy_deplyments_all.list_header_id%type;

746: l_content_no NUMBER;
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;

Line 768: FROM IES_SVY_DEPLYMENTS_ALL

764: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
765:
766: CURSOR CEMAILSUBJECTHEADING IS
767: SELECT EMAIL_SUBJECT_HEADING
768: FROM IES_SVY_DEPLYMENTS_ALL
769: WHERE SURVEY_DEPLOYMENT_ID = p_deployment_id;
770:
771:
772: BEGIN

Line 977: -- ies_svy_deplyments_all and populate the ies_svy_list_entries with the survey sent date else

973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -- if p_reminder_type is null then its from the deploy button so update
977: -- ies_svy_deplyments_all and populate the ies_svy_list_entries with the survey sent date else
978: -- a record should be inserted in ies_svy_reminder_hst
979:
980: IF(p_reminder_type is null) THEN
981: -- Set Deployment Status to be Active

Line 1140: l_list_header_id IES_SVY_DEPLYMENTS_ALL.LIST_HEADER_ID%TYPE ;

1136: l_return_status VARCHAR2(1000) ;
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' ;

Line 1192: FROM IES_SVY_DEPLYMENTS_ALL

1188: END IF;
1189:
1190: BEGIN
1191: SELECT LIST_HEADER_ID INTO l_list_header_id
1192: FROM IES_SVY_DEPLYMENTS_ALL
1193: WHERE SURVEY_DEPLOYMENT_ID = p_survey_deployment_id;
1194:
1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN