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