103: p_resultout OUT NOCOPY VARCHAR2)
104:
105: IS
106:
107: l_approverList ame_util.approversTable;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
104:
105: IS
106:
107: l_approverList ame_util.approversTable;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
105: IS
106:
107: l_approverList ame_util.approversTable;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
106:
107: l_approverList ame_util.approversTable;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
107: l_approverList ame_util.approversTable;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
108: l_approverList2 ame_util.approversTable2;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
109: l_ruleids ame_util.idList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
117: sourceTypes ame_util.stringList;
110: l_rulenames ame_util.stringList;
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
117: sourceTypes ame_util.stringList;
118:
111: approvalProcessCompleteYN ame_util.charType;
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
117: sourceTypes ame_util.stringList;
118:
119: l_process_complete VARCHAR2(100);
112: itemClasses ame_util.stringList;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
117: sourceTypes ame_util.stringList;
118:
119: l_process_complete VARCHAR2(100);
120: l_count NUMBER := 0;
113: itemIndexes ame_util.idList;
114: itemIds ame_util.stringList;
115: itemSources ame_util.longStringList;
116: ruleIndexes ame_util.idList;
117: sourceTypes ame_util.stringList;
118:
119: l_process_complete VARCHAR2(100);
120: l_count NUMBER := 0;
121: l_notif_id NUMBER;