1079: fetch wf_notifs
1080: into l_notif_id;
1081: exit when wf_notifs%NOTFOUND;
1082:
1083: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1080: into l_notif_id;
1081: exit when wf_notifs%NOTFOUND;
1082:
1083: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1088: wf_notification.denormalize_notification(l_notif_id);
1081: exit when wf_notifs%NOTFOUND;
1082:
1083: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1088: wf_notification.denormalize_notification(l_notif_id);
1089:
1082:
1083: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1088: wf_notification.denormalize_notification(l_notif_id);
1089:
1090: end loop;
1083: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1088: wf_notification.denormalize_notification(l_notif_id);
1089:
1090: end loop;
1091: close wf_notifs;
1084: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1085: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1086: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1087: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1088: wf_notification.denormalize_notification(l_notif_id);
1089:
1090: end loop;
1091: close wf_notifs;
1092:
1138: fetch wf_notifs
1139: into l_notif_id;
1140: exit when wf_notifs%NOTFOUND;
1141:
1142: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1139: into l_notif_id;
1140: exit when wf_notifs%NOTFOUND;
1141:
1142: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1147: wf_notification.denormalize_notification(l_notif_id);
1140: exit when wf_notifs%NOTFOUND;
1141:
1142: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1147: wf_notification.denormalize_notification(l_notif_id);
1148: end loop;
1141:
1142: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1147: wf_notification.denormalize_notification(l_notif_id);
1148: end loop;
1149: close wf_notifs;
1142: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1147: wf_notification.denormalize_notification(l_notif_id);
1148: end loop;
1149: close wf_notifs;
1150:
1143: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1144: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1145: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1146: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1147: wf_notification.denormalize_notification(l_notif_id);
1148: end loop;
1149: close wf_notifs;
1150:
1151: l_progress := '007';
3277: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3278: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Cancelling Nid = ' || c1_rec.notification_id);
3279: END IF;
3280:
3281: wf_notification.cancel (c1_rec.notification_id, NULL);
3282:
3283: end LOOP;
3284:
3285: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN