APPS.MSC_RP_RELEASE_PUB dependencies on MSC_RP_RELEASE_RESULTS

Line 228: insert into msc_rp_release_results(

224: FETCH cur_instance into l_sr_instance_id ;
225:
226: EXIT WHEN cur_instance%NOTFOUND;
227: FOR i in 1..11 LOOP
228: insert into msc_rp_release_results(
229: release_session_id,
230: instance_id,
231: release_code,
232: release_order_count,

Line 309: update msc_rp_release_results

305:
306:
307: if v_other_count > 0 then
308: FOR i in 1..loaded_jobs.COUNT LOOP
309: update msc_rp_release_results
310: set release_order_count=loaded_jobs(i),
311: release_request_id =wip_req_id(i)
312: where release_session_id=psid
313: and release_code=1

Line 317: update msc_rp_release_results

313: and release_code=1
314: and instance_id = release_instance(i);
315:
316:
317: update msc_rp_release_results
318: set release_order_count=resched_jobs(i),
319: release_request_id =wip_req_id(i)
320: where release_session_id=psid
321: and release_code=2

Line 325: update msc_rp_release_results

321: and release_code=2
322: and instance_id = release_instance(i);
323:
324:
325: update msc_rp_release_results
326: set release_order_count=loaded_lot_jobs(i),
327: release_request_id =osfm_req_id(i)
328: where release_session_id=psid
329: and release_code=3

Line 332: update msc_rp_release_results

328: where release_session_id=psid
329: and release_code=3
330: and instance_id = release_instance(i);
331:
332: update msc_rp_release_results
333: set release_order_count=resched_lot_jobs(i),
334: release_request_id =osfm_req_id(i)
335: where release_session_id=psid
336: and release_code=4

Line 339: update msc_rp_release_results

335: where release_session_id=psid
336: and release_code=4
337: and instance_id = release_instance(i);
338:
339: update msc_rp_release_results
340: set release_order_count=loaded_reqs(i),
341: release_request_id =po_req_load_id(i)
342: where release_session_id=psid
343: and release_code=5

Line 347: update msc_rp_release_results

343: and release_code=5
344: and instance_id = release_instance(i);
345:
346:
347: update msc_rp_release_results
348: set release_order_count=resched_reqs(i),
349: release_request_id =po_req_resched_id(i)
350: where release_session_id=psid
351: and release_code=6

Line 354: update msc_rp_release_results

350: where release_session_id=psid
351: and release_code=6
352: and instance_id = release_instance(i);
353:
354: update msc_rp_release_results
355: set release_order_count=loaded_int_reqs(i),
356: release_request_id =int_req_load_id(i)
357: where release_session_id=psid
358: and release_code=7

Line 362: update msc_rp_release_results

358: and release_code=7
359: and instance_id = release_instance(i);
360:
361:
362: update msc_rp_release_results
363: set release_order_count=resched_int_reqs(i),
364: release_request_id =int_req_resched_id(i)
365: where release_session_id=psid
366: and release_code=8

Line 369: update msc_rp_release_results

365: where release_session_id=psid
366: and release_code=8
367: and instance_id = release_instance(i);
368:
369: update msc_rp_release_results
370: set release_order_count=loaded_scheds(i),
371: release_request_id =wip_req_id(i)
372: where release_session_id=psid
373: and release_code=9

Line 411: update msc_rp_release_results

407:
408: if v_res_po_count > 0 then
409: FOR i in 1..v_res_po_count LOOP
410:
411: update msc_rp_release_results
412: set release_order_count=p_po_res_count(i),
413: release_request_id =p_po_res_id(i)
414: where release_session_id=psid
415: and release_code=10

Line 447: update msc_rp_release_results

443:
444: if v_rel_so_count > 0 then
445: FOR i in 1..p_so_rel_id.count -1 LOOP
446:
447: update msc_rp_release_results
448: set release_order_count=p_so_rel_count(i),
449: release_request_id =p_so_rel_id(i)
450: where release_session_id=psid
451: and release_code=11