1 package ame_approval_group_pkg AUTHID CURRENT_USER as
2 /* $Header: ameogrou.pkh 120.1 2006/08/04 15:34:26 pvelugul noship $ */
3 function getApprovalGroupItemMaxOrdNum(approvalGroupIdIn in integer) return integer;
4 function getApprovalGroupMaxOrderNumber(applicationIdIn in integer) return integer;
5 function getApprovalGroupOrderNumber(applicationIdIn in integer,
6 approvalGroupIdIn in integer) return integer;
7 function getChildVersionStartDate(approvalGroupIdIn integer,
8 applicationIdIn in integer) return varchar2;
9 function getDescription(approvalGroupIdIn in integer) return varchar2;
10 function getId(nameIn in varchar2) return integer;
11 function getItemApprovalGroupId(approvalGroupItemIdIn in integer) return integer;
12 function getItemId(approvalGroupIdIn in integer,
13 parameterIn in varchar2,
14 parameterNameIn in varchar2) return integer;
15 function getItemParameter(approvalGroupItemIdIn in integer) return varchar2;
16 function getItemParameterName(approvalGroupItemIdIn in integer) return varchar2;
17 function getName(approvalGroupIdIn in integer,
18 effectiveDateIn in date default sysdate) return varchar2;
19 function getParentVersionStartDate(approvalGroupIdIn integer) return varchar2;
20 function getOrderNumberCount(approvalGroupIdIn in integer,
21 newGroupMemberIn in boolean) return integer;
22 function getQueryString(approvalGroupIdIn in integer,
23 effectiveDateIn in date default sysdate) return varchar2;
24 function getIsStatic(approvalGroupIdIn in integer) return varchar2;
25 function getItemOrderNumber(approvalGroupItemIdIn in integer) return integer;
26 function getVotingRegime(approvalGroupIdIn in integer,
27 applicationIdIn in integer) return varchar2;
28 function groupIsInGroup(groupIdIn in integer,
29 possiblyNestedGroupIdIn in integer) return boolean;
30
31 function hasGroupChanged2(approvalGroupIdIn in integer,
32 nameIn in varchar2 default null,
33 descriptionIn in varchar2 default null,
34 isStaticIn in varchar2 default null,
35 queryStringIn in varchar2 default null) return boolean;
36
37 function hasGroupChanged(approvalGroupIdIn in integer,
38 nameIn in varchar2 default null,
39 descriptionIn in varchar2 default null,
40 isStaticIn in varchar2 default null,
41 queryStringIn in varchar2 default null,
42 orderNumberIn in integer,
43 orderNumberUniqueIn in varchar2,
44 votingRegimeIn in varchar2,
45 applicationIdIn in integer) return boolean;
46 function isInUse(approvalGroupIdIn in integer) return boolean;
47 function isSeeded(approvalGroupIdIn in integer) return boolean;
48
49 function isStatic(approvalGroupIdIn in integer,
50 effectiveDateIn in date default sysdate) return boolean;
51 function itemOrderNumberUnique(approvalGroupIdIn in integer,
52 orderNumberIn in integer) return boolean;
53 function new(nameIn in varchar2,
54 descriptionIn in varchar2,
55 isStaticIn in varchar2 default null,
56 queryStringIn in varchar2 default null,
57 newStartDateIn in date default null,
58 approvalGroupIdIn in integer default null,
59 finalizeIn in boolean default false,
60 updateActionIn in boolean default false) return integer;
61 function newApprovalGroupItem(approvalGroupIdIn in integer,
62 parameterIn in varchar2,
63 parameterNameIn in varchar2,
64 approvalGroupItemIdIn in integer default null,
65 newOrderNumberIn in integer default null,
66 orderNumberUniqueIn in varchar2 default null,
67 oldOrderNumberIn in integer default null,
68 finalizeIn in boolean default false,
69 newStartDateIn in date default null,
70 newEndDateIn in date default null,
71 parentVersionStartDateIn in date) return integer;
72 function orderNumberUnique(applicationIdIn in integer,
73 orderNumberIn in integer) return boolean;
74 procedure change(approvalGroupIdIn in integer,
75 nameIn in varchar2 default null,
76 descriptionIn in varchar2 default null,
77 isStaticIn in varchar2 default null,
78 queryStringIn in varchar2 default null,
79 updateActionIn in boolean,
80 newVersionStartDateIn in date,
81 finalizeIn in boolean default false);
82 procedure changeGroupAndConfig(approvalGroupIdIn in integer,
83 nameIn in varchar2 default null,
84 descriptionIn in varchar2 default null,
85 isStaticIn in varchar2 default null,
86 queryStringIn in varchar2 default null,
87 newVersionStartDateIn in date,
88 parentVersionStartDateIn in date,
89 childVersionStartDateIn in date,
90 orderNumberUniqueIn in varchar2,
91 orderNumberIn in integer,
92 votingRegimeIn in varchar2,
93 applicationIdIn in integer,
94 finalizeIn in boolean default false);
95 procedure changeGroupConfig(applicationIdIn in integer,
96 approvalGroupIdIn in integer,
97 orderNumberUniqueIn in varchar2,
98 orderNumberIn in integer,
99 votingRegimeIn in varchar2,
100 newVersionStartDateIn in date,
101 finalizeIn in boolean default false);
102 procedure changeApprovalGroupItem(approvalGroupIdIn in integer,
103 itemIdIn in integer,
104 parameterIn in varchar2 default null,
105 parameterNameIn in varchar2,
106 newOrderNumberIn in integer,
107 orderNumberUniqueIn in varchar2 default null,
108 parentVersionStartDateIn in date);
109 procedure decrementGroupItemOrderNumbers(approvalGroupIdIn in integer,
110 orderNumberIn in integer,
111 finalizeIn in boolean default false);
112 procedure decrementGroupOrderNumbers(applicationIdIn in integer,
113 orderNumberIn in integer,
114 finalizeIn in boolean default false);
115 procedure getAllowedNestedGroups(groupIdIn in integer,
116 allowedNestedGroupIdsOut out nocopy ame_util.stringList,
117 allowedNestedGroupNamesOut out nocopy ame_util.stringList);
118 procedure getApprovalGroupItemList(approvalGroupIdIn in integer,
119 itemListOut out nocopy ame_util.idList,
120 orderListOut out nocopy ame_util.idList,
121 descriptionListOut out nocopy ame_util.longStringList,
122 invalidMembersOut out nocopy boolean);
123 procedure getApprovalGroupList(groupListOut out nocopy ame_util.idList);
124 procedure getApprovalGroupList2(applicationIdIn in integer,
125 groupListOut out nocopy ame_util.idList);
126 /*
127 getGroupMembers returns the person and user IDs of approvers already in a group,
128 and the approver type of each ID. This list includes members of nested groups.
129 Only static members of groups using their static lists are included.
130 */
131 procedure getGroupMembers(approvalGroupIdIn in integer,
132 memberIdsOut out nocopy ame_util.longStringList,
133 memberTypesOut out nocopy ame_util.stringList);
134 procedure getInvalidApprGroupItemList(approvalGroupIdIn in integer,
135 itemListOut out nocopy ame_util.idList);
136 /*
137 procedure getOrderNumbers(approvalGroupIdIn in integer,
138 orderNumbersOut out nocopy ame_util.stringList);
139 */
140 /* Only ame_engine.getRuntimeGroupMembers should call ame_approval_group_pkg.getRuntimeGroupMembers. */
141
142 procedure incrementGroupItemOrderNumbers(approvalGroupIdIn in integer,
143 approvalGroupItemIdIn in integer,
144 orderNumberIn in integer,
145 finalizeIn in boolean default false);
146 procedure incrementGroupOrderNumbers(applicationIdIn in integer,
147 approvalGroupIdIn in integer,
148 orderNumberIn in integer,
149 finalizeIn in boolean default false);
150 procedure newApprovalGroupConfig(approvalGroupIdIn in integer,
151 applicationIdIn in integer default null,
152 orderNumberIn in integer default null,
153 orderNumberUniqueIn in varchar2 default ame_util.yes,
154 votingRegimeIn in varchar2 default ame_util.serializedVoting,
155 finalizeIn in boolean default false);
156 procedure remove(approvalGroupIdIn in integer,
157 parentVersionStartDateIn in date);
158 procedure removeApprovalGroupItem(approvalGroupIdIn in integer,
159 approvalGroupItemsIn in ame_util.idList,
160 parentVersionStartDateIn in date);
161 /*
162 setGroupMembers2 updates ame_approval_group_members for the group with ID groupIdIn.
163 If endDateIn is not null, setGroupMembers2 uses the ame_approval_group_items entries
164 with end_date = endDateIn. (This enables a bug fix in amem0015.sql.)
165 If the raiseError parameter is true, then this procedure raises an error
166 when ever a member is not active in wf_roles.
167 */
168 procedure setGroupMembers2(groupIdIn in integer,
169 effectiveDateIn in date default sysdate,
170 raiseError in boolean);
171 procedure setGroupMembers(groupIdIn in integer,
172 effectiveDateIn in date default sysdate);
173 end ame_approval_group_pkg;