APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_LIST_ENTRIES

Line 566: FROM ies_svy_list_entries

562: --get the survey_list_entry_id to be inserted into ies_svy_entrs_remind_hst
563:
564: SELECT survey_list_entry_id
565: INTO l_survey_list_entry_id
566: FROM ies_svy_list_entries
567: WHERE list_entry_id = p_list_entry_id
568: AND survey_deployment_id = p_deployment_id;
569:
570:

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 988: UPDATE ies_svy_list_entries

984: p_reminder_type => p_reminder_type,
985: p_update_flag => 'Y');
986:
987: -- Set Survey Sent Date.
988: UPDATE ies_svy_list_entries
989: SET survey_sent_date = sysdate
990: WHERE survey_deployment_id = p_deployment_id;
991:
992: -- Update FM Request ID

Line 1107: -- PURPOSE Wrapper API to populate IES_SVY_LIST_ENTRIES based on the list_header_id and .

1103:
1104: ----------------------------------------------------------------------------------------------------------
1105: -- Procedure
1106: -- Populate_Survey_List_Entries
1107: -- PURPOSE Wrapper API to populate IES_SVY_LIST_ENTRIES based on the list_header_id and .
1108: -- deployment_id
1109: --
1110: -- PARAMETERS
1111: -- NOTES

Line 1230: FROM IES_SVY_LIST_ENTRIES

1226: dbms_random.initialize (l_seed);
1227:
1228: -- To check if concurrent manager has entered values for particular deployment ID on prior failure.
1229: SELECT count(*) INTO l_count_value
1230: FROM IES_SVY_LIST_ENTRIES
1231: WHERE SURVEY_DEPLOYMENT_ID = p_survey_deployment_id;
1232:
1233: IF l_count_value < 1 THEN
1234: OPEN CLISTENTRYID;

Line 1242: insert into ies_svy_list_entries

1238: l_random_number := ABS(dbms_random.random);
1239: --DBMS_OUTPUT.PUT_LINE('Random no is '||l_random_number);
1240: --DBMS_OUTPUT.PUT_LINE('list_entry_id is '|| ABS(l_list_entry_id));
1241:
1242: insert into ies_svy_list_entries
1243: (
1244: SURVEY_LIST_ENTRY_ID
1245: ,OBJECT_VERSION_NUMBER
1246: ,CREATED_BY

Line 1256: ( ies_svy_list_entries_s.nextval

1252: ,LIST_ENTRY_ID
1253: ,RESPONDENT_ID
1254: )
1255: values
1256: ( ies_svy_list_entries_s.nextval
1257: ,1
1258: ,-1
1259: ,sysdate
1260: ,-1