APPS.IES_SVY_DPYLMENT_STATUS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

Procedure  Update_Deployment_Status
(
    ERRBUF				 OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
    RETCODE 				 OUT NOCOPY /* file.sql.39 change */ BINARY_INTEGER
) IS
  l_error_msg         	   VARCHAR2(2000);

Line: 27

  SELECT survey_deployment_id, isdv.survey_cycle_id , survey_id
  FROM ies_svy_deplyments_v isdv, ies_svy_cycles_v iscv
  WHERE response_end_date < sysdate
  and deployment_status_code = 'ACTIVE'
  and isdv.survey_cycle_id = iscv.survey_cycle_id
  FOR UPDATE of deployment_status_code;

Line: 35

	SAVEPOINT update_deployment_status;

Line: 38

		update ies_svy_deplyments_v
		set deployment_status_code = 'CLOSED'
		where survey_deployment_id = c1_rec.survey_deployment_id;

Line: 42

		SELECT count(*)
		INTO   l_dep_count
		FROM   ies_svy_deplyments_v
		WHERE  survey_cycle_id = c1_rec.survey_cycle_id
		AND    deployment_status_code = 'ACTIVE';

Line: 49

			UPDATE ies_svy_cycles_v
			SET cycle_status_code = 'OPEN'
			WHERE survey_cycle_id = c1_rec.survey_cycle_id;

Line: 54

		select count(*)
		INTO l_cycle_count
		FROM ies_svy_cycles_v
		WHERE survey_id = c1_rec.survey_id
		AND cycle_status_code = 'ACTIVE';

Line: 61

			UPDATE ies_svy_surveys_v
			SET survey_status_code = 'OPEN'
			WHERE survey_id = c1_rec.survey_id;

Line: 70

			FND_MESSAGE.SET_NAME('IES', 'IES_SVY_UPDATE_DEPLOY_STATUS');

Line: 75

			rollback to update_deployment_status;

Line: 76

end Update_Deployment_Status;