eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DU_DO_DATAPUMP SQL Statements

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

Line: 22


  hr_du_utility.message('INFO','Select Statement Start ' , 15);

Line: 24


        SELECT
 	  PVAL001, PVAL002, PVAL003,  PVAL004 , PVAL005 , PVAL006,
 	  PVAL007, PVAL008, PVAL009,  PVAL010 , PVAL011, PVAL012,
 	  PVAL013, PVAL014, PVAL015,  PVAL016 , PVAL017,  PVAL018,
 	  PVAL019,  PVAL020,  PVAL021, PVAL022,  PVAL023,  PVAL024,
 	  PVAL025,  PVAL026,  PVAL027, PVAL028,  PVAL029,  PVAL030,
 	  PVAL031,  PVAL032,  PVAL033, PVAL034,  PVAL035,  PVAL036,
 	  PVAL037,  PVAL038,  PVAL039, PVAL040,  PVAL041,  PVAL042,
 	  PVAL043,  PVAL044,  PVAL045, PVAL046,  PVAL047,  PVAL048,
 	  PVAL049,  PVAL050,  PVAL051, PVAL052,  PVAL053,  PVAL054,
 	  PVAL055,  PVAL056,  PVAL057, PVAL058,  PVAL059,  PVAL060,
 	  PVAL061,  PVAL062,  PVAL063, PVAL064,  PVAL065,  PVAL066,
 	  PVAL067,  PVAL068,  PVAL069, PVAL070,  PVAL071,  PVAL072,
 	  PVAL073,  PVAL074,  PVAL075, PVAL076,  PVAL077,  PVAL078,
 	  PVAL079,  PVAL080,  PVAL081, PVAL082,  PVAL083,  PVAL084,
 	  PVAL085,  PVAL086,  PVAL087, PVAL088,  PVAL089,  PVAL090,
 	  PVAL091,  PVAL092,  PVAL093, PVAL094,  PVAL095,  PVAL096,
 	  PVAL097,  PVAL098,  PVAL099, PVAL100, PVAL101, PVAL102,
 	  PVAL103, PVAL104, PVAL105,PVAL106, PVAL107, PVAL108,
 	  PVAL109, PVAL110, PVAL111,PVAL112, PVAL113, PVAL114,
 	  PVAL115, PVAL116, PVAL117,PVAL118, PVAL119, PVAL120,
 	  PVAL121, PVAL122, PVAL123,PVAL124, PVAL125, PVAL126,
 	  PVAL127, PVAL128, PVAL129,PVAL130, PVAL131, PVAL132,
 	  PVAL133, PVAL134, PVAL135,PVAL136, PVAL137, PVAL138,
 	  PVAL139, PVAL140, PVAL141,PVAL142, PVAL143, PVAL144,
 	  PVAL145, PVAL146, PVAL147,PVAL148, PVAL149, PVAL150,
 	  PVAL151, PVAL152, PVAL153,PVAL154, PVAL155, PVAL156,
 	  PVAL157, PVAL158, PVAL159,PVAL160, PVAL161, PVAL162,
 	  PVAL163, PVAL164, PVAL165,PVAL166, PVAL167, PVAL168,
 	  PVAL169, PVAL170, PVAL171,PVAL172, PVAL173, PVAL174,
 	  PVAL175, PVAL176, PVAL177,PVAL178, PVAL179, PVAL180,
 	  PVAL181, PVAL182, PVAL183,PVAL184, PVAL185, PVAL186,
 	  PVAL187, PVAL188, PVAL189,PVAL190, PVAL191, PVAL192,
 	  PVAL193, PVAL194, PVAL195,PVAL196, PVAL197, PVAL198,
 	  PVAL199, PVAL200, PVAL201,PVAL202, PVAL203, PVAL204,
 	  PVAL205, PVAL206, PVAL207,PVAL208, PVAL209, PVAL210,
 	  PVAL211, PVAL212, PVAL213,PVAL214, PVAL215, PVAL216,
  	  PVAL217, PVAL218, PVAL219,PVAL220, PVAL221, PVAL222,
 	  PVAL223, PVAL224, PVAL225,PVAL226, PVAL227, PVAL228,
 	  PVAL229, PVAL230
        INTO
 	  g_column_headings(1), g_column_headings(2), g_column_headings(3),
     	  g_column_headings(4), g_column_headings(5), g_column_headings(6),
 	  g_column_headings(7), g_column_headings(8), g_column_headings(9),
 	  g_column_headings(10), g_column_headings(11), g_column_headings(12),
 	  g_column_headings(13), g_column_headings(14), g_column_headings(15),
 	  g_column_headings(16), g_column_headings(17), g_column_headings(18),
 	  g_column_headings(19), g_column_headings(20), g_column_headings(21),
 	  g_column_headings(22), g_column_headings(23), g_column_headings(24),
 	  g_column_headings(25), g_column_headings(26), g_column_headings(27),
 	  g_column_headings(28), g_column_headings(29), g_column_headings(30),
 	  g_column_headings(31), g_column_headings(32), g_column_headings(33),
 	  g_column_headings(34), g_column_headings(35), g_column_headings(36),
 	  g_column_headings(37), g_column_headings(38), g_column_headings(39),
 	  g_column_headings(40), g_column_headings(41), g_column_headings(42),
 	  g_column_headings(43), g_column_headings(44), g_column_headings(45),
 	  g_column_headings(46), g_column_headings(47), g_column_headings(48),
 	  g_column_headings(49), g_column_headings(50), g_column_headings(51),
 	  g_column_headings(52), g_column_headings(53), g_column_headings(54),
 	  g_column_headings(55), g_column_headings(56), g_column_headings(57),
 	  g_column_headings(58), g_column_headings(59), g_column_headings(60),
 	  g_column_headings(61), g_column_headings(62), g_column_headings(63),
 	  g_column_headings(64), g_column_headings(65), g_column_headings(66),
 	  g_column_headings(67), g_column_headings(68), g_column_headings(69),
 	  g_column_headings(70), g_column_headings(71), g_column_headings(72),
 	  g_column_headings(73), g_column_headings(74), g_column_headings(75),
 	  g_column_headings(76), g_column_headings(77), g_column_headings(78),
 	  g_column_headings(79), g_column_headings(80), g_column_headings(81),
 	  g_column_headings(82), g_column_headings(83), g_column_headings(84),
 	  g_column_headings(85), g_column_headings(86), g_column_headings(87),
 	  g_column_headings(88), g_column_headings(89), g_column_headings(90),
 	  g_column_headings(91), g_column_headings(92), g_column_headings(93),
 	  g_column_headings(94), g_column_headings(95), g_column_headings(96),
 	  g_column_headings(97), g_column_headings(98), g_column_headings(99),
 	  g_column_headings(100),g_column_headings(101),g_column_headings(102),
 	  g_column_headings(103),g_column_headings(104),g_column_headings(105),
 	  g_column_headings(106),g_column_headings(107),g_column_headings(108),
 	  g_column_headings(109),g_column_headings(110),g_column_headings(111),
 	  g_column_headings(112),g_column_headings(113),g_column_headings(114),
 	  g_column_headings(115),g_column_headings(116),g_column_headings(117),
 	  g_column_headings(118),g_column_headings(119),g_column_headings(120),
 	  g_column_headings(121),g_column_headings(122),g_column_headings(123),
 	  g_column_headings(124),g_column_headings(125),g_column_headings(126),
 	  g_column_headings(127),g_column_headings(128),g_column_headings(129),
 	  g_column_headings(130),g_column_headings(131),g_column_headings(132),
 	  g_column_headings(133),g_column_headings(134),g_column_headings(135),
 	  g_column_headings(136),g_column_headings(137),g_column_headings(138),
 	  g_column_headings(139),g_column_headings(140),g_column_headings(141),
 	  g_column_headings(142),g_column_headings(143),g_column_headings(144),
 	  g_column_headings(145),g_column_headings(146),g_column_headings(147),
 	  g_column_headings(148),g_column_headings(149),g_column_headings(150),
 	  g_column_headings(151),g_column_headings(152),g_column_headings(153),
 	  g_column_headings(154),g_column_headings(155),g_column_headings(156),
 	  g_column_headings(157),g_column_headings(158),g_column_headings(159),
 	  g_column_headings(160),g_column_headings(161),g_column_headings(162),
 	  g_column_headings(163),g_column_headings(164),g_column_headings(165),
 	  g_column_headings(166),g_column_headings(167),g_column_headings(168),
 	  g_column_headings(169),g_column_headings(170),g_column_headings(171),
 	  g_column_headings(172),g_column_headings(173),g_column_headings(174),
 	  g_column_headings(175),g_column_headings(176),g_column_headings(177),
 	  g_column_headings(178),g_column_headings(179),g_column_headings(180),
 	  g_column_headings(181),g_column_headings(182),g_column_headings(183),
 	  g_column_headings(184),g_column_headings(185),g_column_headings(186),
 	  g_column_headings(187),g_column_headings(188),g_column_headings(189),
 	  g_column_headings(190),g_column_headings(191),g_column_headings(192),
 	  g_column_headings(193),g_column_headings(194),g_column_headings(195),
 	  g_column_headings(196),g_column_headings(197),g_column_headings(198),
 	  g_column_headings(199),g_column_headings(200),g_column_headings(201),
 	  g_column_headings(202),g_column_headings(203),g_column_headings(204),
 	  g_column_headings(205),g_column_headings(206),g_column_headings(207),
 	  g_column_headings(208),g_column_headings(209),g_column_headings(210),
 	  g_column_headings(211),g_column_headings(212),g_column_headings(213),
 	  g_column_headings(214),g_column_headings(215),g_column_headings(216),
 	  g_column_headings(217),g_column_headings(218),g_column_headings(219),
 	  g_column_headings(220),g_column_headings(221),g_column_headings(222),
 	  g_column_headings(223),g_column_headings(224),g_column_headings(225),
 	  g_column_headings(226),g_column_headings(227),g_column_headings(228),
 	  g_column_headings(229),g_column_headings(230)
    FROM HR_DU_UPLOAD_LINES
    WHERE UPLOAD_LINE_ID = p_line_id;

Line: 145


  hr_du_utility.message('INFO','Select Statement Ends ' , 20);

Line: 178


  SELECT mapped_to_name
  FROM   hr_du_column_mappings
  WHERE  API_MODULE_ID = p_api_module_id
  AND    MAPPING_TYPE = 'U';

Line: 239


  SELECT des2.value
  FROM hr_du_descriptors des1,
       hr_du_descriptors des2,
       hr_api_modules api
  WHERE des1.upload_id = p_upload_id
    and upper(des1.descriptor) = 'API'
    and upper(des2.descriptor) = 'PROCESS ORDER'
    and des2.descriptor_type = 'D'
    and des1.upload_header_id = des2.upload_header_id
    and api.api_module_id = p_api_module_id
    and upper(des1.value) = api.module_name;

Line: 320


  SELECT mapped_to_name
    FROM hr_du_column_mappings
    WHERE api_module_id = p_api_module_id
    AND   mapping_type = 'D'
    AND   column_name = p_user_key;

Line: 406


  SELECT mapped_to_name
    FROM hr_du_column_mappings
    WHERE api_module_id = p_api_module_id
    AND   mapping_type = p_mapping_type
    AND   column_name = p_pval_field
    AND   PARENT_api_module_ID IS NULL
    AND   PARENT_TABLE IS NULL;

Line: 463


  UPDATE hr_du_upload_lines
  SET status = 'NS'
  WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
                             FROM hr_du_upload_headers
                             WHERE upload_id = p_upload_id)
  AND (REFERENCE_TYPE = 'CP' OR LINE_TYPE = 'C');

Line: 530


   SELECT line.UPLOAD_LINE_ID
   FROM   hr_du_upload_headers head,
          hr_du_upload_lines   line
   WHERE  head.upload_id = p_upload_id
    AND    head.api_module_id = p_api_module_id
    AND    line.upload_header_id = head.upload_header_id
    AND    line.PVAL001 = to_char(p_column_id);

Line: 600


    hr_du_di_insert.g_current_delimiter   := ':';

Line: 602


    hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                    g_values_table(l_array_pos).r_user_key_pval);

Line: 605


    l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
                     g_values_table(l_array_pos).r_user_key_pval);

Line: 612


        l_single_key := hr_du_di_insert.Return_Word(
                         g_values_table(l_array_pos).r_user_key_pval, j);

Line: 619


          hr_du_di_insert.g_current_delimiter   := '%';

Line: 621


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

Line: 623


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

Line: 755


  hr_du_di_insert.g_current_delimiter   := ':';

Line: 757


  hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                     g_values_table(l_array_pos).r_user_key_pval);

Line: 760


  l_number_keys := hr_du_di_insert.WORDS_ON_LINE(
                   g_values_table(l_array_pos).r_user_key_pval);

Line: 767


       l_single_key := hr_du_di_insert.Return_Word(
                      g_values_table(l_array_pos).r_user_key_pval, j);

Line: 774


        hr_du_di_insert.g_current_delimiter   := '%';

Line: 776


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

Line: 779


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

Line: 873


 hr_du_di_insert.g_current_delimiter   := ',';

Line: 875


  hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                      g_values_table(p_table_pos).r_insert_string);

Line: 878


  l_number_names := hr_du_di_insert.WORDS_ON_LINE(
                    g_values_table(p_table_pos).r_insert_string);

Line: 883


    hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                       g_values_table(p_table_pos).r_insert_string);

Line: 886


    l_single_name := hr_du_di_insert.Return_Word(
                     g_values_table(p_table_pos).r_insert_string, j);

Line: 891


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                      g_values_table(p_table_pos).r_PVAL_string);

Line: 894


      l_pval:= hr_du_di_insert.Return_Word(
               g_values_table(p_table_pos).r_PVAL_string, j);

Line: 945


    SELECT VALUE
    INTO l_business_group
    FROM HR_DU_DESCRIPTORS
    WHERE DESCRIPTOR = 'BUSINESS GROUP'
    AND upload_id = p_upload_id;

Line: 995


    SELECT descr.VALUE
    FROM HR_DU_DESCRIPTORS descr,
         HR_DU_UPLOAD_HEADERS head
    WHERE head.upload_id = p_upload_id
    AND   head.api_module_id = g_values_table(p_table_id).r_api_id
    AND   head.upload_header_id = descr.upload_header_id
    AND   descr.DESCRIPTOR = 'USER KEY';

Line: 1078


  SELECT des.VALUE
  FROM 	 hr_du_descriptors des,
         hr_du_uploads 	   uplo
  WHERE  uplo.upload_id = p_upload_id
    AND  uplo.upload_id = des.upload_id
    AND  des.upload_header_id IS NULL
    AND  upper(des.descriptor) = upper(l_single_key);

Line: 1089


  SELECT des.VALUE
  FROM 	 hr_du_descriptors     des,
         hr_du_upload_headers  head
  WHERE  head.api_module_id = l_api_id
    AND  head.upload_id = p_upload_id
    AND  head.upload_header_id = des.upload_header_id
    AND  upper(des.descriptor) = upper(l_single_key);

Line: 1099


  SELECT VALUE
  FROM   hr_du_descriptors
  WHERE  upload_header_id = l_upload_header_id
    AND  upper(descriptor) = 'REFERENCING';

Line: 1106


  SELECT VALUE
  FROM   hr_du_descriptors
  WHERE  upload_header_id = l_upload_header_id
    AND  upper(descriptor) = 'STARTING POINT';

Line: 1130


    hr_du_di_insert.g_current_delimiter   := ':';

Line: 1132


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

Line: 1134


    l_number_keys := hr_du_di_insert.WORDS_ON_LINE(l_user_key);

Line: 1138


      hr_du_di_insert.g_current_delimiter   := ':';

Line: 1140


      l_single_key := hr_du_di_insert.Return_Word(l_user_key, j);

Line: 1170


        hr_du_di_insert.g_current_delimiter   := '%';

Line: 1171


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

Line: 1173


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

Line: 1180


          hr_du_di_insert.g_current_delimiter   := '$';

Line: 1181


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

Line: 1184


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

Line: 1314


  SELECT line.UPLOAD_LINE_ID
    FROM hr_du_upload_headers head,
         hr_du_upload_lines   line
    WHERE head.upload_id = p_upload_id
    AND   head.api_module_id = p_api_module_id
    AND   line.upload_header_id = head.upload_header_id
    AND   line.LINE_TYPE = 'C';

Line: 1381


  g_values_table(p_array_pos).r_insert_string   := l_pvalues_string;

Line: 1416


  SELECT api.api_module_id, des1.upload_header_id
  FROM   hr_du_descriptors des2,
         hr_api_modules api,
         hr_du_descriptors des1
  WHERE  des2.upload_id = p_upload_id
    AND  upper(des2.descriptor) = 'PROCESS ORDER'
    AND  des2.DESCRIPTOR_TYPE = 'D'
    AND  upper(api.module_name) = upper(des1.VALUE)
    AND  des1.DESCRIPTOR_TYPE = 'D'
    AND  des1.upload_header_id = des2.upload_header_id
    AND  upper(api.module_name) = upper(des1.VALUE)
  ORDER BY des2.value;

Line: 1523


  SELECT parent_api_module_id
  FROM hr_du_column_mappings
  WHERE mapping_type = 'D'
  AND parent_api_module_id IS NOT null
  AND column_name = l_pval_field;

Line: 1534


  SELECT parent_table
  FROM hr_du_column_mappings
  WHERE mapping_type = 'D'
  AND parent_table is not null
  AND column_name = l_pval_field;

Line: 1674


  SELECT line.UPLOAD_LINE_ID
    FROM hr_du_upload_headers head,
         hr_du_upload_lines   line
    WHERE head.upload_id = p_upload_id
    AND   head.api_module_id = p_api_module_id
    AND   line.upload_header_id = head.upload_header_id
    AND   line.LINE_TYPE = 'C';

Line: 1741


  SELECT line.UPLOAD_LINE_ID
    FROM hr_du_upload_headers head,
         hr_du_upload_lines   line
    WHERE head.upload_id = p_upload_id
    AND   line.upload_header_id = head.upload_header_id
    AND   line.REFERENCE_TYPE = 'CP';

Line: 1805


  SELECT batch_line_id, line_status
  FROM   hr_pump_batch_lines
  WHERE  batch_id = l_batch_id;

Line: 1816


  UPDATE hr_du_upload_lines
  SET status = 'NS'
  WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
                             FROM hr_du_upload_headers
                             WHERE upload_id = p_upload_id)
  AND status = 'S';

Line: 1823


  SELECT BATCH_ID
    INTO l_batch_id
    FROM hr_du_uploads
    WHERE upload_id = p_upload_id;

Line: 1829


  DELETE FROM  hr_pump_batch_exceptions
  WHERE        source_id = l_batch_id
  AND	source_type = 'BATCH_HEADER';

Line: 1841


        DELETE FROM hr_pump_batch_exceptions
          WHERE 	source_id = l_batch_line
	  AND	source_type = 'BATCH_LINE';

Line: 1846


      DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS
      where BATCH_LINE_ID = l_batch_line;

Line: 1852


  DELETE FROM hr_pump_batch_lines
  WHERE	batch_id = l_batch_id;

Line: 1856


  DELETE FROM hr_pump_ranges
  where batch_id = l_batch_id;

Line: 1860


  DELETE FROM hr_pump_requests
  WHERE BATCH_ID = l_batch_id;

Line: 1864


  UPDATE hr_du_uploads
  SET batch_id = null
  WHERE upload_id = p_upload_id;

Line: 1869


  DELETE FROM hr_pump_batch_headers
  WHERE BATCH_ID = l_batch_id;

Line: 1923


  SELECT VALUE
    FROM hr_du_descriptors
    WHERE upper(DESCRIPTOR) = 'BATCH NAME'
    AND UPLOAD_ID = p_upload_id;

Line: 1930


  SELECT line.upload_line_id, line.upload_header_id
  FROM   hr_du_upload_lines     line,
         hr_du_upload_headers   head
  WHERE   head.upload_id = p_upload_id
   AND    head.api_module_id = l_api_module_id
   AND    line.upload_header_id = head.upload_header_id
   AND    line.status = 'NS'
   AND    line.reference_type = 'CP'
   AND    line.line_type = 'D';

Line: 1950


  g_values_table.DELETE;

Line: 1951


  g_column_headings.DELETE;

Line: 1952


  g_user_key_table.DELETE;

Line: 2005


  UPDATE hr_du_uploads
  SET batch_id = l_batch_id
  WHERE upload_id = p_upload_id;

Line: 2072


      Select hr_pump_batch_lines_s.nextval
      INTO l_pump_batch_line_id
      FROM dual;

Line: 2077


      UPDATE hr_du_upload_lines
      SET    status = 'S'
      WHERE  upload_line_id = l_upload_line_id;

Line: 2091


      ELSIF upper(l_api_name) = 'UPDATE_EMP_ASG_CRITERIA' THEN
        hr_du_do_entities.UPDATE_EMP_ASG_CRITERIA(g_values_table(i),
                          p_upload_id, l_batch_id, l_api_module_id,
                          l_process_order, l_upload_line_id, l_api_name_thirty,
                          l_pump_batch_line_id);

Line: 2108


      UPDATE hr_du_upload_lines
      SET    status = 'C',
             batch_line_id = l_pump_batch_line_id
      WHERE  upload_line_id = l_upload_line_id;