519: --+
520: procedure attachDocument(p_notificationIdIn in number,p_personIdIn in varchar2
521: ,p_eventName in varchar2,p_itemKey in varchar2
522: ,p_roleType in varchar2) is
523: l_doc_ids ame_util.idList;
524: l_proc varchar2(50);
525: l_person_id number;
526: l_count number;
527: l_doc_type varchar2(40);
618: , p_activityId in number
619: , funmode in varchar2
620: , result out nocopy varchar2 ) is
621: l_ameTransactionType varchar2(50);
622: l_nextApprovers ame_util.approversTable2;
623: l_approvalProcessCompleteYNOut varchar2(1);
624: l_notificationId number;
625: l_messageSubjectName varchar2(30);
626: l_messageSubject varchar2(5000);
626: l_messageSubject varchar2(5000);
627: l_htmlMessageName varchar2(30);
628: l_htmlMessageBody varchar2(30000);
629: l_eventName varchar2(50);
630: l_itemIndexesOut ame_util.idList;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
627: l_htmlMessageName varchar2(30);
628: l_htmlMessageBody varchar2(30000);
629: l_eventName varchar2(50);
630: l_itemIndexesOut ame_util.idList;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
628: l_htmlMessageBody varchar2(30000);
629: l_eventName varchar2(50);
630: l_itemIndexesOut ame_util.idList;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
636: l_variableValuesOut ame_util.stringList;
629: l_eventName varchar2(50);
630: l_itemIndexesOut ame_util.idList;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
636: l_variableValuesOut ame_util.stringList;
637: l_actionPerformerId number;
630: l_itemIndexesOut ame_util.idList;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
636: l_variableValuesOut ame_util.stringList;
637: l_actionPerformerId number;
638: e_ameException exception;
631: l_itemClassesOut ame_util.stringList;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
636: l_variableValuesOut ame_util.stringList;
637: l_actionPerformerId number;
638: e_ameException exception;
639: e_messageNameIsNull exception;
632: l_itemIdsOut ame_util.stringList;
633: l_itemSourcesOut ame_util.longStringList;
634: l_productionIndexesOut ame_util.idList;
635: l_variableNamesOut ame_util.stringList;
636: l_variableValuesOut ame_util.stringList;
637: l_actionPerformerId number;
638: e_ameException exception;
639: e_messageNameIsNull exception;
640: l_approverRole varchar2(50);