APPS.CN_PLANCOPY_UTIL_PVT dependencies on CN_COPY_REQUESTS_ALL

Line 194: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

190: ( p_api_version IN NUMBER ,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2
198: ) IS

Line 230: select file_content_blob into l_blob from cn_copy_requests_all

226:
227: -- ******* API Begins ************
228: -- TODO : Error handling
229:
230: select file_content_blob into l_blob from cn_copy_requests_all
231: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
232:
233:
234: l_clob := blob_to_clob(l_blob);

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

241:
242: --addtion ends 14598731
243:
244:
245: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;
246:
247: -- ******* End of API body. ********
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN

Line 297: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

293: ( p_api_version IN NUMBER ,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
297: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2
301: )

Line 333: select file_content_clob into l_clob from cn_copy_requests_all

329:
330: -- ******* API Begins ************
331: -- TODO : Error handling, waiting for xmltype to be added
332:
333: select file_content_clob into l_clob from cn_copy_requests_all
334: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
335:
336: l_xmltype := XMLTYPE(l_clob);
337:

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

334: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
335:
336: l_xmltype := XMLTYPE(l_clob);
337:
338: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
339:
340: -- ******* End of API body. ********
341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN

Line 389: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,

385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2
393: )