APPS.BIS_PMF_ALERT_REG_PVT dependencies on BIS_PMF_ALERT_PARAMETERS

Line 135: insert into bis_pmf_alert_parameters(

131: ||p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID);
132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);
133: */
134: --
135: insert into bis_pmf_alert_parameters(
136: REGISTRATION_ID
137: , PERFORMANCE_MEASURE_ID
138: , TARGET_LEVEL_ID
139: , TIME_DIMENSION_LEVEL_ID

Line 267: -- select count(1) into l_count_1 from bis_pmf_alert_parameters;

263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: -- BIS_UTILITIES_PUB.put_line(p_text =>'Deleting parameter set: '||p_registration_ID);
266:
267: -- select count(1) into l_count_1 from bis_pmf_alert_parameters;
268: -- where registration_id = p_registration_id;
269:
270: delete from bis_pmf_alert_parameters
271: where registration_id = p_registration_id;

Line 270: delete from bis_pmf_alert_parameters

266:
267: -- select count(1) into l_count_1 from bis_pmf_alert_parameters;
268: -- where registration_id = p_registration_id;
269:
270: delete from bis_pmf_alert_parameters
271: where registration_id = p_registration_id;
272: commit;
273:
274: --select count(1) into l_count_2 from bis_pmf_alert_parameters;

Line 274: --select count(1) into l_count_2 from bis_pmf_alert_parameters;

270: delete from bis_pmf_alert_parameters
271: where registration_id = p_registration_id;
272: commit;
273:
274: --select count(1) into l_count_2 from bis_pmf_alert_parameters;
275: -- where registration_id = p_registration_id;
276:
277: BIS_UTILITIES_PUB.put_line(p_text =>'before delete: '||l_count_1||', after delete: '||l_count_2);
278: l_debug := 'before delete: '||l_count_1||', after delete: '||l_count_2;

Line 323: BIS_PMF_ALERT_PARAMETERS

319: , PARAMETER6_VALUE
320: , PARAMETER7_VALUE
321: , NOTIFY_OWNER_FLAG
322: from
323: BIS_PMF_ALERT_PARAMETERS
324: where PERFORMANCE_MEASURE_ID = p_measure_id
325: and TIME_DIMENSION_LEVEL_ID = p_time_dimension_level_id;
326:
327: i number := 0;

Line 421: BIS_PMF_ALERT_PARAMETERS

417: , PARAMETER6_VALUE
418: , PARAMETER7_VALUE
419: , NOTIFY_OWNER_FLAG
420: from
421: BIS_PMF_ALERT_PARAMETERS
422: where REGISTRATION_ID = p_Param_Set_Rec.REGISTRATION_ID;
423:
424: Cursor parameter_set_tl is
425: select

Line 441: BIS_PMF_ALERT_PARAMETERS

437: , PARAMETER6_VALUE
438: , PARAMETER7_VALUE
439: , NOTIFY_OWNER_FLAG
440: from
441: BIS_PMF_ALERT_PARAMETERS
442: where TARGET_LEVEL_ID = p_Param_Set_Rec.TARGET_LEVEL_ID
443: and PLAN_ID = p_Param_Set_Rec.PLAN_ID
444: -- and ( (TIME_DIMENSION_LEVEL_ID IS NULL
445: -- and p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID IS NULL)