eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLANCOPY_UTIL_PVT dependencies on CN_COPY_REQUESTS_ALL

Line 155: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

151: ( p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2
159: ) IS

Line 191: select file_content_blob into l_blob from cn_copy_requests_all

187:
188: -- ******* API Begins ************
189: -- TODO : Error handling
190:
191: select file_content_blob into l_blob from cn_copy_requests_all
192: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
193:
194:
195: l_clob := blob_to_clob(l_blob);

Line 197: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;

193:
194:
195: l_clob := blob_to_clob(l_blob);
196:
197: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;
198:
199: -- ******* End of API body. ********
200: -- Standard check of p_commit.
201: IF FND_API.To_Boolean( p_commit ) THEN

Line 249: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

245: ( p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2
253: )

Line 285: select file_content_clob into l_clob from cn_copy_requests_all

281:
282: -- ******* API Begins ************
283: -- TODO : Error handling, waiting for xmltype to be added
284:
285: select file_content_clob into l_clob from cn_copy_requests_all
286: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
287:
288: l_xmltype := XMLTYPE(l_clob);
289:

Line 290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;

286: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
287:
288: l_xmltype := XMLTYPE(l_clob);
289:
290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
291:
292: -- ******* End of API body. ********
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN

Line 341: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

337: ( p_api_version IN NUMBER ,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2
345: )