APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_ENTRS_REMIND_HST

Line 562: --get the survey_list_entry_id to be inserted into ies_svy_entrs_remind_hst

558: x_message := FND_MESSAGE.Get();
559: x_message := x_message || TO_CHAR(l_request_id);
560:
561:
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

Line 571: INSERT into ies_svy_entrs_remind_hst

567: WHERE list_entry_id = p_list_entry_id
568: AND survey_deployment_id = p_deployment_id;
569:
570:
571: INSERT into ies_svy_entrs_remind_hst
572: (entry_reminder_hst_id
573: ,object_version_number
574: ,created_by
575: ,creation_date

Line 584: (ies_svy_entrs_remind_hst_s.nextval

580: ,reminder_date
581: ,concurrent_req_id
582: ,fulfillment_req_id)
583: VALUES
584: (ies_svy_entrs_remind_hst_s.nextval
585: ,1
586: ,l_user_id
587: ,sysdate
588: ,l_user_id

Line 596: x_message := x_message || ' ,Entry inserted in ies_svy_entrs_remind_hst';

592: ,sysdate
593: ,null
594: ,l_request_id);
595:
596: x_message := x_message || ' ,Entry inserted in ies_svy_entrs_remind_hst';
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO FM_Request_From_Survey;
600: x_return_status := FND_API.G_RET_STS_ERROR ;