DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on AME_UTIL

Line 523: l_doc_ids ame_util.idList;

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

Line 622: l_nextApprovers ame_util.approversTable2;

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

Line 630: l_itemIndexesOut ame_util.idList;

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;

Line 631: l_itemClassesOut ame_util.stringList;

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;

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

Line 633: l_itemSourcesOut ame_util.longStringList;

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;

Line 634: l_productionIndexesOut ame_util.idList;

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;

Line 635: l_variableNamesOut ame_util.stringList;

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;

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