DBA Data[Home] [Help]

APPS.AME_CONDITION_PKG dependencies on AME_UTIL

Line 37: stringValueListIn in ame_util.longestStringList default ame_util.emptyLongestStringList,

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;

Line 49: stringValuesIn in ame_util.longestStringList default ame_util.emptyLongestStringList,

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,

Line 70: applicationNamesOut out nocopy ame_util.stringList);

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,

Line 71: procedure getAttributesConditions(attributeIdsIn in ame_util.idList,

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

Line 73: lineItemIn in varchar2 default ame_util.booleanFalse,

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,

Line 74: conditionIdsOut out nocopy ame_util.stringList,

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,

Line 75: conditionDescriptionsOut out nocopy ame_util.longStringList);

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,

Line 76: procedure getAttributesConditions1(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,

Line 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,

Line 81: conditionDescriptionsOut out nocopy ame_util.longStringList);

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,

Line 82: procedure getAttributesConditions2(attributeIdsIn in ame_util.idList,

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,

Line 85: lineItemIn in varchar2 default ame_util.booleanFalse,

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,

Line 86: conditionIdsOut out nocopy ame_util.stringList,

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,

Line 87: conditionDescriptionsOut out nocopy ame_util.longStringList);

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,

Line 90: conditionIdsOut 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,

Line 91: conditionTypesOut 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);

Line 92: attributeIdsOut out nocopy ame_util.stringList,

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,

Line 93: attributeNamesOut out nocopy ame_util.stringList,

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

Line 94: attributeTypesOut out nocopy ame_util.stringList,

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,

Line 95: conditionDescriptionsOut out nocopy ame_util.longStringList);

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,

Line 96: procedure getDescriptions(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);

Line 97: descriptionsOut 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,

Line 99: conditionIdsIn in 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);

Line 100: detailUrlsOut 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,

Line 101: procedure getLMConditions(conditionIdOut out nocopy 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);

Line 102: parameterOneOut out nocopy ame_util.stringList,

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,

Line 103: parameterTwoOut 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);

Line 104: procedure getLMDescriptions(conditionIdsOut out nocopy ame_util.stringList,

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,

Line 105: descriptionsOut 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,

Line 106: procedure getLMDescriptions2(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);

Line 107: 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,

Line 109: 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,

Line 110: 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,

Line 112: stringValueListOut out nocopy ame_util.longestStringList);

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,

Line 123: stringValueListIn in ame_util.longestStringList,

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;