DBA Data[Home] [Help]

APPS.WIP_ATO_JOBS_PRIV dependencies on DUAL

Line 174: select userenv('SESSIONID') into l_audsid from dual;

170:
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: select userenv('SESSIONID') into l_audsid from dual;
175: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
176:
177: fnd_message.set_name('FND', 'CONC-PARAMETERS');
178: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);

Line 841: from dual

837: --Check if there are any records that got completed either successfully or in warning
838: begin
839: select 1
840: into l_line_count
841: from dual
842: where exists
843: ( select source_line_id
844: from wip_job_schedule_interface
845: where group_id = l_wip_group_id