659:
660: --
661: --curr_len := lengthb(l_document);
662:
663: wf_notification.writetoclob(document, l_document);
664:
665: l_document := NULL;
666:
667: EXIT WHEN i = l_num_records_to_display;
778:
779: --
780: -- curr_len := lengthb(l_document);
781:
782: wf_notification.writetoclob(document, l_document);
783:
784: l_document := NULL;
785:
786: EXIT WHEN i = l_num_records_to_display;
790:
791: end if;
792: l_document := l_document || '
867:
868: -- < BUG 7006113 START >
869: -- curr_len := lengthb(l_document);
870:
871: wf_notification.writetoclob(document, l_document);
872:
873: l_document := NULL;
874:
875: EXIT WHEN i = l_num_records_to_display;
932: --
933: -- curr_len := lengthb(l_document);
934:
935:
936: wf_notification.writetoclob(document, l_document);
937:
938: l_document := NULL;
939:
940: EXIT WHEN i = l_num_records_to_display;
943: end loop;
944:
945: end if;
946:
947: wf_notification.writetoclob(document, l_document); --
949: end if;
950:
951: END get_po_lines_details;
1363:
1364: SELECT fu.USER_ID
1365: INTO l_responder_id
1366: FROM fnd_user fu,
1367: wf_notifications wfn
1368: WHERE wfn.notification_id = l_nid
1369: AND wfn.original_recipient = fu.user_name;
1370:
1371: --