APPS.POS_USER_REG_HELPER_PKG SQL Statements

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

Line: 16

      SELECT registration_id
	FROM fnd_registrations
	WHERE registration_key = p_reg_key;

Line: 92

      SELECT vendor_name INTO l_supplier_name FROM po_vendors WHERE vendor_id = p_vendor_id;

Line: 105

   l_registration_id := fnd_registration_pkg.insert_fnd_reg
     (
      p_application_id           => l_app_id,
      p_party_id                 => NULL,
      p_registration_type        => l_reg_type,
      p_requested_user_name      => NULL,
      p_assigned_user_name       => NULL,
      p_registration_status      => 'INVITED',
      p_exists_in_fnd_user_flag  => 'N',
      p_email                    => p_email_address,
      p_language_code            => USERENV('LANG')
      );

Line: 131

   UPDATE fnd_registrations SET registration_key = l_registration_key WHERE registration_id = l_registration_id;

Line: 137

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Supplier Name',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => l_supplier_name,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 153

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Supplier Number',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => NULL,
      p_field_value_number => p_vendor_id,
      p_field_value_date   => NULL
      );

Line: 166

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Sourcing',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => p_sourcing_flag,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 179

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'ISP',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => p_isp_flag,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 192

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'CollaborativePlanning',
      p_field_type         => NULL,
      p_field_format       => 'Y|N',
      p_field_value_string => p_cp_flag,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 205

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Job Title',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => NULL,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 218

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Note',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => p_note,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 231

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'User Access',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => NULL,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 244

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Restrict Access',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => NULL,
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );

Line: 257

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Approver ID',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => NULL,
      p_field_value_number => fnd_global.user_id,
      p_field_value_date   => NULL
      );

Line: 270

   fnd_registration_pkg.insert_fnd_reg_details
     (
      p_registration_id    => l_registration_id,
      p_application_id     => l_app_id,
      p_registration_type  => l_reg_type,
      p_field_name         => 'Invited Flag',
      p_field_type         => NULL,
      p_field_format       => NULL,
      p_field_value_string => 'Y',
      p_field_value_number => NULL,
      p_field_value_date   => NULL
      );