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,
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,
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,
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,
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,
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);
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,
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,
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,
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);
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,
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,
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,
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,
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,
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,
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,
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,
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;