APPS.HR_DU_RULES SQL Statements

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

Line: 20

  SELECT upper(VALUE)
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'API'
    AND UPLOAD_HEADER_ID = p_upload_header_id;

Line: 27

  SELECT upper(DESCRIPTOR)
    FROM hr_du_descriptors
    WHERE DESCRIPTOR_TYPE = 'F'
    AND UPLOAD_ID = p_upload_id
    AND upload_header_id IS NULL;

Line: 107

  SELECT VALUE
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'PROCESS ORDER'
    AND UPLOAD_HEADER_ID = p_upload_header_id;

Line: 168

  SELECT des2.value
  FROM   hr_du_descriptors     des1,
         hr_du_descriptors     des2,
         hr_du_upload_headers  head,
         hr_du_uploads	       uplo
  WHERE  head.upload_header_id = p_upload_header_id
  AND    head.upload_id = uplo.upload_id
  AND    head.upload_header_id = des1.upload_header_id
  AND    des1.descriptor = 'API'
  AND    uplo.upload_id = des2.upload_id
  AND    upper(des2.descriptor) = upper(des1.value);

Line: 240

  SELECT VALUE
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'USER KEY'
    AND UPLOAD_HEADER_ID = p_upload_header_id;

Line: 261

      INSERT INTO HR_DU_DESCRIPTORS(
           DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
  	   DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
	   LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
	   CREATION_DATE)
      VALUES(
          HR_DU_DESCRIPTORS_S.nextval,
          p_upload_id,
          p_upload_header_id,
          'USER KEY',
          '%NONE%',
          'D',
          sysdate,
          1,
          1,
          1,
          sysdate);

Line: 330

  SELECT des.VALUE
  FROM 	 hr_du_descriptors     des,
         hr_du_upload_headers  head
  WHERE  head.upload_header_id = p_upload_header_id
    AND  head.upload_id = des.upload_id
    AND  des.upload_header_id IS NULL
    AND  upper(des.descriptor) = upper(l_pval_value);

Line: 341

  SELECT VALUE
  FROM 	 hr_du_descriptors
  WHERE  upload_header_id = p_upload_header_id
    AND  upper(descriptor) = upper(l_pval_value);

Line: 349

  SELECT column_name
  FROM hr_du_column_mappings  col,
       hr_du_upload_headers   head
  WHERE upper(col.column_name) = upper(l_pval_value)
    AND head.upload_header_id = p_upload_header_id
    AND head.api_module_id = col.api_module_id;

Line: 366

    hr_du_di_insert.g_current_delimiter   := ':';

Line: 367

    hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

Line: 368

    l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);

Line: 372

      hr_du_di_insert.g_current_delimiter   := ':';

Line: 373

      l_pval_value := hr_du_di_insert.Return_Word(p_user_key, j);

Line: 401

          hr_du_di_insert.g_current_delimiter   := '%';

Line: 402

          hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

Line: 403

          l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);

Line: 410

            hr_du_di_insert.g_current_delimiter   := '$';

Line: 411

            hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

Line: 412

            l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);

Line: 471

  SELECT VALUE
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'STARTING POINT'
    AND UPLOAD_header_ID = p_upload_header_id;

Line: 494

    INSERT INTO HR_DU_DESCRIPTORS(
           DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
  	   DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
	   LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
	   CREATION_DATE)
        VALUES(
          HR_DU_DESCRIPTORS_S.nextval,
          p_upload_id,
          p_upload_header_id,
          'STARTING POINT',
          'NO',
          'D',
          sysdate,
          1,
          1,
          1,
          sysdate);

Line: 557

  SELECT VALUE
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'REFERENCING'
    AND UPLOAD_header_ID = p_upload_header_id;

Line: 580

    INSERT INTO HR_DU_DESCRIPTORS(
           DESCRIPTOR_ID, UPLOAD_ID, UPLOAD_HEADER_ID,
  	   DESCRIPTOR, VALUE, DESCRIPTOR_TYPE, LAST_UPDATE_DATE,
	   LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
	   CREATION_DATE)
        VALUES(
          HR_DU_DESCRIPTORS_S.nextval,
          p_upload_id,
          p_upload_header_id,
          'REFERENCING',
          'CP',
          'D',
          sysdate,
          1,
          1,
          1,
          sysdate);