APPS.JTF_RS_IMPORT_USER_PUB SQL Statements

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

Line: 46

      select column1, column2, column3, column4, column5, column6, column7, column8,
             column9, column10, column11, column12, column13, record_no
      from jtf_rs_upload_data
      where transaction_no = p_transaction_no;

Line: 52

      select employee_id
      from fnd_user
      where user_name = p_mgr_user_name;

Line: 57

      select 1 from fnd_user
      where user_name = l_user_name;

Line: 61

      select user_id from fnd_user
      where user_name = l_mgr_user_name;

Line: 65

      select resource_id
      from jtf_rs_resource_extns
      where user_id = l_mgr_user_id;

Line: 70

      select app_family_id
      from jtf_iapp_families_vl
      where app_family_display_name = l_nav_group;

Line: 75

      select responsibility_id
      from fnd_responsibility_vl
      where responsibility_name = l_resp_group;

Line: 81

      select 1 from jtf_iapp_families_b jif, fnd_responsibility fr,
                    jtf_iapp_family_app_map jpm
      where jif.app_family_id = jpm.app_family_id
        and jpm.application_id = fr.application_id
        and fr.responsibility_id = l_responsibility_id
        and jif.app_family_id = l_app_family_id;

Line: 89

      select method_of_generation_emp_num
      from per_business_groups
      where business_group_id =l_business_group_id;

Line: 94

      select group_id
      from jtf_rs_groups_vl
      where group_name = l_resource_group;

Line: 99

      select role_id, role_code
      from jtf_rs_roles_vl
      where role_name = l_role_name;

Line: 104

      select user_id
      from fnd_user
      where user_name = l_user_name;

Line: 497

          Fnd_User_Resp_Groups_Api.Insert_Assignment(
              l_user_id,
              l_responsibility_id1,
              690,
              0,
              trunc(sysdate),
              null,
              null
          );

Line: 509

             Fnd_User_Resp_Groups_Api.Insert_Assignment(
                 l_user_id,
                 l_responsibility_id2,
                 690,
                 0,
                 trunc(sysdate),
                 null,
                 null
             );

Line: 548

          update_upload_data (
            P_TRANSACTION_NO  => p_transaction_no,
            P_RECORD_NO       => l_record_no,
            P_PROCESS_STATUS  => 'U',
            P_ERROR_TEXT      => l_error_text
          );

Line: 576

            update_upload_data (
              P_TRANSACTION_NO  => p_transaction_no,
              P_RECORD_NO       => l_record_no,
              P_PROCESS_STATUS  => 'W',
              P_ERROR_TEXT      => l_error_text
            );

Line: 591

            update_upload_data (
              P_TRANSACTION_NO  => p_transaction_no,
              P_RECORD_NO       => l_record_no,
              P_PROCESS_STATUS  => 'S',
              P_ERROR_TEXT      => l_error_text
            );

Line: 619

          update_upload_data (
            P_TRANSACTION_NO  => p_transaction_no,
            P_RECORD_NO       => l_record_no,
            P_PROCESS_STATUS  => 'U',
            P_ERROR_TEXT      => l_error_text
          );

Line: 656

      update jtf_rs_upload_data
        set request_id = l_request
        where transaction_no = p_transaction_no;

Line: 672

  procedure update_upload_data (
    P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
    P_RECORD_NO      IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
    P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
    P_ERROR_TEXT     IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
  ) IS

  pragma autonomous_transaction;

Line: 682

  update jtf_rs_upload_data
    set error_text       = p_error_text,
        process_status   = p_process_status
    where transaction_no = p_transaction_no
    and record_no        = p_record_no;