APPS.FND_UPDATE_USER_PREF_PUB SQL Statements

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

Line: 29

select  purpose_code,
        purpose_default_code
  from  fnd_business_purposes_b
  where  purpose_code <> 'ALL';

Line: 38

select  contact_preference_id,
        object_version_number,
        contact_type
        contact_level_table,
        contact_level_table_id	,
        preference_code	,
        preference_topic_type	,
        preference_topic_type_id  ,
        preference_topic_type_code  ,
        preference_start_date	 ,
        preference_end_date	,
        requested_by		,
        reason_code		,
        status	   ,
        created_by_module  ,
        contact_type
  FROM HZ_CONTACT_PREFERENCES pref
 WHERE pref.CONTACT_LEVEL_TABLE_ID    = l_party_id
   AND pref.CONTACT_LEVEL_TABLE       = 'HZ_PARTIES'
   AND pref.preference_topic_type_code = l_purpose_code  -- this will be l_purpose_code
   AND pref.preference_topic_type     = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES
   AND pref.contact_type              = 'PRIV_PREF'
--   AND sysdate between pref.preference_start_date and nvl(pref.preference_end_date, sysdate +1)
   AND status                         = 'A';

Line: 70

select person_party_id
  from fnd_user
 where user_id = l_user_id;

Line: 202

              delete hz_contact_preferences
              where  contact_preference_id = r_cont_pref.contact_preference_id;

Line: 346

select  purpose_attribute_id,
        attribute_default_code
  from  fnd_purpose_attributes;

Line: 355

select customer_id
  from fnd_user
 where user_id = l_user_id;

Line: 401

delete  HZ_CONTACT_PREFERENCES pref
 WHERE pref.CONTACT_LEVEL_TABLE_ID    = l_party_id
   AND pref.CONTACT_LEVEL_TABLE       = 'HZ_PARTIES'
   AND pref.preference_topic_type     = 'FND_BUSINESS_PURPOSES_B'
   AND pref.contact_type              = 'PRIV_PREF';

Line: 479

select  purpose_attribute_id,
        attribute_default_code
  from  fnd_purpose_attributes;

Line: 488

select  contact_preference_id,
        preference_code
  FROM HZ_CONTACT_PREFERENCES pref
 WHERE pref.CONTACT_LEVEL_TABLE_ID    = l_party_id
   AND pref.CONTACT_LEVEL_TABLE       = 'HZ_PARTIES'
   --AND pref.preference_topic_type_id  = l_purpose_code
   AND pref.preference_topic_type_code = l_purpose_code
   AND pref.preference_topic_type      = 'FND_BUSINESS_PURPOSES_B'
   AND pref.contact_type               = 'PRIV_PREF'
   AND status                          = 'A';

Line: 506

select customer_id
  from fnd_user
 where user_id = l_user_id;

Line: 577

              delete HZ_CONTACT_PREFERENCES pref
               WHERE pref.CONTACT_LEVEL_TABLE_ID      = l_party_id
                 AND pref.CONTACT_LEVEL_TABLE         = 'HZ_PARTIES'
                 AND pref.preference_topic_type       = 'FND_BUSINESS_PURPOSES_B'
                 AND pref.contact_type                = 'PRIV_PREF'
                 AND pref.preference_topic_type_code  = p_option(i).purpose_code;

Line: 604

             delete HZ_CONTACT_PREFERENCES pref
             where pref.contact_preference_id = r_cont_pref.contact_preference_id;

Line: 667

             delete HZ_CONTACT_PREFERENCES pref
             where pref.contact_preference_id = r_cont_pref.contact_preference_id;

Line: 724

       delete HZ_CONTACT_PREFERENCES pref
        WHERE pref.CONTACT_LEVEL_TABLE_ID      = l_party_id
          AND pref.CONTACT_LEVEL_TABLE         = 'HZ_PARTIES'
          AND pref.preference_topic_type       = 'FND_BUSINESS_PURPOSES_B'
          AND pref.contact_type                = 'PRIV_PREF'
          AND pref.preference_topic_type_code  = 'ALL';