396: into program_id
397: from sys.dual;
398:
399: if (stage_id is not null) then
400: fnd_message.set_name('FND', 'SRS-Request Set Stage');
401: request_set_text := fnd_message.get;
402: program_name := 'FNDRSSTG';
403: user_program_name := substr(request_set_text||' '||stage_name, 1, 240);
404: fnd_message.set_name('FND', 'SRS-Report Set');
397: from sys.dual;
398:
399: if (stage_id is not null) then
400: fnd_message.set_name('FND', 'SRS-Request Set Stage');
401: request_set_text := fnd_message.get;
402: program_name := 'FNDRSSTG';
403: user_program_name := substr(request_set_text||' '||stage_name, 1, 240);
404: fnd_message.set_name('FND', 'SRS-Report Set');
405: request_set_text := fnd_message.get;
400: fnd_message.set_name('FND', 'SRS-Request Set Stage');
401: request_set_text := fnd_message.get;
402: program_name := 'FNDRSSTG';
403: user_program_name := substr(request_set_text||' '||stage_name, 1, 240);
404: fnd_message.set_name('FND', 'SRS-Report Set');
405: request_set_text := fnd_message.get;
406: user_program_name := substr(user_program_name||' - '||request_set_text
407: ||' '||request_set, 1, 240);
408: new_name := stage_short_name;
401: request_set_text := fnd_message.get;
402: program_name := 'FNDRSSTG';
403: user_program_name := substr(request_set_text||' '||stage_name, 1, 240);
404: fnd_message.set_name('FND', 'SRS-Report Set');
405: request_set_text := fnd_message.get;
406: user_program_name := substr(user_program_name||' - '||request_set_text
407: ||' '||request_set, 1, 240);
408: new_name := stage_short_name;
409: else
406: user_program_name := substr(user_program_name||' - '||request_set_text
407: ||' '||request_set, 1, 240);
408: new_name := stage_short_name;
409: else
410: fnd_message.set_name('FND', 'SRS-Report Set');
411: request_set_text := fnd_message.get;
412: program_name := 'FNDRSSUB';
413: user_program_name := substr(request_set_text||' '||request_set, 1, 240);
414: new_name := set_short_name;
407: ||' '||request_set, 1, 240);
408: new_name := stage_short_name;
409: else
410: fnd_message.set_name('FND', 'SRS-Report Set');
411: request_set_text := fnd_message.get;
412: program_name := 'FNDRSSUB';
413: user_program_name := substr(request_set_text||' '||request_set, 1, 240);
414: new_name := set_short_name;
415: end if;