APPS.CST_START_IMP_PROCESS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

fnd_file.put_line(fnd_file.log,'Group ID selected: ' || i_next_val);

Line: 34

fnd_file.put_line(fnd_file.log,'Delete option    : ' || to_char (i_del_option));

Line: 39

select FCR.argument5 into l_req_arg
from FND_CONCURRENT_REQUESTS FCR
WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
AND FCR.request_id = FND_GLOBAL.CONC_REQUEST_ID;

Line: 45

select min(FCR.request_id) into l_min_reqid
from FND_CONCURRENT_REQUESTS FCR
WHERE FCR.concurrent_program_id = FND_GLOBAL.CONC_PROGRAM_ID
      AND FCR.program_application_id = FND_GLOBAL.PROG_APPL_ID
      AND FCR.phase_code <> 'C'
      AND ((NVL(FCR.argument5,'X') = NVL(l_req_arg,'X'))
           OR (FCR.argument5 is null)
           OR (l_req_arg is null));

Line: 64

  select CST_LISTS_S.NEXTVAL into l_grp_id
  from dual;

Line: 72

fnd_file.put_line(fnd_file.log,'Group ID selected: ' || l_grp_id);