APPS.OKS_HZ_CUSTOMER_ACCOUNTS_PVT SQL Statements

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

Line: 131

   p_account_rec.status_update_date              :=              G_MISS_DATE;

Line: 231

  procedure UPDATE_ROW (p_cust_account_id IN number,
                        p_coterm_day_month IN varchar2)
  is

   cursor cu_last_update(cp_cust_account_id  IN NUMBER)
   is
   --npalepu modified on 4/13/2006 for bug # 5139425
   /* SELECT last_update_date  */
   SELECT last_update_date,object_version_number
   --end npalepu
   FROM HZ_CUST_ACCOUNTS
   WHERE cust_account_id= cp_cust_account_id;

Line: 244

   cr_last_update      cu_last_update%ROWTYPE;

Line: 256

   l_last_update_date1  DATE;

Line: 257

   l_last_update_date2  DATE;

Line: 272

     open cu_last_update(p_cust_account_id);

Line: 273

     fetch cu_last_update into cr_last_update;

Line: 274

     close cu_last_update;

Line: 276

     l_last_update_date1 := cr_last_update.last_update_date;

Line: 278

     l_object_version_number := cr_last_update.object_version_number;

Line: 281

     HZ_CUST_ACCOUNT_V2PUB.update_cust_account
--     ( p_api_version => 1
     ( p_init_msg_list => 'T'
--     , p_commit => 'F'
     , p_cust_account_rec => l_account_rec
--     , p_cust_profile_rec => l_cust_rec
--     , p_acct_last_update_date => l_last_update_date1
--     , p_prof_last_update_date => l_last_update_date2
     , p_object_version_number   => l_object_version_number -- New parameter
     , x_return_status => l_return_status
     , x_msg_count => l_msg_count
     , x_msg_data => l_msg_data
--     , p_validation_level => l_validation_level
     );