30: -- Parameters
31: --
32: -- IN
33: -- p_api_version_number IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
35: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_threshold_rec IN threshold_rec_type Required
38: --
31: --
32: -- IN
33: -- p_api_version_number IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
35: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_threshold_rec IN threshold_rec_type Required
38: --
39: -- OUT
32: -- IN
33: -- p_api_version_number IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
35: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_threshold_rec IN threshold_rec_type Required
38: --
39: -- OUT
40: -- x_msg_count OUT NUMBER
46: -- End of Comments
47: -- ==============================================================================
48: PROCEDURE validate_threshold
49: ( /*p_api_version_number IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
47: -- ==============================================================================
48: PROCEDURE validate_threshold
49: ( /*p_api_version_number IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: x_msg_buffer OUT NOCOPY VARCHAR2,
48: PROCEDURE validate_threshold
49: ( /*p_api_version_number IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: x_msg_buffer OUT NOCOPY VARCHAR2,
56: x_return_status OUT NOCOPY VARCHAR2
71: -- Parameters
72: --
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_budget_id IN NUMBER Required
77: -- p_value_limit_type IN VARCHAR2 Required
78: -- p_off_on_line IN VARCHAR2 Required
79:
89: -- ==============================================================================
90:
91: PROCEDURE value_limit
92: ( p_api_version_number IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: X_Msg_Count OUT NOCOPY NUMBER,
95: X_Msg_Data OUT NOCOPY VARCHAR2,
96: x_return_status OUT NOCOPY VARCHAR2,
97: p_budget_id IN NUMBER,
111: -- Parameters
112: --
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_budget_id IN Required
117: -- p_percent IN NUMBER Required
118: -- p_base_line_type IN VARCHAR2 Required
119: --
128: -- End of Comments
129: -- ==============================================================================
130: PROCEDURE base_line_amt(
131: p_api_version_number IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: X_Msg_Count OUT NOCOPY NUMBER,
134: X_Msg_Data OUT NOCOPY VARCHAR2,
135: x_return_status OUT NOCOPY VARCHAR2,
136: p_budget_id IN NUMBER,
150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_lhs IN NUMBER Required
156: -- p_rhs IN NUMBER Optional Required
157: -- p_operator_code IN VARCHAR2 Required
158: --
167: -- End of Comments
168: -- ==============================================================================
169: PROCEDURE operation_result(
170: p_api_version_number IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: X_Msg_Count OUT NOCOPY NUMBER,
173: X_Msg_Data OUT NOCOPY VARCHAR2,
174: x_return_status OUT NOCOPY VARCHAR2,
175: p_lhs IN NUMBER,
188: -- Parameters
189: --
190: -- IN
191: -- p_api_version_number IN NUMBER Required
192: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
193: -- p_budget_id IN NUMBER Required
194: -- p_threshold_id IN NUMBER Required
195: -- p_threshold_rule_id IN NUMBER Required
196: -- p_frequency_period IN VARCHAR2 Required
210: -- ==============================================================================
211:
212: PROCEDURE verify_notification(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: X_Msg_Count OUT NOCOPY NUMBER,
216: X_Msg_Data OUT NOCOPY VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: p_budget_id IN NUMBER,