53: l_active_perf := 'Y';
54: l_ao_update_pending_perf := 'Y';
55: l_soft_closed_perf := 'N';
56:
57: l_user_id := NVL(FND_GLOBAL.user_id,-1);
58: l_login_id := NVL(FND_GLOBAL.conc_login_id,-1);
59:
60: -- dbms_output.put_line('About to Enter Loop');
61:
54: l_ao_update_pending_perf := 'Y';
55: l_soft_closed_perf := 'N';
56:
57: l_user_id := NVL(FND_GLOBAL.user_id,-1);
58: l_login_id := NVL(FND_GLOBAL.conc_login_id,-1);
59:
60: -- dbms_output.put_line('About to Enter Loop');
61:
62: for L in 1..P_COUNT
241: JTF_IH_PUB.close_mediaitem(
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => l_Commit,
245: p_resp_appl_id => fnd_global.resp_appl_id,
246: p_resp_id => fnd_global.resp_id,
247: p_user_id => fnd_global.user_id,
248: p_login_id => fnd_global.login_id,
249: x_return_status => x_return_status,
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => l_Commit,
245: p_resp_appl_id => fnd_global.resp_appl_id,
246: p_resp_id => fnd_global.resp_id,
247: p_user_id => fnd_global.user_id,
248: p_login_id => fnd_global.login_id,
249: x_return_status => x_return_status,
250: x_msg_count => x_msg_count,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => l_Commit,
245: p_resp_appl_id => fnd_global.resp_appl_id,
246: p_resp_id => fnd_global.resp_id,
247: p_user_id => fnd_global.user_id,
248: p_login_id => fnd_global.login_id,
249: x_return_status => x_return_status,
250: x_msg_count => x_msg_count,
251: x_msg_data => x_msg_data,
244: p_commit => l_Commit,
245: p_resp_appl_id => fnd_global.resp_appl_id,
246: p_resp_id => fnd_global.resp_id,
247: p_user_id => fnd_global.user_id,
248: p_login_id => fnd_global.login_id,
249: x_return_status => x_return_status,
250: x_msg_count => x_msg_count,
251: x_msg_data => x_msg_data,
252: p_media_rec => p_Media
255: JTF_IH_PUB.update_mediaitem(
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.G_TRUE,
258: p_commit => l_Commit,
259: p_resp_appl_id => fnd_global.resp_appl_id,
260: p_resp_id => fnd_global.resp_id,
261: p_user_id => fnd_global.user_id,
262: p_login_id => fnd_global.login_id,
263: x_return_status => x_return_status,
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.G_TRUE,
258: p_commit => l_Commit,
259: p_resp_appl_id => fnd_global.resp_appl_id,
260: p_resp_id => fnd_global.resp_id,
261: p_user_id => fnd_global.user_id,
262: p_login_id => fnd_global.login_id,
263: x_return_status => x_return_status,
264: x_msg_count => x_msg_count,
257: p_init_msg_list => FND_API.G_TRUE,
258: p_commit => l_Commit,
259: p_resp_appl_id => fnd_global.resp_appl_id,
260: p_resp_id => fnd_global.resp_id,
261: p_user_id => fnd_global.user_id,
262: p_login_id => fnd_global.login_id,
263: x_return_status => x_return_status,
264: x_msg_count => x_msg_count,
265: x_msg_data => x_msg_data,
258: p_commit => l_Commit,
259: p_resp_appl_id => fnd_global.resp_appl_id,
260: p_resp_id => fnd_global.resp_id,
261: p_user_id => fnd_global.user_id,
262: p_login_id => fnd_global.login_id,
263: x_return_status => x_return_status,
264: x_msg_count => x_msg_count,
265: x_msg_data => x_msg_data,
266: p_media_rec => p_Media