[Home] [Help]
2999: select phase_code, status_code, queue_method_code, request_type,
3000: REQUEST_DATE, to_number(argument2),to_number(argument1), req_information, RUN_NUMBER
3001: into phasecode, statuscode, queuemethod, req_type,
3002: req_request_date, rset_id, appl_id, req_data, current_run_number
3003: from fnd_concurrent_requests
3004: where request_id = requestId;
3005: exception
3006: when NO_DATA_FOUND then
3007: message('Invalid request id : ' || requestId);
3032: end;
3033: /*check whether any errored out program got deleted */
3034: select count(r.request_set_program_id) INTO tmp_number
3035: from fnd_run_requests r,
3036: fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
3037: where r.parent_request_id = requestId
3038: and fcr1.parent_request_id = fcr2.request_id
3039: and fcr1.concurrent_program_id = r.concurrent_program_id
3040: and r.request_id = fcr1.request_id
3055: IF( not(req_type = 'M' and phasecode ='C' and statuscode = 'E') ) then
3056: return false;
3057: end if;
3058: if( queuemethod = 'B' ) then
3059: update fnd_concurrent_requests set phase_code = 'P', status_code = 'Q' where request_id = requestId;
3060: else if ( queuemethod = 'I' ) then
3061: update fnd_concurrent_requests set phase_code = 'P', status_code = 'I' where request_id = requestId;
3062: else
3063: return false;
3057: end if;
3058: if( queuemethod = 'B' ) then
3059: update fnd_concurrent_requests set phase_code = 'P', status_code = 'Q' where request_id = requestId;
3060: else if ( queuemethod = 'I' ) then
3061: update fnd_concurrent_requests set phase_code = 'P', status_code = 'I' where request_id = requestId;
3062: else
3063: return false;
3064: end if;
3065: end if;