55: l_deployment_id NUMBER := NULL;
56:
57: cursor cdepid is
58: select survey_deployment_id
59: from ies_svy_summary_stats_v
60: where survey_deployment_id = p_deployment_id;
61:
62: Begin
63:
122: open cdepid;
123: fetch cdepid into l_deployment_id;
124: if(cdepid%NOTFOUND)then
125: close cdepid;
126: insert into ies_svy_summary_stats_v
127: (survey_id,
128: survey_cycle_id,
129: survey_deployment_id,
130: survey_deployment_name,
168: sysdate,
169: null);
170:
171: else
172: update ies_svy_summary_stats_v
173: set total_no_sent = nvl(l_total_no_sent,0) ,
174: total_no_errors = nvl(l_total_no_errors,0),
175: total_no_responses_recd = nvl(l_total_no_responses_recd,0),
176: total_abandoned = nvl(l_total_no_abandoned,0),
208: l_deployment_id NUMBER := NULL;
209:
210: cursor cdepid is
211: select survey_deployment_id
212: from ies_svy_summary_stats_v
213: where survey_deployment_id = p_deployment_id;
214:
215: Begin
216: select iscv.survey_cycle_id,
255: open cdepid;
256: fetch cdepid into l_deployment_id;
257: if(cdepid%NOTFOUND)then
258: close cdepid;
259: insert into ies_svy_summary_stats_v
260: (survey_id,
261: survey_cycle_id,
262: survey_deployment_id,
263: survey_deployment_name,
295: sysdate,
296: null);
297:
298: else
299: update ies_svy_summary_stats_v
300: set total_no_sent = nvl(l_total_no_sent,0) ,
301: total_no_errors = nvl(l_total_no_errors,0),
302: total_no_responses_recd = nvl(l_total_no_responses_recd,0),
303: total_abandoned = nvl(l_total_no_abandoned,0),