42: -- Function Re-calculate the value for a given activity metric.
43: -- Parameters
44: -- IN p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default := FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default := FND_API.G_FALSE
49: -- p_activity_metric_id IN NUMBER Required
50: -- p_refresh_type IN VARCHAR2 Required
44: -- IN p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default := FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default := FND_API.G_FALSE
49: -- p_activity_metric_id IN NUMBER Required
50: -- p_refresh_type IN VARCHAR2 Required
51: -- p_refresh_function IN VARCHAR2 Optional
52: -- OUT x_return_status OUT VARCHAR2
58: -- End of comments
59:
60: PROCEDURE Refresh_Metric (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
59:
60: PROCEDURE Refresh_Metric (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_activity_metric_id IN NUMBER,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_activity_metric_id IN NUMBER,
68: p_refresh_type IN VARCHAR2,
69: p_refresh_function IN VARCHAR2 := Fnd_Api.G_TRUE
70: );
71:
72: -- Start of Comments
73: --
87:
88: PROCEDURE Refresh_Act_metrics (
89: errbuf OUT NOCOPY VARCHAR2,
90: retcode OUT NOCOPY NUMBER,
91: p_update_history IN VARCHAR2 := Fnd_Api.G_FALSE
92: );
93:
94: -- Start of comments
95: -- API Name GetMetricCatVal
134: -- inserted into Activity Metric table for M1,M2,M3 attached to C1
135: -- Parameters
136: -- IN p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default := FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default := FND_API.G_FALSE
141: -- p_act_arc_metric_used_by IN VARCHAR2 Required
142: -- p_act_metric_used_by_id IN NUMBER Required
136: -- IN p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default := FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default := FND_API.G_FALSE
141: -- p_act_arc_metric_used_by IN VARCHAR2 Required
142: -- p_act_metric_used_by_id IN NUMBER Required
143: -- p_act_metric_used_by_type IN VARCHAR2 Required
144: -- OUT x_return_status OUT VARCHAR2
151:
152:
153: PROCEDURE Copy_Seeded_Metric (
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
156: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
152:
153: PROCEDURE Copy_Seeded_Metric (
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
156: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_arc_act_metric_used_by IN VARCHAR2 ,
172: --
173: -- Parameters
174: -- IN p_api_version IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional
176: -- Default := FND_API.G_FALSE
177: -- p_commit IN VARCHAR2 Optional
178: -- Default := FND_API.G_FALSE
179: -- p_obj_association_id IN NUMBER Required
180: -- OUT x_return_status OUT VARCHAR2
174: -- IN p_api_version IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional
176: -- Default := FND_API.G_FALSE
177: -- p_commit IN VARCHAR2 Optional
178: -- Default := FND_API.G_FALSE
179: -- p_obj_association_id IN NUMBER Required
180: -- OUT x_return_status OUT VARCHAR2
181: -- x_msg_count OUT NUMBER
182: -- x_msg_data OUT VARCHAR2
187:
188:
189: PROCEDURE Create_Apport_Metric(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
192: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
188:
189: PROCEDURE Create_Apport_Metric(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
192: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_obj_association_id IN NUMBER
238: -- Function Re-calculate the value for a given activity metric.
239: -- Parameters
240: -- IN p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional
242: -- Default := FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Optional
244: -- Default := FND_API.G_FALSE
245: -- p_arc_act_metric_used_by IN VARCHAR2 Required
246: -- p_act_metric_used_by_id IN NUMBER Required
240: -- IN p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional
242: -- Default := FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Optional
244: -- Default := FND_API.G_FALSE
245: -- p_arc_act_metric_used_by IN VARCHAR2 Required
246: -- p_act_metric_used_by_id IN NUMBER Required
247: -- p_refresh_function IN VARCHAR2 Optional
248: -- OUT x_return_status OUT VARCHAR2
252: -- Previous version: 1.0
253: -- Initial version: 1.0
254: PROCEDURE Refresh_Metric (
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE,
257: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
253: -- Initial version: 1.0
254: PROCEDURE Refresh_Metric (
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE,
257: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_arc_act_metric_used_by IN VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_arc_act_metric_used_by IN VARCHAR2,
262: p_act_metric_used_by_id IN NUMBER,
263: p_refresh_function IN VARCHAR2 := Fnd_Api.G_TRUE
264: );
265:
266: -- API Name check_object_status
267: -- Type Private