46:
47: --===================================================================
48: TYPE metric_tpl_header_rec_type IS RECORD
49: (
50: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
47: --===================================================================
48: TYPE metric_tpl_header_rec_type IS RECORD
49: (
50: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: TYPE metric_tpl_header_rec_type IS RECORD
49: (
50: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: (
50: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
50: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
64: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
57: application_id NUMBER := FND_API.G_MISS_NUM,
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
64: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: );
58: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
64: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: );
66:
59: METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
64: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: );
66:
67: g_miss_metric_tpl_header_rec metric_tpl_header_rec_type;
60: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: used_by_id NUMBER := FND_API.G_MISS_NUM,
64: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: );
66:
67: g_miss_metric_tpl_header_rec metric_tpl_header_rec_type;
68: TYPE metric_tpl_header_tbl_type IS TABLE OF metric_tpl_header_rec_type INDEX BY BINARY_INTEGER;
80: -- Parameters
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
88: --
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
88: --
89: -- OUT
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
88: --
89: -- OUT
90: -- x_return_status OUT VARCHAR2
99: --
100:
101: PROCEDURE Create_Metric_Template(
102: p_api_version_number IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106:
107: x_return_status OUT NOCOPY VARCHAR2,
100:
101: PROCEDURE Create_Metric_Template(
102: p_api_version_number IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106:
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
101: PROCEDURE Create_Metric_Template(
102: p_api_version_number IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106:
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
124: -- Parameters
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
132: --
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
132: --
133: -- OUT
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
132: --
133: -- OUT
134: -- x_return_status OUT VARCHAR2
143: --
144:
145: PROCEDURE Update_Metric_Template(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
144:
145: PROCEDURE Update_Metric_Template(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
145: PROCEDURE Update_Metric_Template(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
168: -- Parameters
169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_METRIC_TPL_HEADER_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL
169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_METRIC_TPL_HEADER_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL
177: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_METRIC_TPL_HEADER_ID IN NUMBER
176: -- p_object_version_number IN NUMBER Optional Default = NULL
177: --
178: -- OUT
188: --
189:
190: PROCEDURE Delete_Metric_Template(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
189:
190: PROCEDURE Delete_Metric_Template(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
190: PROCEDURE Delete_Metric_Template(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_metric_tpl_header_id IN NUMBER,
211: -- Parameters
212: --
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
219: --
212: --
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
219: --
220: -- OUT
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
219: --
220: -- OUT
221: -- x_return_status OUT VARCHAR2
230: --
231:
232: PROCEDURE Lock_Metric_Template(
233: p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235:
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
254: -- End of Comments
255:
256: PROCEDURE Validate_metric_template(
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
260: p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
261: p_validation_mode IN VARCHAR2,
262: x_return_status OUT NOCOPY VARCHAR2,
255:
256: PROCEDURE Validate_metric_template(
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
260: p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
261: p_validation_mode IN VARCHAR2,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
293: -- End of Comments
294:
295: PROCEDURE Validate_met_tpl_hdr_rec(
296: p_api_version_number IN NUMBER,
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2,
301: p_metric_tpl_header_rec IN metric_tpl_header_rec_type