[Home] [Help]
76: begin
77: p_return_status := 2;
78: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
79: p_return_msg := fnd_message.get;
80: SELECT msc_form_query_s.nextval
81: INTO l_query_id
82: FROM dual;
83:
84: /*
81: INTO l_query_id
82: FROM dual;
83:
84: /*
85: INSERT INTO msc_form_query(
86: query_id,
87: last_update_date,
88: last_updated_by,
89: creation_date,
421: end if;
422:
423:
424:
425: -- need to insert data into msc_form_query table so it
426: -- can be displayed to a user
427: if v_res_po_count + v_other_count + v_rel_so_count> 0 then
428:
429: -- ----------------------------------------
429: -- ----------------------------------------
430: -- Set all the field on the release results
431: -- window and go there.
432: -- ----------------------------------------
433: SELECT msc_form_query_s.nextval
434: INTO l_query_id
435: FROM dual;
436:
437:
436:
437:
438: if v_other_count > 0 then
439: FOR i in 1..loaded_jobs.COUNT LOOP
440: INSERT INTO msc_form_query(
441: query_id,
442: last_update_date,
443: last_updated_by,
444: creation_date,
507:
508:
509: if v_res_po_count > 0 then
510: FOR i in 1..v_res_po_count LOOP
511: INSERT INTO msc_form_query(
512: query_id,
513: last_update_date,
514: last_updated_by,
515: creation_date,
538:
539:
540: if v_rel_so_count > 0 then
541: FOR i in 1..p_so_rel_id.count -1 LOOP
542: INSERT INTO msc_form_query(
543: query_id,
544: last_update_date,
545: last_updated_by,
546: creation_date,