[Home] [Help]
PACKAGE: APPS.IEM_DP_MONITORING_PVT
Source
1 PACKAGE IEM_DP_MONITORING_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvmons.pls 120.5 2005/11/16 17:31:41 liangxia noship $ */
3 --
4 --
5 -- Purpose: Mantain Download Processor monitoring data
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 02/25/2005 Created
10 -- Liang Xia 08/15/2005 GET_DP_RUNNING_STATUS
11 -- Liang Xia 11/07/2005 Fixed bug 4628955
12 -- --------- ------ ------------------------------------------
13
14 -- Start of Comments
15 -- API name : CREATE_DP_ACCT_STATUS
16 -- Type : Private
17 -- Function : This procedure creates record in the table IEM_DP_ACCT_STATUStable
18 -- Pre-reqs : None.
19 -- Parameters :
20 PROCEDURE CREATE_DP_ACCT_STATUS (
21 p_api_version_number IN NUMBER,
22 p_init_msg_list IN VARCHAR2 := null,
23 p_commit IN VARCHAR2 := null,
24 P_acct_id IN number,
25 p_inbox_count IN number,
26 p_processed_count IN number,
27 p_retry_count IN number,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33 -- Start of Comments
34 -- API name : RECORD_ACCT_STATUS
35 -- Type : Private
36 -- Function : This procedure updates record in the table IEM_DP_ACCT_STATUS table
37 -- Pre-reqs : None.
38 -- Parameters :
39 PROCEDURE RECORD_ACCT_STATUS (
40 p_api_version_number IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := null,
42 p_commit IN VARCHAR2 := null,
43 P_acct_id IN number,
44 p_inbox_count IN number,
45 p_processed_count IN number,
46 p_retry_count IN number,
47 p_error_flag IN number,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 ) ;
52
53 -- Start of Comments
54 -- API name : UPDATE_DP_ACCT_STATUS
55 -- Type : Private
56 -- Function : This procedure updates record in the table IEM_DP_ACCT_STATUStable
57 -- Pre-reqs : None.
58 -- Parameters :
59 PROCEDURE UPDATE_DP_ACCT_STATUS (
60 p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := null,
62 p_commit IN VARCHAR2 := null,
63 P_acct_id IN number,
64 p_inbox_count IN number,
65 p_processed_count IN number,
66 p_retry_count IN number,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 -- Start of Comments
73 -- API name : CREATE_PROCESS_STATUS
74 -- Type : Private
75 -- Function : This procedure updates record in the table IEM_DP_PROCESS_STATUStable
76 -- Pre-reqs : None.
77 -- Parameters :
78 PROCEDURE CREATE_PROCESS_STATUS (
79 p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := null,
81 p_commit IN VARCHAR2 := null,
82 P_process_id IN VARCHAR2,
83 x_status_id OUT NOCOPY NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 -- Start of Comments
90 -- API name : cleanup_monitoring_data
91 -- Type : Private
92 -- Function : This procedure delete record in the table IEM_DP_PROCESS_STATUS table
93 -- Pre-reqs : None.
94 -- Parameters :
95 PROCEDURE cleanup_monitoring_data
96 (p_api_version_number IN NUMBER,
97 P_init_msg_list IN VARCHAR2 := null,
98 p_commit IN VARCHAR2 := null,
99 p_preproc_sleep IN NUMBER,
100 p_postproc_sleep IN NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2);
104
105
106 -- Start of Comments
107 -- API name : GET_DP_RUNNING_STATUS
108 -- Type : Private
109 -- Function : This procedure get the running status of DP by calling FND_CONCURRENT API
110 -- Pre-reqs : None.
111 -- Parameters :
112
113 PROCEDURE GET_DP_RUNNING_STATUS
114 (p_api_version_number IN NUMBER,
115 P_init_msg_list IN VARCHAR2 := null,
116 p_commit IN VARCHAR2 := null,
117 p_mode IN VARCHAR2 := null,
118 x_DP_STATUS OUT NOCOPY VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2);
122
123 -- Start of Comments
124 -- API name : GET_ACCOUNT_DP_STATUS
125 -- Type : Private
126 -- Function : This procedure is called by DP monitor GUI to populate DPAccountsVO
127 -- Pre-reqs : None.
128 -- Parameters :
129 PROCEDURE GET_ACCOUNT_DP_STATUS
130 (p_api_version_number IN NUMBER,
131 P_init_msg_list IN VARCHAR2 := null,
132 p_commit IN VARCHAR2 := null,
133 P_view_all_accounts IN VARCHAR2,
134 x_account_ids OUT NOCOPY jtf_number_Table,
135 x_email_address OUT NOCOPY jtf_varchar2_Table_200,
136 x_account_status OUT NOCOPY jtf_varchar2_Table_100,
137 x_processor_status OUT NOCOPY jtf_varchar2_Table_100,
138 x_last_run_time OUT NOCOPY jtf_date_Table,
139 x_inbox_msg_count OUT NOCOPY jtf_number_Table,
140 x_process_msg_count OUT NOCOPY jtf_number_Table,
141 x_retry_msg_count OUT NOCOPY jtf_number_Table,
142 x_log OUT NOCOPY jtf_varchar2_Table_100,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2);
146
147 FUNCTION get_parameter ( p_type in varchar2,
148 p_param in varchar2 )
149 return number;
150
151 END IEM_DP_MONITORING_PVT;