DBA Data[Home] [Help]

APPS.IEM_DP_MONITORING_PVT dependencies on IEM_COMP_RT_STATS

Line 584: -- Insert parameters into iem_comp_rt_stats

580: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
581: raise IEM_ERR_QUE_RESET;
582: end if;
583:
584: -- Insert parameters into iem_comp_rt_stats
585: delete IEM_COMP_RT_STATS where type='DOWNLOAD PROCESSOR';
586:
587: IEM_COMP_RT_STATS_PVT.create_item (
588: p_api_version_number =>P_Api_Version_Number,

Line 585: delete IEM_COMP_RT_STATS where type='DOWNLOAD PROCESSOR';

581: raise IEM_ERR_QUE_RESET;
582: end if;
583:
584: -- Insert parameters into iem_comp_rt_stats
585: delete IEM_COMP_RT_STATS where type='DOWNLOAD PROCESSOR';
586:
587: IEM_COMP_RT_STATS_PVT.create_item (
588: p_api_version_number =>P_Api_Version_Number,
589: p_init_msg_list => FND_API.G_FALSE,

Line 587: IEM_COMP_RT_STATS_PVT.create_item (

583:
584: -- Insert parameters into iem_comp_rt_stats
585: delete IEM_COMP_RT_STATS where type='DOWNLOAD PROCESSOR';
586:
587: IEM_COMP_RT_STATS_PVT.create_item (
588: p_api_version_number =>P_Api_Version_Number,
589: p_init_msg_list => FND_API.G_FALSE,
590: p_commit => 'F',
591: p_type => 'DOWNLOAD PROCESSOR',

Line 602: IEM_COMP_RT_STATS_PVT.create_item (

598: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
599: raise IEM_ERR_QUE_RESET;
600: end if;
601:
602: IEM_COMP_RT_STATS_PVT.create_item (
603: p_api_version_number =>P_Api_Version_Number,
604: p_init_msg_list => FND_API.G_FALSE,
605: p_commit => 'F',
606: p_type => 'DOWNLOAD PROCESSOR',

Line 1084: select value into l_value from iem_comp_rt_stats where type=p_type and param=p_param;

1080: l_result number := 60000;
1081: l_value varchar2(15);
1082: BEGIN
1083:
1084: select value into l_value from iem_comp_rt_stats where type=p_type and param=p_param;
1085:
1086: if ( l_value is not null ) then
1087: l_result := to_number(l_value);
1088: end if;