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