493: begin
494:
495: SELECT count(*)
496: INTO dummy
497: FROM fnd_conc_pp_actions pp,
498: fnd_concurrent_requests cr
499: WHERE pp.concurrent_request_id = reqid
500: AND pp.argument1= delivery_type
501: AND pp.concurrent_request_id = cr.request_id
546: nr_len number;
547:
548: cursor c1 is
549: select publisher_return_results, action_type, argument1
550: from FND_CONC_PP_ACTIONS
551: where concurrent_request_id = reqid
552: and action_type >= 6
553: order by action_type, argument1;
554: