98: end if;
99:
100: END LOOP ;
101:
102: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
103: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
104: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
105:
106: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
99:
100: END LOOP ;
101:
102: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
103: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
104: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
105:
106: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
100: END LOOP ;
101:
102: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
103: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
104: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
105:
106: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
104: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
105:
106: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
188: end if;
189:
190: END LOOP ;
191:
192: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
193: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
194: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
195:
196: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
189:
190: END LOOP ;
191:
192: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
193: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
194: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
195:
196: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
190: END LOOP ;
191:
192: X_segment1 := 'Total Assignments Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
193: X_segment2 := 'Total Assignments With Error :'||to_char(ln_error)||l_space||wf_core.newline;
194: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
195:
196: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
194: X_segment3 := 'Total Assignments Not Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
195:
196: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'