4328: l_conc_request_id NUMBER := null;
4329:
4330: cursor cur_message(c_process_code FND_LOOKUPS.lookup_code%TYPE) is
4331: select meaning message_name, 'PROCESS' message_type
4332: from pa_lookups
4333: where lookup_code = c_process_code
4334: and c_process_code like '%P'
4335: union all
4336: select meaning message_name, 'ERROR_EDITABLE' message_type
4333: where lookup_code = c_process_code
4334: and c_process_code like '%P'
4335: union all
4336: select meaning message_name, 'ERROR_EDITABLE' message_type
4337: from pa_lookups
4338: where lookup_code = c_process_code
4339: and c_process_code like '%E'
4340: and c_process_code <> 'PUE'
4341: union all
4339: and c_process_code like '%E'
4340: and c_process_code <> 'PUE'
4341: union all
4342: select meaning message_name, 'ERROR_NOT_EDITABLE' message_type
4343: from pa_lookups
4344: where lookup_code = c_process_code
4345: and c_process_code = 'PUE'
4346: ;
4347: