64: -- the sequence.
65: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
66: -- Raise exception for invalid flag.
67: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
68: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
69: ---------------------------------------------------------------------
70: /*#
71: * This procedure creates a marketing metric. The details of the metric will
72: * be passed in the p_metric_rec record. Check x_return_status output to
83: * @param p_validation_level Level of validation required. None: No validation
84: * will be performed. Full: Item and record level
85: * validation will be performed.
86: * @param x_return_status Indicates the return status of the API. The values
87: * are one of the following: FND_API.G_RET_SUCCESS:
88: * Indicates the API call was successful,
89: * FND_API.G_RET_ERROR: Indicates an error has occured,
90: * FND_API.G_RET_UNEXPECTED: Indications an unexpected
91: * error has occured.
85: * validation will be performed.
86: * @param x_return_status Indicates the return status of the API. The values
87: * are one of the following: FND_API.G_RET_SUCCESS:
88: * Indicates the API call was successful,
89: * FND_API.G_RET_ERROR: Indicates an error has occured,
90: * FND_API.G_RET_UNEXPECTED: Indications an unexpected
91: * error has occured.
92: * @param x_msg_count Count of the number of error messages in the list.
93: * @param x_msg_data Error message returned by the API. If more than
86: * @param x_return_status Indicates the return status of the API. The values
87: * are one of the following: FND_API.G_RET_SUCCESS:
88: * Indicates the API call was successful,
89: * FND_API.G_RET_ERROR: Indicates an error has occured,
90: * FND_API.G_RET_UNEXPECTED: Indications an unexpected
91: * error has occured.
92: * @param x_msg_count Count of the number of error messages in the list.
93: * @param x_msg_data Error message returned by the API. If more than
94: * one message is returned, this parameter is null and
101: * @rep:lifecycle active
102: */
103: PROCEDURE Create_Metric(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
102: */
103: PROCEDURE Create_Metric(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
103: PROCEDURE Create_Metric(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
130: -- 1. Raise exception if the object_version_number doesn't match.
131: --------------------------------------------------------------------
132: PROCEDURE Delete_Metric(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: p_commit IN VARCHAR2 := FND_API.g_false,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
131: --------------------------------------------------------------------
132: PROCEDURE Delete_Metric(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: p_commit IN VARCHAR2 := FND_API.g_false,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
158: -- 1. Raise exception if the object_version_number doesn't match.
159: --------------------------------------------------------------------
160: PROCEDURE Lock_Metric(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
181: -- p_Metric_rec: the record with new items
182: --
183: -- NOTES
184: -- 1. Raise exception if the object_version_number doesn't match.
185: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
186: -- that column won't be updated.
187: ----------------------------------------------------------------------
188: PROCEDURE Update_Metric(
189: p_api_version IN NUMBER,
186: -- that column won't be updated.
187: ----------------------------------------------------------------------
188: PROCEDURE Update_Metric(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193:
194: x_return_status OUT NOCOPY VARCHAR2,
187: ----------------------------------------------------------------------
188: PROCEDURE Update_Metric(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193:
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
188: PROCEDURE Update_Metric(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193:
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
210: -- p_metric_rec: the Metric record to be validated
211: --
212: -- NOTES
213: -- 1. p_metric_rec should be the complete metric record. There
214: -- should not be any FND_API.g_miss_char/num/date in it.
215: ----------------------------------------------------------------------
216: PROCEDURE Validate_Metric(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: -- should not be any FND_API.g_miss_char/num/date in it.
215: ----------------------------------------------------------------------
216: PROCEDURE Validate_Metric(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
220:
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
215: ----------------------------------------------------------------------
216: PROCEDURE Validate_Metric(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
220:
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,