1 package ame_condition_pkg as
2 /* $Header: ameocond.pkh 120.0 2005/07/26 06:04:59 mbocutt noship $*/
3 function getAttributeId(conditionIdIn in integer) return integer;
4 function getAttributeName(conditionIdIn in integer) return varchar2;
5 function getAttributeType(conditionIdIn in integer) return varchar2;
6 function getConditionType(conditionIdIn in integer) return varchar2;
7 function getConditionKey(conditionIdIn in integer,
8 processingDateIn in date default null) return varchar2;
9 function conditionKeyExists (conditionKeyIn in varchar2) return boolean;
10 function getNextConditionKey return varchar2;
11 function getDescription(conditionIdIn in integer) return varchar2;
12 function getIncludeLowerLimit(conditionIdIn in integer) return varchar;
13 function getIncludeUpperLimit(conditionIdIn in integer) return varchar;
14 function isStringAttributeType(conditionIdIn in integer) return boolean;
15 function getParameterOne(conditionIdIn in integer) return varchar;
16 function getParameterTwo(conditionIdIn in integer) return varchar;
17 function getParameterThree(conditionIdIn in integer) return varchar;
18 function getStartDate(conditionIdIn in integer) return date;
19 function getType(conditionIdIn in integer) return varchar2;
20 function getVersionStartDate(conditionIdin integer) return varchar2;
21 function isConditionUsage(ruleIdIn in integer,
22 conditionIdIn in integer) return boolean;
23 function isInUseByOtherApps(conditionIdIn in integer,
24 applicationIdIn in integer) return boolean;
25 function isInUse(conditionIdIn in integer) return boolean;
26 function lineItemIsInUse(applicationIdIn in integer,
27 conditionTypeIn in varchar2) return boolean;
28 function new(typeIn in varchar2,
29 attributeIdIn in integer,
30 conditionKeyIn in varchar2,
31 attributeTypeIn in varchar2 default null,
32 parameterOneIn in varchar2 default null,
33 parameterTwoIn in varchar2 default null,
34 parameterThreeIn in varchar2 default null,
35 includeLowerLimitIn in varchar2 default null,
36 includeUpperLimitIn in varchar2 default null,
37 stringValueListIn in ame_util.longestStringList default ame_util.emptyLongestStringList,
38 newStartDateIn in date default null,
39 conditionIdIn in integer default null,
40 commitIn in boolean default true,
41 processingDateIn in date default null) return integer;
42 function newConditionUsage(ruleIdIn in integer,
43 conditionIdIn in integer,
44 processingDateIn in date default null) return boolean;
45 function newStringValue(conditionIdIn in integer,
46 valueIn in varchar2,
47 processingDateIn in date default null) return boolean;
48 procedure change(conditionIdIn in integer,
49 stringValuesIn in ame_util.longestStringList default ame_util.emptyLongestStringList,
50 typeIn in varchar2 default null,
51 attributeIdIn in integer default null,
52 parameterOneIn in varchar2 default null,
53 parameterTwoIn in varchar2 default null,
54 parameterThreeIn in varchar2 default null,
55 includeLowerLimitIn in varchar2 default null,
56 includeUpperLimitIn in varchar2 default null,
57 versionStartDateIn in date,
58 processingDateIn in date default null);
59 procedure getAllProperties(conditionIdIn in integer,
60 conditionTypeOut out nocopy varchar2,
61 conditionKeyOut out nocopy varchar2,
62 attributeIdOut out nocopy integer,
63 parameterOneOut out nocopy varchar2,
64 parameterTwoOut out nocopy varchar2,
65 parameterThreeOut out nocopy varchar2,
66 includeLowerLimitOut out nocopy varchar2,
67 includeUpperLimitOut out nocopy varchar2);
68 procedure getApplicationsUsingCondition(conditionIdIn in integer,
69 applicationIdIn in integer,
70 applicationNamesOut out nocopy ame_util.stringList);
71 procedure getAttributesConditions(attributeIdsIn in ame_util.idList,
72 conditionTypeIn in varchar2,
73 lineItemIn in varchar2 default ame_util.booleanFalse,
74 conditionIdsOut out nocopy ame_util.stringList,
75 conditionDescriptionsOut out nocopy ame_util.longStringList);
76 procedure getAttributesConditions1(attributeIdsIn in ame_util.idList,
77 conditionTypeIn in varchar2,
78 itemClassIdIn in integer,
79 ruleIdIn in integer,
80 conditionIdsOut out nocopy ame_util.stringList,
81 conditionDescriptionsOut out nocopy ame_util.longStringList);
82 procedure getAttributesConditions2(attributeIdsIn in ame_util.idList,
83 conditionTypeIn in varchar2,
84 itemClassIdIn in integer,
85 lineItemIn in varchar2 default ame_util.booleanFalse,
86 conditionIdsOut out nocopy ame_util.stringList,
87 conditionDescriptionsOut out nocopy ame_util.longStringList);
88 procedure getAuthPreConditions(applicationIdIn in integer,
89 itemClassIdIn in integer,
90 conditionIdsOut out nocopy ame_util.stringList,
91 conditionTypesOut out nocopy ame_util.stringList,
92 attributeIdsOut out nocopy ame_util.stringList,
93 attributeNamesOut out nocopy ame_util.stringList,
94 attributeTypesOut out nocopy ame_util.stringList,
95 conditionDescriptionsOut out nocopy ame_util.longStringList);
96 procedure getDescriptions(conditionIdsIn in ame_util.idList,
97 descriptionsOut out nocopy ame_util.longStringList);
98 procedure getDetailUrls(applicationIdIn in integer,
99 conditionIdsIn in ame_util.idList,
100 detailUrlsOut out nocopy ame_util.longStringList);
101 procedure getLMConditions(conditionIdOut out nocopy ame_util.idList,
102 parameterOneOut out nocopy ame_util.stringList,
103 parameterTwoOut out nocopy ame_util.stringList);
104 procedure getLMDescriptions(conditionIdsOut out nocopy ame_util.stringList,
105 descriptionsOut out nocopy ame_util.longStringList);
106 procedure getLMDescriptions2(conditionIdsOut out nocopy ame_util.stringList,
107 descriptionsOut out nocopy ame_util.longStringList);
108 procedure getLMDescriptions3(lmApproverTypeIn in varchar2,
109 conditionIdsOut out nocopy ame_util.stringList,
110 descriptionsOut out nocopy ame_util.longStringList);
111 procedure getStringValueList(conditionIdIn in integer,
112 stringValueListOut out nocopy ame_util.longestStringList);
113 procedure remove(conditionIdIn in integer,
114 versionStartDateIn in date,
115 processingDateIn in date default null);
116 procedure removeConditionUsage(ruleIdIn in integer,
117 conditionIdIn in integer,
118 newConditionIdIn in integer default null,
119 finalizeIn in boolean default true,
120 processingDateIn in date default null);
121 procedure removeStringValue(conditionIdIn in integer,
122 versionStartDateIn in date,
123 stringValueListIn in ame_util.longestStringList,
124 processingDateIn in date default null);
125 end ame_condition_pkg;
[Home] [Help]