DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on AME_UTIL

Line 338: l_doc_ids ame_util.idList;

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);

Line 430: l_nextApprovers ame_util.approversTable2;

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);

Line 438: l_itemIndexesOut ame_util.idList;

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;

Line 439: l_itemClassesOut ame_util.stringList;

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;

Line 440: l_itemIdsOut 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;

Line 441: l_itemSourcesOut ame_util.longStringList;

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;

Line 442: l_productionIndexesOut ame_util.idList;

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;

Line 443: l_variableNamesOut ame_util.stringList;

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;

Line 444: l_variableValuesOut 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;
448: l_approverRole varchar2(50);