APPS.HR_DU_UTILITY SQL Statements

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

Line: 217

  SELECT module_name
  FROM hr_api_modules
  WHERE api_module_id = p_api_module_id;

Line: 411

  SELECT parameter_value
    FROM pay_action_parameters
    WHERE parameter_name = 'HR_DU_DEBUG_LOG';

Line: 557

  SELECT status
    FROM hr_du_uploads
    WHERE (upload_id = p_upload_id);

Line: 624

  SELECT status
    FROM hr_du_upload_headers
    WHERE (upload_header_id = p_upload_header_id);

Line: 687

  SELECT status
    FROM hr_du_upload_lines
    WHERE (upload_line_id = p_upload_lines_id);

Line: 745

PROCEDURE update_uploads (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_uploads
-- parent of hr_du_upload_headers
-- child of (none)

l_complete VARCHAR2(30);

Line: 755

  SELECT status
    FROM hr_du_upload_headers
    WHERE ((upload_id = p_id)
      AND (status <> 'C'));

Line: 763

message('ROUT','entry:hr_du_utility.update_uploads', 5);

Line: 770

  UPDATE hr_du_uploads
  SET status = p_new_status
  WHERE upload_id = p_id;

Line: 786

    UPDATE hr_du_uploads
    SET status = p_new_status
    WHERE upload_id = p_id;

Line: 794

message('INFO','Update status - update_uploads', 15);

Line: 795

message('SUMM','Update status - update_uploads', 20);

Line: 796

message('ROUT','exit:hr_du_utility.update_uploads', 25);

Line: 802

  error(SQLCODE,'hr_du_utility.update_uploads','(none)','R');

Line: 806

END update_uploads;

Line: 827

PROCEDURE update_upload_lines (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_upload_lines
-- parent of n/a
-- child of hr_du_upload_headers

l_parent_table_id NUMBER(9);

Line: 837

  SELECT upload_header_id
    FROM hr_du_upload_lines
    WHERE upload_line_id = p_id;

Line: 845

message('ROUT','entry:hr_du_utility.update_upload_lines', 5);

Line: 850

UPDATE hr_du_upload_lines
  SET status = p_new_status
  WHERE upload_line_id = p_id;

Line: 860

  update_upload_headers(p_new_status,l_parent_table_id);

Line: 863

message('INFO','Update status - update_upload_lines', 15);

Line: 864

message('SUMM','Update status - update_upload_lines', 20);

Line: 865

message('ROUT','exit:hr_du_utility.update_upload_lines', 25);

Line: 871

  error(SQLCODE,'hr_du_utility.update_upload_lines','(none)','R');

Line: 875

END update_upload_lines;

Line: 897

PROCEDURE update_upload_headers (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
--
-- table is hr_du_upload_headers
-- parent of hr_du_upload_lines
-- child of hr_du_uploads

l_parent_table_id NUMBER(9);

Line: 909

  SELECT status
    FROM hr_du_upload_lines
    WHERE ((upload_header_id = p_id)
      AND (status <> 'C'));

Line: 916

  SELECT upload_id
    FROM hr_du_upload_headers
    WHERE upload_header_id = p_id;

Line: 924

message('ROUT','entry:hr_du_utility.update_upload_headers', 5);

Line: 933

  UPDATE hr_du_upload_headers
  SET status = l_new_status
  WHERE upload_header_id = p_id;

Line: 949

    UPDATE hr_du_upload_headers
    SET status = l_new_status
    WHERE upload_header_id = p_id;

Line: 965

  update_uploads(l_new_status,l_parent_table_id);

Line: 969

message('INFO','Update status - update_upload_headers', 15);

Line: 970

message('SUMM','Update status - update_upload_headers', 20);

Line: 971

message('ROUT','exit:hr_dm_utility.update_upload_headers', 25);

Line: 977

  error(SQLCODE,'hr_dm_utility.update_upload_headers','(none)','R');

Line: 981

END update_upload_headers;

Line: 1069

  SELECT PARAMETER_VALUE
    FROM pay_action_parameters
    WHERE PARAMETER_NAME = 'CHUNK_SIZE';