1052: fetch wf_notifs
1053: into l_notif_id;
1054: exit when wf_notifs%NOTFOUND;
1055:
1056: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1053: into l_notif_id;
1054: exit when wf_notifs%NOTFOUND;
1055:
1056: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1061: wf_notification.denormalize_notification(l_notif_id);
1054: exit when wf_notifs%NOTFOUND;
1055:
1056: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1061: wf_notification.denormalize_notification(l_notif_id);
1062:
1055:
1056: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1061: wf_notification.denormalize_notification(l_notif_id);
1062:
1063: end loop;
1056: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1061: wf_notification.denormalize_notification(l_notif_id);
1062:
1063: end loop;
1064: close wf_notifs;
1057: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1058: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1059: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1060: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1061: wf_notification.denormalize_notification(l_notif_id);
1062:
1063: end loop;
1064: close wf_notifs;
1065:
1111: fetch wf_notifs
1112: into l_notif_id;
1113: exit when wf_notifs%NOTFOUND;
1114:
1115: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1112: into l_notif_id;
1113: exit when wf_notifs%NOTFOUND;
1114:
1115: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1120: wf_notification.denormalize_notification(l_notif_id);
1113: exit when wf_notifs%NOTFOUND;
1114:
1115: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1120: wf_notification.denormalize_notification(l_notif_id);
1121: end loop;
1114:
1115: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1120: wf_notification.denormalize_notification(l_notif_id);
1121: end loop;
1122: close wf_notifs;
1115: wf_notification.setattrtext(l_notif_id, '#HDR_1', l_description);
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1120: wf_notification.denormalize_notification(l_notif_id);
1121: end loop;
1122: close wf_notifs;
1123:
1116: wf_notification.setattrtext(l_notif_id, '#HDR_2', l_req_total);
1117: wf_notification.setattrtext(l_notif_id, '#HDR_3', l_estimated_tax);
1118: wf_notification.setattrtext(l_notif_id, '#HDR_4', l_justification);
1119: wf_notification.setattrtext(l_notif_id, 'TOTAL_AMOUNT_DSP', l_total_amount_dsp);
1120: wf_notification.denormalize_notification(l_notif_id);
1121: end loop;
1122: close wf_notifs;
1123:
1124: l_progress := '007';
2908: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2909: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Cancelling Nid = ' || c1_rec.notification_id);
2910: END IF;
2911:
2912: wf_notification.cancel (c1_rec.notification_id, NULL);
2913:
2914: end LOOP;
2915:
2916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN