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

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

Line: 28


             p_values_table IN hr_du_do_datapump.R_INSERT_STATEMENT_TYPE
            ,p_upload_id IN NUMBER
            ,p_batch_id IN NUMBER
            ,p_api_module_id IN NUMBER
            ,p_process_order IN NUMBER
            ,p_upload_line_id IN NUMBER
         ,p_api_name IN VARCHAR2
            ,p_pump_batch_line_id IN NUMBER)
IS

  e_fatal_error               EXCEPTION;

Line: 51


  l_insert_statement               VARCHAR2(32767);

Line: 56


   SELECT PVAl001
   FROM hr_du_upload_lines
   WHERE UPLOAD_LINE_ID = p_upload_line_id;

Line: 96


  hr_du_di_insert.g_current_delimiter   := ',';

Line: 98


  hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 103


  l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
                                 p_values_table.r_pval_parent_line_id);

Line: 120


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                               p_values_table.r_pval_parent_line_id );

Line: 123


      l_pval_parent_line_id :=  hr_du_di_insert.Return_Word(
                              p_values_table.r_pval_parent_line_id , j);

Line: 127


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                               p_values_table.r_parent_api_module_number);

Line: 130


      l_parent_api_module_number :=  hr_du_di_insert.Return_Word(
                             p_values_table.r_parent_api_module_number , j);

Line: 203


  l_insert_statement := 'insert into HRDPV_' || p_api_name || '(' ||
                   'BATCH_ID,           BATCH_LINE_ID, '||
                        'API_MODULE_ID, LINE_STATUS,   '||
                        'USER_SEQUENCE,      LINK_VALUE,    '||
                             l_foreign_user_key || ',';

Line: 209


  l_insert_statement := l_insert_statement || 'p_assignment_user_key, ' ;

Line: 211


  l_insert_statement := l_insert_statement || p_values_table.r_insert_string;

Line: 214


  l_insert_statement := l_insert_statement  || ')';

Line: 218


  l_insert_statement := l_insert_statement || 'select  ' ||
                   p_batch_id || ',' || p_pump_batch_line_id ||','||
                   p_api_module_id || ', ''U'',' ||
                   p_process_order || ',' || '1' || ',' ||
                            '''' ||l_parent_user_key || ''',' ||
                            '''' ||l_parent_user_key || ':ASG' || ''',';

Line: 225


  l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;

Line: 226


  l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
                            'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;

Line: 231


  hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

Line: 233


  hr_du_utility.dynamic_sql(l_insert_statement);

Line: 274


             p_values_table IN hr_du_do_datapump.R_INSERT_STATEMENT_TYPE
            ,p_upload_id IN NUMBER
            ,p_batch_id IN NUMBER
            ,p_api_module_id IN NUMBER
            ,p_process_order IN NUMBER
            ,p_upload_line_id IN NUMBER
         ,p_api_name IN VARCHAR2
            ,p_pump_batch_line_id IN NUMBER)
IS

  e_fatal_error               EXCEPTION;

Line: 297


  l_insert_statement               VARCHAR2(32767);

Line: 302


   SELECT PVAl001
   FROM hr_du_upload_lines
   WHERE UPLOAD_LINE_ID = p_upload_line_id;

Line: 343


  hr_du_di_insert.g_current_delimiter   := ',';

Line: 345


  hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 348


  l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
                                   p_values_table.r_pval_parent_line_id);

Line: 365


       hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 368


      l_pval_parent_line_id :=  hr_du_di_insert.Return_Word(
                               p_values_table.r_pval_parent_line_id , j);

Line: 372


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_parent_api_module_number);

Line: 375


      l_parent_api_module_number :=  hr_du_di_insert.Return_Word(
                                 p_values_table.r_parent_api_module_number, j);

Line: 379


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_api_module_number);

Line: 382


      l_pval_api_module_number :=  hr_du_di_insert.Return_Word(
                       p_values_table.r_pval_api_module_number , j);

Line: 449


  l_insert_statement := 'insert into HRDPV_' || p_api_name || '(' ||
                   'BATCH_ID,           BATCH_LINE_ID, '||
                        'API_MODULE_ID, LINE_STATUS,   '||
                        'USER_SEQUENCE,      LINK_VALUE,    '||
                             l_foreign_user_key || ',';

Line: 458


    l_insert_statement := l_insert_statement || l_foreign_user_key_2 || ',';

Line: 461


  l_insert_statement := l_insert_statement || p_values_table.r_insert_string;

Line: 464


  l_insert_statement := l_insert_statement  || ')';

Line: 468


  l_insert_statement := l_insert_statement || 'select  ' ||
                   p_batch_id || ',' || p_pump_batch_line_id ||','||
                   p_api_module_id || ', ''U'',' ||
                   p_process_order || ',' || '1' || ',' ||
                            '''' ||l_parent_user_key || ''',';

Line: 475


    l_insert_statement := l_insert_statement || '''' || l_parent_user_key_2 || ''',';

Line: 478


  l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;

Line: 480


  l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
                        'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;

Line: 485


  hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

Line: 487


  hr_du_utility.dynamic_sql(l_insert_statement);

Line: 530


PROCEDURE UPDATE_EMP_ASG_CRITERIA(
             p_values_table IN hr_du_do_datapump.R_INSERT_STATEMENT_TYPE
            ,p_upload_id IN NUMBER
            ,p_batch_id IN NUMBER
            ,p_api_module_id IN NUMBER
            ,p_process_order IN NUMBER
            ,p_upload_line_id IN NUMBER
         ,p_api_name IN VARCHAR2
            ,p_pump_batch_line_id IN NUMBER)
IS

  e_fatal_error               EXCEPTION;

Line: 554


  l_insert_statement               VARCHAR2(32767);

Line: 559


   SELECT PVAl001
   FROM hr_du_upload_lines
   WHERE UPLOAD_LINE_ID = p_upload_line_id;

Line: 567


                        'entry:hr_du_do_entities.update_emp_asg_criteria', 5);

Line: 597


  hr_du_di_insert.g_current_delimiter   := ',';

Line: 599


  hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 602


  l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
                                    p_values_table.r_pval_parent_line_id);

Line: 619


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 622


      l_pval_parent_line_id :=hr_du_di_insert.Return_Word(
                              p_values_table.r_pval_parent_line_id , j);

Line: 626


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_parent_api_module_number);

Line: 629


      l_parent_api_module_number := hr_du_di_insert.Return_Word(
                             p_values_table.r_parent_api_module_number, j);

Line: 633


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_api_module_number);

Line: 636


      l_pval_api_module_number :=  hr_du_di_insert.Return_Word(
                       p_values_table.r_pval_api_module_number , j);

Line: 707


  l_insert_statement := 'insert into HRDPV_' || p_api_name || '(' ||
                   'BATCH_ID,           BATCH_LINE_ID, '||
                        'API_MODULE_ID, LINE_STATUS,   '||
                        'USER_SEQUENCE,      LINK_VALUE,    '||
                             l_foreign_user_key || ',';

Line: 713


  l_insert_statement := l_insert_statement || p_values_table.r_insert_string;

Line: 716


  l_insert_statement := l_insert_statement  || ')';

Line: 720


  l_insert_statement := l_insert_statement || 'select  ' ||
                   p_batch_id || ',' || p_pump_batch_line_id || ',' ||
                   p_api_module_id || ', ''U'',' ||
                   p_process_order || ',' || '1' || ',' ||
                            '''' ||l_parent_user_key_2 || ':ASG' || ''',';

Line: 726


  l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;

Line: 727


  l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
                            'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;

Line: 731


  hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

Line: 733


  hr_du_utility.dynamic_sql(l_insert_statement);

Line: 736


  hr_du_utility.message('ROUT','exit:hr_du_do_entities.update_emp_asg_criteria', 100);

Line: 741


    hr_du_utility.error(SQLCODE,'hr_du_do_entities.update_emp_asg_criteria'
                        ,l_fatal_error_message, 'R');

Line: 745


    hr_du_utility.error(SQLCODE, 'hr_du_do_entities.update_emp_asg_criteria',
    '(none)', 'R');

Line: 750


END UPDATE_EMP_ASG_CRITERIA;

Line: 774


             p_values_table IN hr_du_do_datapump.R_INSERT_STATEMENT_TYPE
            ,p_upload_id IN NUMBER
            ,p_batch_id IN NUMBER
            ,p_api_module_id IN NUMBER
            ,p_process_order IN NUMBER
            ,p_upload_line_id IN NUMBER
         ,p_api_name IN VARCHAR2
            ,p_pump_batch_line_id IN NUMBER)
IS

  e_fatal_error               EXCEPTION;

Line: 797


  l_insert_statement               VARCHAR2(32767);

Line: 802


   SELECT PVAl001
   FROM hr_du_upload_lines
   WHERE UPLOAD_LINE_ID = p_upload_line_id;

Line: 835


  hr_du_di_insert.g_current_delimiter   := ',';

Line: 838


  hr_du_di_insert.g_delimiter_count := 0;

Line: 841


  l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
                                   p_values_table.r_pval_parent_line_id);

Line: 858


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_parent_line_id);

Line: 861


      l_pval_parent_line_id :=  hr_du_di_insert.Return_Word(
                               p_values_table.r_pval_parent_line_id , j);

Line: 864


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_parent_api_module_number);

Line: 866


      l_parent_api_module_number :=  hr_du_di_insert.Return_Word(
                                 p_values_table.r_parent_api_module_number, j);

Line: 869


      hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
                           p_values_table.r_pval_api_module_number);

Line: 872


      l_pval_api_module_number :=  hr_du_di_insert.Return_Word(
                       p_values_table.r_pval_api_module_number , j);

Line: 945


  l_insert_statement := 'insert into HRDPV_' || p_api_name || '(' ||
                   'BATCH_ID,           BATCH_LINE_ID, '||
                        'API_MODULE_ID, LINE_STATUS,   '||
                        'USER_SEQUENCE,      LINK_VALUE,    ';

Line: 953


    l_insert_statement := l_insert_statement || l_foreign_user_key_2 || ',';

Line: 956


  l_insert_statement := l_insert_statement || p_values_table.r_insert_string;

Line: 959


  l_insert_statement := l_insert_statement  || ')';

Line: 963


  l_insert_statement := l_insert_statement || 'select  ' ||
                   p_batch_id || ',' || p_pump_batch_line_id ||','||
                   p_api_module_id || ', ''U'',' ||
                   p_process_order || ',' || '1' || ',';

Line: 969


    l_insert_statement := l_insert_statement || '''' || l_parent_user_key_2 || ''',';

Line: 972


  l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;

Line: 974


  l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
                        'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;

Line: 977


  hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

Line: 981


  hr_du_utility.dynamic_sql(l_insert_statement);