1 package ame_action_pkg as
2 /* $Header: ameoacti.pkh 120.0 2005/07/26 06:04:11 mbocutt noship $ */
3 function actionTypeIsInUse(actionTypeIdIn in integer) return boolean;
4 function getActionTypeDescQuery(actionTypeIdIn in integer) return varchar2;
5 function getActionTypeDynamicDesc(actionTypeIdIn in integer) return varchar2;
6 function getActionTypeIdById(actionIdIn in integer) return integer;
7 function getActionTypeIdByName(actionTypeNameIn in varchar2) return integer;
8 function getActionTypeDescription(actionTypeIdIn in integer) return varchar2;
9 function getActionTypeMaxOrderNumber(applicationIdIn in integer,
10 ruleTypeIn in integer) return integer;
11 function getActionTypeName(actionTypeIdIn in integer) return varchar2;
12 function getActionTypeNameByActionId(actionIdIn in integer) return varchar2;
13 function getActionTypeOrderNumber(applicationIdIn in integer,
14 actionTypeIdIn in integer) return integer;
15 function getActionTypeProcedureName(actionTypeIdIn in integer) return varchar2;
16 function getActionTypeCreatedBy(actionTypeIdIn in integer) return integer;
17 function getAllowedRuleType(actionTypeIdIn in integer) return integer;
18 function getAllowedRuleTypeLabel(ruleTypeIn in integer) return varchar2;
19 function getChainOrderingMode(actionTypeIdIn in integer,
20 applicationIdIn in integer) return varchar2;
21 function getChildVersionStartDate(actionIdIn in integer) return varchar2;
22 function getChildVersionStartDate2(actionTypeIdIn in integer,
23 applicationIdIn in integer) return varchar2;
24 function getDescription(actionIdIn in integer) return varchar2;
25 function getDescription2(actionIdIn in integer) return varchar2;
26 function getDynamicActionDesc(actionIdIn in integer) return varchar2;
27 function getGroupChainActionTypeId return integer;
28 function getId(actionTypeIdIn in integer,
29 parameterIn in varchar2 default null) return integer;
30 function getParameter(actionIdIn in integer) return varchar2;
31 function getParameter2(actionIdIn in integer) return varchar2;
32 function getParentVersionStartDate(actionTypeIdIn in integer) return varchar2;
33 function getPostApprovalActionTypeId return integer;
34 function getPreApprovalActionTypeId return integer;
35 function getVotingRegime(actionTypeIdIn in integer,
36 applicationIdIn in integer) return varchar2;
37 function isInUse(actionIdIn in integer) return boolean;
38 function isListCreationRuleType(actionTypeIdIn in integer) return boolean;
39 function isSeeded(actionTypeIdIn in integer) return boolean;
40 function new(nameIn in varchar2,
41 procedureNameIn in varchar2,
42 dynamicDescriptionIn in varchar2,
43 descriptionIn in varchar2 default null,
44 descriptionQueryIn in varchar2 default null,
45 actionTypeIdIn in integer default null,
46 finalizeIn in boolean default false,
47 newStartDateIn in date default null,
48 processingDateIn in date default null) return integer;
49 function newAction(actionTypeIdIn in integer,
50 updateParentObjectIn in boolean,
51 descriptionIn in varchar2 default null,
52 parameterIn in varchar2 default null,
53 parameterTwoIn in varchar2 default null,
54 newStartDateIn in date default null,
55 finalizeIn in boolean default false,
56 parentVersionStartDateIn in date default null,
57 actionIdIn in integer default null,
58 processingDateIn in date default null) return integer;
59 function orderNumberUnique(applicationIdIn in integer,
60 orderNumberIn in integer,
61 actionTypeIdIn in integer) return boolean;
62 function requiredAttOnApprovalTypeList(actionTypeIdIn in integer,
63 attributeIdIn in integer) return boolean;
64 procedure change(actionTypeIdIn in integer,
65 ruleTypeIn in varchar2,
66 processingDateIn in date,
67 descriptionQueryIn in varchar2 default null,
68 nameIn in varchar2 default null,
69 procedureNameIn in varchar2 default null,
70 descriptionIn in varchar2 default null,
71 deleteListIn in ame_util.stringList default ame_util.emptyStringList,
72 finalizeIn in boolean default false);
73 procedure changeActionTypeAndConfig(actionTypeIdIn in integer,
74 ruleTypeIn in varchar2,
75 orderNumberIn in integer,
76 orderNumberUniqueIn in varchar2,
77 childVersionStartDate2In in date,
78 parentVersionStartDateIn in date,
79 applicationIdIn in integer,
80 descriptionQueryIn in varchar2 default null,
81 chainOrderIngModeIn in varchar2 default null,
82 votingRegimeIn in varchar2 default null,
83 nameIn in varchar2 default null,
84 procedureNameIn in varchar2 default null,
85 descriptionIn in varchar2 default null,
86 deleteListIn in ame_util.stringList default ame_util.emptyStringList,
87 finalizeIn in boolean default false);
88 procedure changeActionTypeConfig(applicationIdIn in integer,
89 actionTypeIdIn in integer,
90 orderNumberIn in integer,
91 orderNumberUniqueIn in varchar2,
92 processingDateIn in date,
93 votingRegimeIn in varchar2 default null,
94 chainOrderingModeIn in varchar2 default null,
95 finalizeIn in boolean default false);
96 procedure changeAction(actionIdIn in integer,
97 actionTypeIdIn in integer default null,
98 descriptionIn in varchar2 default null,
99 parameterIn in varchar2 default null,
100 parameterTwoIn in varchar2 default null,
101 finalizeIn in boolean default false,
102 childVersionStartDateIn in date,
103 parentVersionStartDateIn in date,
104 processingDateIn in date default null);
105 procedure decrementActionTypeOrdNumbers(applicationIdIn in integer,
106 actionTypeIdIn in integer,
107 orderNumberIn in integer,
108 finalizeIn in boolean default false);
109 procedure getActions(actionTypeIdIn in integer,
110 actionsOut out nocopy ame_util.idStringTable);
111 procedure getActions2(actionTypeIdIn in integer,
112 actionIdsOut out nocopy ame_util.stringList,
113 actionDescriptionsOut out nocopy ame_util.longStringList);
114 procedure getActions3(actionTypeIdIn in integer,
115 dynamicDescriptionIn in varchar2,
116 actionTypeNamesOut out nocopy ame_util.stringList,
117 actionIdsOut out nocopy ame_util.idList,
118 actionParametersOut out nocopy ame_util.stringList,
119 actionDescriptionsOut out nocopy ame_util.stringList,
120 actionCreatedByOut out nocopy ame_util.idList);
121 procedure getActions4(actionTypeIdIn in integer,
122 actionIdsOut out nocopy ame_util.stringList,
123 actionDescriptionsOut out nocopy ame_util.stringList);
124 procedure getActionTypes(actionTypesOut out nocopy ame_util.idStringTable);
125 procedure getActionTypes2(actionTypeIdsOut out nocopy ame_util.stringList,
126 actionTypeNamesOut out nocopy ame_util.stringList);
127 procedure getActionTypes3(applicationIdIn in integer,
128 actionTypeIdsOut out nocopy ame_util.stringList,
129 actionTypeNamesOut out nocopy ame_util.stringList,
130 actionTypeDescriptionsOut out nocopy ame_util.stringList,
131 ruleTypesOut out nocopy ame_util.idList);
132 procedure getActionTypeDescriptions(actionTypeIdsOut out nocopy ame_util.stringList,
133 actionTypeDescriptionsOut out nocopy ame_util.stringList);
134 procedure getActionTypeUsages(actionTypeIdIn in integer,
135 ruleTypesOut out nocopy ame_util.stringList);
136 procedure getActionTypeUsages2(actionTypeIdsOut out nocopy ame_util.idList,
137 ruleTypesOut out nocopy ame_util.idList);
138 procedure getAllowedApproverTypes(actionTypeIdIn in integer,
139 allowedApproverTypeIdsOut out nocopy ame_util.stringList,
140 allowedApproverTypeNamesOut out nocopy ame_util.stringList);
141 procedure getAllowedRuleTypeLabels(allowedRuleTypesOut out nocopy ame_util.stringList,
142 allowedRuleTypeLabelsOut out nocopy ame_util.stringList);
143 procedure getAvailableActionTypes(applicationIdIn in integer,
144 ruleTypeIn in integer,
145 actionTypeIdsOut out nocopy ame_util.stringList,
146 actionTypeDescriptionsOut out nocopy ame_util.stringList);
147 procedure getAvailCombActionTypes(applicationIdIn in integer,
148 subOrListModActsForCombRuleIn in varchar2,
149 actionTypeIdsOut out nocopy ame_util.stringList,
150 actionTypeDescriptionsOut out nocopy ame_util.stringList);
151 procedure incrementActionTypeOrdNumbers(applicationIdIn in integer,
152 actionTypeIdIn in integer,
153 orderNumberIn in integer,
154 finalizeIn in boolean default false);
155 procedure newActionTypeConfig(applicationIdIn in integer,
156 actionTypeIdIn in integer,
157 ruleTypeIn in integer,
158 orderNumberUniqueIn in varchar2,
159 orderNumberIn in integer,
160 chainOrderingModeIn in varchar2,
161 votingRegimeIn in varchar2,
162 finalizeIn in boolean default false);
163 procedure newActionTypeUsage(actionTypeIdIn in integer,
164 ruleTypeIn in integer,
165 finalizeIn in boolean default false,
166 processingDateIn in date default null);
167 procedure remove(actionTypeIdIn in integer,
168 finalizeIn in boolean default false,
169 parentVersionStartDateIn in date,
170 processingDateIn in date default null);
171 procedure removeAction(actionTypeIdIn in integer,
172 actionIdIn in ame_util.idList default ame_util.emptyIdList,
173 childVersionStartDatesIn in ame_util.dateList,
174 finalizeIn in boolean default false,
175 processingDateIn in date default null);
176 procedure removeActionTypeUsage(actionTypeIdIn in integer,
177 ruleTypeIn in integer,
178 finalizeIn in boolean default false,
179 processingDateIn in date default null);
180 procedure removeActionTypeUsages(actionTypeIdIn in integer,
181 finalizeIn in boolean default false,
182 processingDateIn in date default null);
183 end AME_action_pkg;