1 package ame_approver_type_pkg as
2 /* $Header: ameoatyp.pkh 120.1.12000000.1 2007/01/17 23:58:57 appldev noship $ */
3 function getApproverDescription(nameIn in varchar2) return varchar2;
4 function getApproverDescription2
5 (origSystemIn in varchar2
6 ,origSystemIdIn in integer
7 ,raiseNoDataFoundIn in varchar2 default 'true') return varchar2;
8 function getApproverDisplayName(nameIn in varchar2) return varchar2;
9 function getApproverDisplayName2(origSystemIn in varchar2,
10 origSystemIdIn in integer) return varchar2;
11 function getApproverDisplayName3(nameIn in varchar2) return varchar2;
12 function getApproverDisplayName4(nameIn in varchar2) return varchar2;
13 function getApproverOrigSystem(nameIn in varchar2) return varchar2;
14 function getApproverOrigSystem2(nameIn in varchar2) return varchar2;
15 function getApproverOrigSystemId(nameIn in varchar2) return varchar2;
16 function getApproverTypeId(origSystemIn in varchar2) return integer;
17 function getApproverTypeOrigSystem(approverTypeIdIn in integer) return varchar2;
18 function getApproverTypeDisplayName(approverTypeIdIn in integer) return varchar2;
19 function getOrigSystemDisplayName(origSystemIn in varchar2) return varchar2;
20 function getQueryProcedure(approverTypeIdIn in integer) return varchar2;
21 function getWfRolesName
22 (origSystemIn in varchar2
23 ,origSystemIdIn in integer
24 ,raiseNoDataFoundIn in varchar2 default 'true') return varchar2;
25 function allowsAllApproverTypes(actionTypeIdIn in integer) return boolean;
26 function isASubordinate(approverIn in ame_util.approverRecord2,
27 possibleSubordApproverIn in ame_util.approverRecord2) return boolean;
28 function validateApprover(nameIn in varchar2) return boolean;
29 procedure fndUsrApproverQuery(criteria1In in varchar2 default null,
30 criteria2In in varchar2 default null,
31 criteria3In in varchar2 default null,
32 criteria4In in varchar2 default null,
33 criteria5In in varchar2 default null,
34 excludeListCountIn in integer,
35 approverNamesOut out nocopy varchar2,
36 approverDescriptionsOut out nocopy varchar2);
37 procedure fndRespApproverQuery(criteria1In in varchar2 default null,
38 criteria2In in varchar2 default null,
39 criteria3In in varchar2 default null,
40 criteria4In in varchar2 default null,
41 criteria5In in varchar2 default null,
42 excludeListCountIn in integer,
43 approverNamesOut out nocopy varchar2,
44 approverDescriptionsOut out nocopy varchar2);
45 procedure getApproverDescAndValidity(nameIn in varchar2,
46 descriptionOut out nocopy varchar2,
47 validityOut out nocopy boolean);
48 procedure getApproverOrigSystemAndId(nameIn in varchar2,
49 origSystemOut out nocopy varchar2,
50 origSystemIdOut out nocopy integer);
51 procedure getApprovalTypes(approverTypeIdIn in integer,
52 actionTypeNamesOut out nocopy ame_util.stringList);
53 procedure getApproverTypeQueryData(approverTypeIdIn in integer,
54 queryVariableLabelsOut out nocopy ame_util.longStringList,
55 variableLovQueriesOut out nocopy ame_util.longStringList);
56 procedure getAvailableApproverTypes(applicationIdIn in integer default null,
57 topLabelIn in varchar2 default null,
58 topValueIn in varchar2 default null,
59 approverTypeIdsOut out nocopy ame_util.stringList,
60 approverTypeNamesOut out nocopy ame_util.stringList);
61 procedure getAvailableApproverTypes2(actionTypeIdIn in integer,
62 approverTypeIdsOut out nocopy ame_util.stringList,
63 approverTypeNamesOut out nocopy ame_util.stringList);
64 procedure getAvailableApproverTypes3(actionTypeIdIn in integer,
65 approverTypeIdsOut out nocopy ame_util.idList);
66 procedure getOrigSystemIdAndDisplayName(nameIn in varchar2,
67 origSystemOut out nocopy varchar2,
68 origSystemIdOut out nocopy integer,
69 displayNameOut out nocopy varchar2);
70 procedure getSuperior(approverIn in ame_util.approverRecord2,
71 superiorOut out nocopy ame_util.approverRecord2);
72 procedure getSurrogate(origSystemIn in varchar2,
73 origSystemIdIn in integer,
74 origSystemIdOut out nocopy integer,
75 wfRolesNameOut out nocopy varchar2,
76 displayNameOut out nocopy varchar2);
77 procedure getWfRolesNameAndDisplayName(origSystemIn in varchar2,
78 origSystemIdIn in integer,
79 nameOut out nocopy ame_util.longStringType,
80 displayNameOut out nocopy ame_util.longStringType);
81 procedure perApproverQuery(criteria1In in varchar2 default null,
82 criteria2In in varchar2 default null,
83 criteria3In in varchar2 default null,
84 criteria4In in varchar2 default null,
85 criteria5In in varchar2 default null,
86 excludeListCountIn in integer,
87 approverNamesOut out nocopy varchar2,
88 approverDescriptionsOut out nocopy varchar2);
89 procedure posApproverQuery(criteria1In in varchar2 default null,
90 criteria2In in varchar2 default null,
91 criteria3In in varchar2 default null,
92 criteria4In in varchar2 default null,
93 criteria5In in varchar2 default null,
94 excludeListCountIn in integer,
95 approverNamesOut out nocopy varchar2,
96 approverDescriptionsOut out nocopy varchar2);
97 procedure processApproverQuery(selectClauseIn in varchar2,
98 approverNamesOut out nocopy ame_util.longStringList,
99 approverDisplayNamesOut out nocopy ame_util.longStringList);
100 procedure processApproverQuery2(selectClauseIn in varchar2,
101 approverNamesOut out nocopy ame_util.longStringList);
102 procedure newApproverTypeUsage(actionTypeIdIn in integer,
103 approverTypeIdIn in integer,
104 processingDateIn in date);
105 procedure newApproverTypeUsages(actionTypeIdIn in integer,
106 approverTypeIdsIn in ame_util.idList,
107 finalizeIn in boolean default false,
108 processingDateIn in date default null);
109 procedure removeApproverTypeUsage(actionTypeIdIn in integer,
110 approverTypeIdIn in integer,
111 processingDateIn in date default null);
112 procedure removeApproverTypeUsages(actionTypeIdIn in integer,
113 approverTypeIdsIn in ame_util.idList default ame_util.emptyIdList,
114 finalizeIn in boolean default false,
115 processingDateIn in date default null);
116 end ame_approver_type_pkg;
[Home] [Help]