APPS.POS_SUPPLIER_USER_REG_PKG SQL Statements

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

Line: 42

        SELECT 1
          FROM ak_resp_security_attributes
          WHERE responsibility_id = p_resp_id AND
          resp_application_id = p_resp_appl_id AND
          attribute_code = p_sec_attr_code AND
          attribute_application_id = p_sec_attr_appl_id;

Line: 73

   INSERT INTO ak_resp_security_attributes
     (responsibility_id,
      resp_application_id,
      attribute_code,
      attribute_application_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
      )
     VALUES
     (p_resp_id,
      p_resp_appl_id,
      p_sec_attr_code,
      p_sec_attr_appl_id,
      fnd_global.user_id,
      Sysdate,
      fnd_global.user_id,
      Sysdate,
      fnd_global.login_id
      );

Line: 132

        SELECT 1
          FROM ak_resp_security_attr_values
          WHERE responsibility_id = p_resp_id AND
          resp_application_id = p_resp_appl_id AND
          attribute_code = p_sec_attr_code AND
          attribute_application_id = p_sec_attr_appl_id;

Line: 164

   INSERT INTO ak_resp_security_attr_values
     (responsibility_id,
      resp_application_id,
      attribute_code,
      attribute_application_id,
      varchar2_value,
      date_value,
      number_value
      )
     VALUES
     (p_resp_id,
      p_resp_appl_id,
      p_sec_attr_code,
      p_sec_attr_appl_id,
      p_varchar2_value,
      p_date_value,
      p_number_value
      );

Line: 214

        SELECT application_id
          FROM   fnd_application
          WHERE  application_short_name = 'POS';

Line: 295

        SELECT responsibility_id
          FROM   fnd_responsibility
          WHERE  application_id = p_appl_id
          AND    responsibility_key = p_resp_key
          AND    (end_date IS NULL OR end_date > start_date);

Line: 328

  SELECT nls_language
  INTO   l_nls_lang
  FROM   fnd_languages
  WHERE  language_code = p_language_code;

Line: 352

   SELECT registration_id INTO l_registration_id
     FROM fnd_registrations
     WHERE registration_id = p_registration_id FOR UPDATE;

Line: 360

        SELECT field_value_string
          FROM fnd_registration_details
         WHERE field_name = 'Note'
           AND registration_id = p_registration_id;

Line: 376

        SELECT email_address
          FROM fnd_user
         WHERE user_id = fnd_global.user_id;

Line: 421

       SELECT d1.field_value_number, d2.field_value_number
       FROM fnd_registrations r,
            fnd_registration_details d1, fnd_registration_details d2
       WHERE r.registration_id = p_registration_id
       AND   d1.registration_id = r.registration_id
       AND   d2.registration_id = r.registration_id
       AND   d1.field_name = 'OSN Request ID'
       AND   d2.field_name = 'OSN Request InternalID';

Line: 452

      SELECT registration_key
        INTO l_reg_key
        FROM fnd_registrations
       WHERE registration_id = p_registration_id;

Line: 457

      SELECT field_value_string
        INTO l_encrypted_initial_password
        FROM fnd_registration_details
       WHERE registration_id = p_registration_id
         AND field_name  = 'Initial Pass';

Line: 481

   select r.requested_user_name
   into   l_user_name
   from fnd_registrations r
   where r.registration_id = p_registration_id;

Line: 499

        SELECT frd1.field_value_string tp_name
          FROM fnd_registration_details frd1,
               fnd_registrations fr
         WHERE frd1.registration_id = fr.registration_id
           AND frd1.field_name = 'OSN TP Name'
           AND fr.registration_id = p_registration_id;

Line: 544

    SELECT r.requested_user_name, d1.field_value_number, d2.field_value_number
    INTO   l_user_name, l_osn_req_id, l_internal_id
    FROM fnd_registrations r,
         fnd_registration_details d1, fnd_registration_details d2
    WHERE r.registration_id = l_reg_id
    AND   d1.registration_id = l_reg_id
    AND   d2.registration_id = l_reg_id
    AND   d1.field_name = 'OSN Request ID'
    AND   d2.field_name = 'OSN Request InternalID';

Line: 573

        SELECT field_value_number
          FROM fnd_registration_details
         WHERE field_name = 'OSN Request ID'
           AND registration_id = p_registration_id;

Line: 618

   SELECT final.role_name
           FROM fnd_user fu,
           fnd_responsibility fr,
           wf_user_roles wur, wf_user_roles final
           WHERE fr.menu_id in
            (SELECT     fme.menu_id
             FROM       fnd_menu_entries fme, (SELECT function_id FROM fnd_form_functions WHERE function_name = 'POS_REG_APPROVE_EXT_USERS') func
             START WITH fme.function_id = func.function_id
             CONNECT BY PRIOR menu_id = sub_menu_id
             )
           AND fr.application_id = 177
           AND wur.role_name like 'FND_RESP|%|%|STANDARD'
           AND WUR.ROLE_ORIG_SYSTEM = 'FND_RESP'
           AND WUR.ROLE_ORIG_SYSTEM_ID = FR.RESPONSIBILITY_ID
           AND WUR.ASSIGNMENT_TYPE IN ('D', 'B')
           AND wur.user_name = fu.user_name
           AND final.user_name = fu.user_name
           GROUP BY final.role_name
           having count(final.role_name) = p_num_users;

Line: 683

   SELECT function_id
   INTO l_approver_func_id
   FROM fnd_form_functions
   WHERE function_name = 'POS_REG_APPROVE_EXT_USERS';

Line: 689

      'SELECT DISTINCT fu.user_name
      FROM fnd_user fu,
           fnd_responsibility fr,
           wf_user_roles wur
      WHERE fr.menu_id in
            (SELECT     fme.menu_id
             FROM       fnd_menu_entries fme
             START WITH fme.function_id = :1
             CONNECT BY PRIOR menu_id = sub_menu_id
             )
      AND fr.application_id = 177
      AND wur.role_name like ''FND_RESP|%|%|STANDARD''
      AND WUR.ROLE_ORIG_SYSTEM = ''FND_RESP''
      AND WUR.ROLE_ORIG_SYSTEM_ID = FR.RESPONSIBILITY_ID
      AND WUR.ASSIGNMENT_TYPE IN (''D'', ''B'')
      AND wur.user_name = fu.user_name'
   using l_approver_func_id;

Line: 767

        SELECT field_value_string
          FROM fnd_registration_details
         WHERE registration_id = p_registration_id
           AND field_name LIKE 'POS_SUPPLIER_RESP_ID%';

Line: 810

         SELECT DISTINCT field_value_number, field_name
           FROM fnd_registration_details
          WHERE registration_id = p_registration_id
            AND (field_name like 'POS_SUPPLIER_ID%'
                 OR field_name like 'POS_SUPPLIER_SITE_ID%'
                 OR field_name like 'POS_SUPPLIER_CONTACT_ID%'
                 );

Line: 1230

        SELECT field_value_string
          FROM fnd_registration_details
         WHERE field_name = 'Invited Flag'
           AND registration_id = p_registration_id;

Line: 1261

        SELECT pv.party_id vendor_party_id,
               fr.*, jobt.field_value_string
          FROM po_vendors pv,
               fnd_registration_details frd,
               fnd_registrations fr, fnd_registration_details jobt
         WHERE frd.registration_id = fr.registration_id
           AND pv.vendor_id = frd.field_value_number
           AND frd.field_name = 'Supplier Number'
           AND jobt.field_name = 'Job Title'
           AND fr.registration_id = jobt.registration_id
           AND fr.application_id = jobt.application_id
           AND fr.registration_type = jobt.registration_type
           AND fr.registration_id = p_registration_id;

Line: 1387

   UPDATE fnd_registrations
     SET registration_status = 'APPROVED',
         last_update_date = Sysdate,
         last_update_login = fnd_global.login_id,
         last_updated_by = fnd_global.user_id
     WHERE registration_id = p_registration_id;

Line: 1430

   UPDATE fnd_registrations
     SET registration_status = 'REJECTED',
         last_update_date = Sysdate,
         last_update_login = fnd_global.login_id,
         last_updated_by = fnd_global.user_id
     WHERE registration_id = p_registration_id;

Line: 1437

   SELECT email, language_code
     INTO l_email, l_language_code
     FROM fnd_registrations
    WHERE registration_id = p_registration_id;

Line: 1477

   UPDATE fnd_registrations
     SET registration_status = 'INVITED',
         last_update_date = Sysdate,
         last_update_login = fnd_global.login_id,
         last_updated_by = fnd_global.user_id
     WHERE registration_id = p_registration_id;

Line: 1484

   SELECT email, language_code, registration_key
     INTO l_email, l_language_code, l_reg_key
     FROM fnd_registrations
    WHERE registration_id = p_registration_id;

Line: 1513

        SELECT fr.first_name, fr.last_name,
               fr.email, fr.language_code, fr.registration_key,
               frd1.field_value_string vendor_name,
               frd2.field_value_number approver_id,
               fu.user_name
          FROM fnd_registration_details frd1,
               fnd_registration_details frd2,
               fnd_registrations fr,
               fnd_user fu
         WHERE frd1.registration_id = fr.registration_id
           AND frd1.field_name = 'Supplier Name'
           AND frd2.registration_id = fr.registration_id
           AND frd2.field_name = 'Approver ID'
           AND fr.registration_id = p_registration_id
           AND fu.user_id = frd2.field_value_number;

Line: 1532

   UPDATE fnd_registrations
     SET registration_status = 'REGISTERED',
         last_update_date = Sysdate,
         last_update_login = fnd_global.login_id,
         last_updated_by = fnd_global.user_id
     WHERE registration_id = p_registration_id;