DBA Data[Home] [Help]

APPS.IEM_DP_MONITORING_PVT dependencies on IEM_DP_MONITORING_PVT

Line 1: PACKAGE BODY IEM_DP_MONITORING_PVT AS

1: PACKAGE BODY IEM_DP_MONITORING_PVT AS
2: /* $Header: iemvmonb.pls 120.13 2006/05/19 14:05:04 rtripath noship $ */
3:
4: --
5: --

Line 23: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DP_MONITORING_PVT ';

19: -- Liang Xia 11/07/2005 Fixed bug 4628955
20: -- --------- ------ ------------------------------------------
21:
22: -- Enter procedure, function bodies as shown below
23: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DP_MONITORING_PVT ';
24: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
26:
27: PROCEDURE CREATE_DP_ACCT_STATUS (

Line 211: IEM_DP_MONITORING_PVT.update_dp_acct_status(

207: -- if existed, updated record
208: -- else create new records.
209: if l_count > 0 then
210: if p_error_flag = 0 then
211: IEM_DP_MONITORING_PVT.update_dp_acct_status(
212: p_api_version_number => P_Api_Version_Number,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => P_Commit,
215: P_acct_id => P_acct_id,

Line 229: IEM_DP_MONITORING_PVT.create_dp_acct_status(

225: else
226: update IEM_DP_ACCT_STATUS set LAST_UPDATE_DATE = sysdate where email_account_id=P_acct_id;
227: end if;
228: else
229: IEM_DP_MONITORING_PVT.create_dp_acct_status(
230: p_api_version_number => P_Api_Version_Number,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_commit => P_Commit,
233: P_acct_id => P_acct_id,

Line 869: IEM_DP_MONITORING_PVT.get_dp_running_status(

865: -- Initialize API return status to SUCCESS
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:
868:
869: IEM_DP_MONITORING_PVT.get_dp_running_status(
870: p_api_version_number =>P_Api_Version_Number,
871: p_init_msg_list => FND_API.G_FALSE,
872: p_commit => 'F',
873: p_mode => 'N',

Line 886: l_pre_sleep := iem_dp_monitoring_pvt.get_parameter('DOWNLOAD PROCESSOR', 'PREPROC_SLEEP_DURATION');

882:
883: i:= 1;
884:
885: --if ( l_dp_status = 'Active' ) then
886: l_pre_sleep := iem_dp_monitoring_pvt.get_parameter('DOWNLOAD PROCESSOR', 'PREPROC_SLEEP_DURATION');
887:
888:
889: if ( P_view_all_accounts = 'ONLY_ACTIVE_ACCOUNTS' ) then
890:

Line 1098: END IEM_DP_MONITORING_PVT;

1094: return l_result;
1095: END;
1096:
1097:
1098: END IEM_DP_MONITORING_PVT;