334: --attach document
335: --+
336: procedure attachDocument(p_notificationIdIn in number,p_personIdIn in varchar2
337: ,p_eventName in varchar2,p_itemKey in varchar2) is
338: l_doc_ids ame_util.idList;
339: l_proc varchar2(50);
340: l_person_id number;
341: l_count number;
342: l_doc_type varchar2(40);
426: , p_activityId in number
427: , funmode in varchar2
428: , result out nocopy varchar2 ) is
429: l_ameTransactionType varchar2(50);
430: l_nextApprovers ame_util.approversTable2;
431: l_approvalProcessCompleteYNOut varchar2(1);
432: l_notificationId number;
433: l_messageSubjectName varchar2(30);
434: l_messageSubject varchar2(5000);
434: l_messageSubject varchar2(5000);
435: l_messageBodyName varchar2(30);
436: l_messageBody varchar2(30000);
437: l_eventName varchar2(50);
438: l_itemIndexesOut ame_util.idList;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
435: l_messageBodyName varchar2(30);
436: l_messageBody varchar2(30000);
437: l_eventName varchar2(50);
438: l_itemIndexesOut ame_util.idList;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
436: l_messageBody varchar2(30000);
437: l_eventName varchar2(50);
438: l_itemIndexesOut ame_util.idList;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
444: l_variableValuesOut ame_util.stringList;
437: l_eventName varchar2(50);
438: l_itemIndexesOut ame_util.idList;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
444: l_variableValuesOut ame_util.stringList;
445: l_actionPerformerId number;
438: l_itemIndexesOut ame_util.idList;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
444: l_variableValuesOut ame_util.stringList;
445: l_actionPerformerId number;
446: e_ameException exception;
439: l_itemClassesOut ame_util.stringList;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
444: l_variableValuesOut ame_util.stringList;
445: l_actionPerformerId number;
446: e_ameException exception;
447: e_messageNameIsNull exception;
440: l_itemIdsOut ame_util.stringList;
441: l_itemSourcesOut ame_util.longStringList;
442: l_productionIndexesOut ame_util.idList;
443: l_variableNamesOut ame_util.stringList;
444: l_variableValuesOut ame_util.stringList;
445: l_actionPerformerId number;
446: e_ameException exception;
447: e_messageNameIsNull exception;
448: l_approverRole varchar2(50);