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_DI_INSERT SQL Statements

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

Line: 25


  SELECT count (descriptor)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   upload_header_id = p_upload_header_id;

Line: 31


  SELECT count(distinct descriptor)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   upload_header_id = p_upload_header_id;

Line: 39


        'entry:hr_du_di_insert.validate_sheet_descriptors', 5);

Line: 74


                     'exit:hr_du_di_insert.validate_sheet_descriptors', 15);

Line: 79


                     'hr_du_di_insert.validate_sheet_descriptors',
                     l_fatal_error_message, 'R');

Line: 83


    hr_du_utility.error(SQLCODE,'hr_du_di_insert.validate_sheet_descriptors'
                     ,'(none)', 'R');

Line: 108


  SELECT count (descriptor)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   upload_header_id IS NULL;

Line: 115


  SELECT count(distinct descriptor)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   upload_header_id IS NULL;

Line: 123


                  'entry:hr_du_di_insert.validate_header_descriptors', 5);

Line: 154


                    'exit:hr_du_di_insert.validate_header_descriptors', 15);

Line: 159


                        'hr_du_di_insert.validate_header_descriptors',
                        l_fatal_error_message, 'R');

Line: 164


                       'hr_du_di_insert.validate_header_descriptors',
                       '(none)', 'R');

Line: 201


                        'entry:hr_du_di_insert.parse_line_to_table', 5);

Line: 272


                        'exit:hr_du_di_insert.parse_line_to_table', 15);

Line: 276


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',
                                  l_fatal_error_message, 'R');

Line: 280


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.parse_line_to_table',
                       '(none)', 'R');

Line: 305


  SELECT count (value)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   DESCRIPTOR_TYPE = 'F';

Line: 311


  SELECT count(distinct value)
    FROM  hr_du_descriptors
    WHERE upload_id = p_upload_id
    AND   DESCRIPTOR_TYPE = 'F';

Line: 319


                        'entry:hr_du_di_insert.check_unique_files', 5);

Line: 348


                        'exit:hr_du_di_insert.check_unique_files', 15);

Line: 352


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
                        l_fatal_error_message, 'R');

Line: 356


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.check_unique_files',
                       '(none)', 'R');

Line: 376


                        'entry:hr_du_di_insert.populate_dynamic_table', 5);

Line: 393


                        'exit:hr_du_di_insert.populate_dynamic_table', 15);

Line: 397


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.populate_dynamic_table',
                       '(none)', 'R');

Line: 416


  SELECT UPLOAD_LINE_ID
    FROM  hr_du_upload_lines
    WHERE upload_header_id = p_upload_header_id
    AND   LINE_TYPE = 'C';

Line: 422


  SELECT upper(des.value)
    FROM  hr_du_upload_headers head,
          hr_api_modules api,
          hr_du_descriptors des
    WHERE head.upload_header_id = p_upload_header_id
    AND   head.upload_header_id = des.upload_header_id
    AND   head.api_module_id = api.api_module_id
    AND   upper(api.module_name) = upper(des.value);

Line: 433


    Select count(PVAL001)
    FROM hr_du_upload_lines
    WHERE upload_header_id = p_upload_header_id;

Line: 438


    Select count(DISTINCT PVAL001)
    FROM hr_du_upload_lines
    WHERE upload_header_id = p_upload_header_id;

Line: 458


                        'entry:hr_du_di_insert.validate_api_ids', 5);

Line: 524


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate_api_ids', 15);

Line: 528


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
    l_fatal_error_message, 'R');

Line: 532


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate_api_ids',
                       '(none)', 'R');

Line: 561


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.set_delimiter_string',
                       '(none)', 'R');

Line: 609


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.num_delimiters',
                       '(none)', 'R');

Line: 647


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.words_on_line','(none)',
                        'R');

Line: 673


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

Line: 687


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.remove_garbage', 15);

Line: 696


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.remove_garbage','(none)',
                        'R');

Line: 726


  SELECT api.module_NAME
    FROM hr_api_modules api,
         hr_du_upload_headers head
    WHERE head.upload_header_id = p_upload_header_id
    AND   head.api_module_id = api.api_module_id;

Line: 734


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

Line: 770


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.next_line', 20);

Line: 789


                           'hr_du_di_insert.next_line','(none)', 'R');

Line: 840


    l_next := INSTRB(p_line, hr_du_di_insert.g_current_delimiter, 1, p_word_num);

Line: 848


      l_position := INSTRB(p_line, hr_du_di_insert.g_current_delimiter, 1, (p_word_num - 1));

Line: 862


    l_position := INSTRB(p_line, hr_du_di_insert.g_current_delimiter, 1, (p_word_num - 1));

Line: 863


    l_next := INSTRB(p_line, hr_du_di_insert.g_current_delimiter, 1, p_word_num);

Line: 874


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_word',
    l_fatal_error_message, 'R');

Line: 879


                        'hr_du_di_insert.return_word','(none)', 'R');

Line: 916


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

Line: 980


        hr_du_utility.message('INFO','Insert statement', 25);

Line: 981


        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,
          UPPER(l_Col_one),
          l_Col_two,
          p_descriptor_type,
          sysdate,
          1,
          1,
          1,
          sysdate);

Line: 1017


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.general_extract', 30);

Line: 1023


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.general_extract',
    l_fatal_error_message, 'R');

Line: 1028


                    'hr_du_di_insert.general_extract','(none)', 'R');

Line: 1054


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

Line: 1060


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_api_locations'
                        , 10);

Line: 1067


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_api_locations'
                        ,'(none)', 'R');

Line: 1093


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

Line: 1099


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_headers', 10);

Line: 1105


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_headers',
                        '(none)', 'R');

Line: 1136


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

Line: 1154


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_descriptors',
                        10);

Line: 1165


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.extract_descriptors',
                      '(none)', 'R');

Line: 1191


  SELECT des.descriptor_id, api.api_module_id, upper(api.module_NAME),
         des.VALUE
    FROM hr_api_modules api,
         hr_du_descriptors des
    WHERE upper(api.module_NAME) = upper(des.DESCRIPTOR)
      AND   des.DESCRIPTOR_TYPE = 'F'
      AND   des.upload_id = p_upload_id;

Line: 1203


  SELECT des.DESCRIPTOR
  FROM hr_du_descriptors des
  WHERE des.DESCRIPTOR_TYPE = 'F'
    AND   des.upload_id = p_upload_id
    AND upper(des.DESCRIPTOR) NOT IN (	SELECT upper(des.DESCRIPTOR)
    				FROM hr_api_modules api,
         			     hr_du_descriptors des
				WHERE upper(api.module_NAME) =
                                      upper(des.DESCRIPTOR)
      				  AND des.DESCRIPTOR_TYPE = 'F'
    				  AND des.upload_id = p_upload_id);

Line: 1231


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

Line: 1235


  g_header_table.delete;

Line: 1245


  Update_Upload_table(p_upload_id);

Line: 1251


    SELECT HR_DU_UPLOAD_HEADERS_S.nextval
      INTO l_upload_header_id
      FROM dual;

Line: 1256


    hr_du_utility.message('INFO','Insert statement', 15);

Line: 1258


    INSERT INTO HR_DU_UPLOAD_HEADERS(
      UPLOAD_HEADER_ID, UPLOAD_ID, API_MODULE_ID, STATUS,
      LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
      CREATED_BY, CREATION_DATE)
    VALUES(
      l_upload_header_id,
      p_upload_id,
      l_file_record.API_MODULE_ID,
      'NS',
      sysdate,
      1,
      1,
      1,
      sysdate);

Line: 1301


        UPDATE hr_du_descriptors
        SET    value = NULL
        WHERE  upload_header_id = l_original_upload_header_id
	AND    descriptor = 'API';

Line: 1332


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.handle_api_files', 30);

Line: 1338


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',
                                  l_fatal_error_message, 'R');

Line: 1342


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.handle_api_files',
                        '(none)', 'R');

Line: 1357


PROCEDURE UPDATE_UPLOAD_TABLE (p_upload_id IN NUMBER)
IS

  e_fatal_error 		EXCEPTION;

Line: 1371


  SELECT VALUE
    FROM hr_du_descriptors
    WHERE DESCRIPTOR = 'BUSINESS GROUP'
    AND UPLOAD_ID = p_upload_id;

Line: 1378


  SELECT VALUE
    FROM hr_du_descriptors
    WHERE DESCRIPTOR = 'GLOBAL DATA'
    AND UPLOAD_ID = p_upload_id;

Line: 1385


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

Line: 1392


  SELECT NAME
    FROM per_business_groups
    WHERE BUSINESS_GROUP_ID = l_business_group_id;

Line: 1399


                       'entry:hr_du_di_insert.update_upload_table', 5);

Line: 1452


  UPDATE hr_du_uploads
  SET   BUSINESS_GROUP_NAME = l_business_group_name
  WHERE UPLOAD_ID = p_upload_id;

Line: 1457


  UPDATE hr_du_descriptors
  SET   VALUE = l_business_group_name
  WHERE DESCRIPTOR = 'BUSINESS GROUP'
    AND UPLOAD_ID = p_upload_id;

Line: 1464


    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,
          null,
          'BUSINESS GROUP',
          l_business_group_name,
          'D',
          sysdate,
          1,
          1,
          1,
          sysdate);

Line: 1481


    hr_du_utility.message('INFO','Row inserted into descriptors table', 15);

Line: 1484


    hr_du_utility.message('INFO','Row updated in descriptors table', 20);

Line: 1489


                        'exit:hr_du_di_insert.update_upload_table', 25);

Line: 1495


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',
                        l_fatal_error_message, 'R');

Line: 1499


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.update_upload_table',
                        '(none)', 'R');

Line: 1503


END UPDATE_UPLOAD_TABLE;

Line: 1519


  SELECT SOURCE
  FROM hr_du_uploads
  WHERE UPLOAD_ID = p_upload_id;

Line: 1529


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

Line: 1542


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.return_file_name', 15);

Line: 1551


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',
                        l_fatal_error_message, 'R');

Line: 1555


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.return_file_name',
                        '(none)', 'R');

Line: 1579


SELECT value
FROM v$parameter
WHERE name='utl_file_dir';

Line: 1589


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

Line: 1608


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.open_file', 15);

Line: 1615


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.Open_file',
           ' ERROR Opening - ' || p_file_name ||
           '. File may not exist or spelt incorrectly', 'R');

Line: 1669


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

Line: 1799


          hr_du_utility.message('INFO','Insert Statement Start ' , 25);

Line: 1801


          INSERT INTO hr_du_upload_lines(
  	    UPLOAD_LINE_ID, UPLOAD_HEADER_ID, BATCH_LINE_ID,
  	    STATUS, REFERENCE_TYPE, LINE_TYPE, LAST_UPDATE_DATE,
            LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
            CREATION_DATE, DI_LINE_NUMBER, ORIGINAL_UPLOAD_HEADER_ID,
 	    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 )
          VALUES(
  	    HR_DU_UPLOAD_LINES_S.nextval, p_upload_header_id, null, 'NS',
  	    p_reference_type, l_line_type, sysdate,
	    1, 1, 1, sysdate, g_counter, p_original_upload_header_id,
 	    g_line_table(1), g_line_table(2), g_line_table(3),
     	    g_line_table(4), g_line_table(5), g_line_table(6),
 	    g_line_table(7), g_line_table(8), g_line_table(9),
 	    g_line_table(10), g_line_table(11), g_line_table(12),
 	    g_line_table(13), g_line_table(14), g_line_table(15),
 	    g_line_table(16), g_line_table(17), g_line_table(18),
 	    g_line_table(19), g_line_table(20), g_line_table(21),
 	    g_line_table(22), g_line_table(23), g_line_table(24),
 	    g_line_table(25), g_line_table(26), g_line_table(27),
 	    g_line_table(28), g_line_table(29), g_line_table(30),
 	    g_line_table(31), g_line_table(32), g_line_table(33),
 	    g_line_table(34), g_line_table(35), g_line_table(36),
 	    g_line_table(37), g_line_table(38), g_line_table(39),
 	    g_line_table(40), g_line_table(41), g_line_table(42),
 	    g_line_table(43), g_line_table(44), g_line_table(45),
 	    g_line_table(46), g_line_table(47), g_line_table(48),
 	    g_line_table(49), g_line_table(50), g_line_table(51),
 	    g_line_table(52), g_line_table(53), g_line_table(54),
 	    g_line_table(55), g_line_table(56), g_line_table(57),
 	    g_line_table(58), g_line_table(59), g_line_table(60),
 	    g_line_table(61), g_line_table(62), g_line_table(63),
 	    g_line_table(64), g_line_table(65), g_line_table(66),
 	    g_line_table(67), g_line_table(68), g_line_table(69),
 	    g_line_table(70), g_line_table(71), g_line_table(72),
 	    g_line_table(73), g_line_table(74), g_line_table(75),
 	    g_line_table(76), g_line_table(77), g_line_table(78),
 	    g_line_table(79), g_line_table(80), g_line_table(81),
 	    g_line_table(82), g_line_table(83), g_line_table(84),
 	    g_line_table(85), g_line_table(86), g_line_table(87),
 	    g_line_table(88), g_line_table(89), g_line_table(90),
 	    g_line_table(91), g_line_table(92), g_line_table(93),
 	    g_line_table(94), g_line_table(95), g_line_table(96),
 	    g_line_table(97), g_line_table(98), g_line_table(99),
 	    g_line_table(100),g_line_table(101),g_line_table(102),
 	    g_line_table(103),g_line_table(104),g_line_table(105),
 	    g_line_table(106),g_line_table(107),g_line_table(108),
 	    g_line_table(109),g_line_table(110),g_line_table(111),
 	    g_line_table(112),g_line_table(113),g_line_table(114),
 	    g_line_table(115),g_line_table(116),g_line_table(117),
 	    g_line_table(118),g_line_table(119),g_line_table(120),
 	    g_line_table(121),g_line_table(122),g_line_table(123),
 	    g_line_table(124),g_line_table(125),g_line_table(126),
 	    g_line_table(127),g_line_table(128),g_line_table(129),
 	    g_line_table(130),g_line_table(131),g_line_table(132),
 	    g_line_table(133),g_line_table(134),g_line_table(135),
 	    g_line_table(136),g_line_table(137),g_line_table(138),
 	    g_line_table(139),g_line_table(140),g_line_table(141),
 	    g_line_table(142),g_line_table(143),g_line_table(144),
 	    g_line_table(145),g_line_table(146),g_line_table(147),
 	    g_line_table(148),g_line_table(149),g_line_table(150),
 	    g_line_table(151),g_line_table(152),g_line_table(153),
 	    g_line_table(154),g_line_table(155),g_line_table(156),
 	    g_line_table(157),g_line_table(158),g_line_table(159),
 	    g_line_table(160),g_line_table(161),g_line_table(162),
 	    g_line_table(163),g_line_table(164),g_line_table(165),
 	    g_line_table(166),g_line_table(167),g_line_table(168),
 	    g_line_table(169),g_line_table(170),g_line_table(171),
 	    g_line_table(172),g_line_table(173),g_line_table(174),
 	    g_line_table(175),g_line_table(176),g_line_table(177),
 	    g_line_table(178),g_line_table(179),g_line_table(180),
 	    g_line_table(181),g_line_table(182),g_line_table(183),
 	    g_line_table(184),g_line_table(185),g_line_table(186),
 	    g_line_table(187),g_line_table(188),g_line_table(189),
 	    g_line_table(190),g_line_table(191),g_line_table(192),
 	    g_line_table(193),g_line_table(194),g_line_table(195),
 	    g_line_table(196),g_line_table(197),g_line_table(198),
 	    g_line_table(199),g_line_table(200),g_line_table(201),
 	    g_line_table(202),g_line_table(203),g_line_table(204),
 	    g_line_table(205),g_line_table(206),g_line_table(207),
 	    g_line_table(208),g_line_table(209),g_line_table(210),
 	    g_line_table(211),g_line_table(212),g_line_table(213),
 	    g_line_table(214),g_line_table(215),g_line_table(216),
 	    g_line_table(217),g_line_table(218),g_line_table(219),
 	    g_line_table(220),g_line_table(221),g_line_table(222),
 	    g_line_table(223),g_line_table(224),g_line_table(225),
 	    g_line_table(226),g_line_table(227),g_line_table(228),
 	    g_line_table(229),g_line_table(230));

Line: 1936


      hr_du_utility.message('INFO','Insert Statement End ' , 30);

Line: 1949


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_lines', 35);

Line: 1956


               'hr_du_di_insert.extract_lines',l_fatal_error_message, 'R');

Line: 1960


               'hr_du_di_insert.extract_lines','(none)', 'R');

Line: 1987


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

Line: 2009


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.ordered_sequence', 15);

Line: 2016


                        'hr_du_di_insert.ordered_sequence','(none)', 'R');

Line: 2035


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

Line: 2041


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.validate', 15);

Line: 2047


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.validate',
                       '(none)', 'R');

Line: 2067


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

Line: 2072


  DELETE FROM HR_DU_DESCRIPTORS
  WHERE UPLOAD_ID = p_upload_id;

Line: 2076


  DELETE FROM HR_DU_UPLOAD_LINES
  WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
   			     FROM hr_du_upload_headers
			     WHERE upload_id = p_upload_id);

Line: 2082


  DELETE FROM HR_DU_UPLOAD_HEADERS
  WHERE UPLOAD_ID = p_upload_id;

Line: 2087


  hr_du_utility.message('ROUT','exit:hr_du_di_insert.rollback', 15);

Line: 2093


    hr_du_utility.error(SQLCODE, 'hr_du_di_insert.rollback',
                       '(none)', 'R');