APPS.POS_SBD_TBL_PKG SQL Statements

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

Line: 17

delete from pos_acnt_addr_summ_req where assignment_id = p_assignment_id;

Line: 43

delete from pos_acnt_addr_req where assignment_request_id = p_assignment_request_id;

Line: 69

delete from pos_acnt_gen_req where account_request_id = p_account_request_id;

Line: 82

PROCEDURE update_row_pos_acnt_summ_req (
  p_assignment_id	   IN NUMBER
, p_assignment_request_id  IN NUMBER
, p_ext_bank_account_id    IN NUMBER
, p_account_request_id     IN NUMBER
, p_start_date             IN DATE
, p_end_date               IN DATE
, p_priority               IN NUMBER
, p_assignment_status      IN VARCHAR2
, x_status        out nocopy VARCHAR2
, x_exception_msg out nocopy VARCHAR2
)
IS

l_step NUMBER;

Line: 102

    update pos_acnt_addr_summ_req set
     last_update_date = sysdate
   , last_updated_by = fnd_global.user_id
   , last_update_login  = fnd_global.login_id
   , ext_bank_account_id = nvl(p_ext_bank_account_id,ext_bank_account_id)
   , account_request_id = nvl(p_account_request_id, account_request_id)
   , assignment_status = nvl(p_assignment_status, assignment_status)
   , start_date = p_start_date
   , end_date = p_end_date
   , priority = p_priority
   where assignment_request_id = p_assignment_request_id
   and assignment_id = p_assignment_id;

Line: 124

END update_row_pos_acnt_summ_req;

Line: 130

PROCEDURE insert_row_pos_acnt_addr_req (
  p_mapping_id	   in NUMBER
, p_request_type   in varchar2
, p_party_site_id  in number
, p_address_request_id in number
, x_assignment_request_id out nocopy number
, x_status        out nocopy VARCHAR2
, x_exception_msg out nocopy VARCHAR2
)
IS

l_step number;

Line: 146

   select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;

Line: 149

  insert into POS_ACNT_ADDR_REQ (
     assignment_request_id
   , creation_date
   , created_by
   , last_update_date
   , last_updated_by
   , last_update_login
   , object_version_number
   , MAPPING_ID
   , request_status
   , request_type
   , party_site_id
   , address_request_id
  )
  values
  (
    x_assignment_request_id
  , sysdate -- creation_date
  , fnd_global.user_id -- created_by
  , sysdate -- last_update_date
  , fnd_global.user_id -- last_updated_by
  , fnd_global.login_id -- last_update_login
  , 1
  , p_mapping_id
  , 'PENDING'
  , p_request_type
  , p_party_site_id
  , p_address_request_id
  );

Line: 188

END insert_row_pos_acnt_addr_req;

Line: 194

PROCEDURE insert_row_pos_acnt_gen_req (
  p_mapping_id	   IN NUMBER
, p_temp_ext_bank_account_id IN NUMBER
, p_ext_bank_account_id IN NUMBER
, x_account_request_id out nocopy number
, x_status        out nocopy VARCHAR2
, x_exception_msg out nocopy VARCHAR2
)
IS

l_step number;

Line: 209

  select POS_ACNT_GEN_REQ_S.nextval into x_account_request_id from dual;

Line: 212

  insert into POS_ACNT_GEN_REQ (
     account_request_id
   , creation_date
   , created_by
   , last_update_date
   , last_updated_by
   , last_update_login
   , object_version_number
   , MAPPING_ID
   , TEMP_EXT_BANK_ACCT_ID
   , EXT_BANK_ACCOUNT_ID
  )
  values
  (
   x_account_request_id
  , sysdate -- creation_date
  , fnd_global.user_id -- created_by
  , sysdate -- last_update_date
  , fnd_global.user_id -- last_updated_by
  , fnd_global.login_id -- last_update_login
  , 1
  , p_mapping_id
  , p_temp_ext_bank_account_id
  , p_ext_bank_account_id
  );

Line: 247

END insert_row_pos_acnt_gen_req;

Line: 249

PROCEDURE insert_row_pos_acnt_summ_req (
  p_assignment_request_id in number
, p_ext_bank_account_id IN NUMBER
, p_account_request_id in number
, p_start_date in date
, p_end_date in date
, p_priority in number
, p_assignment_status in varchar2
, x_assignment_id out nocopy number
, x_status        out nocopy VARCHAR2
, x_exception_msg out nocopy VARCHAR2
)
IS

l_step number;

Line: 268

  select POS_ACNT_ADDR_SUMM_REQ_S.nextval into x_assignment_id from dual;

Line: 271

  insert into POS_ACNT_ADDR_SUMM_REQ (
     assignment_id
   , creation_date
   , created_by
   , last_update_date
   , last_updated_by
   , last_update_login
   , assignment_request_id
   , ext_bank_account_id
   , start_date
   , end_date
   , priority
   , assignment_status
   , account_request_id
   , object_version_number
  )
  values
  (
    x_assignment_id
  , sysdate -- creation_date
  , fnd_global.user_id -- created_by
  , sysdate -- last_update_date
  , fnd_global.user_id -- last_updated_by
  , fnd_global.login_id -- last_update_login
  , p_assignment_request_id
  , p_ext_bank_account_id
  , p_start_date
  , p_end_date
  , p_priority
  , p_assignment_status
  , p_account_request_id
  , 1
  );

Line: 313

END insert_row_pos_acnt_summ_req;

Line: 316

/* This procedure updates a row in POS_ACNT_ADDR_REQ
 *
 */
PROCEDURE update_row_pos_acnt_addr_req (
  p_assignment_request_id  IN NUMBER
, p_request_status in varchar2
, p_party_site_id  in number
, p_address_request_id in number
, p_object_version_number in number
, x_status        out nocopy VARCHAR2
, x_exception_msg out nocopy VARCHAR2
)
IS
l_step number;

Line: 332

cursor l_update_cur is
select object_version_number from POS_ACNT_ADDR_REQ
where assignment_request_id = p_assignment_request_id for update;

Line: 340

open l_update_cur;

Line: 341

fetch l_update_cur into l_object_version_number;

Line: 342

close l_update_cur;

Line: 349

  update POS_ACNT_ADDR_REQ set
   last_update_date = sysdate
   , last_updated_by = fnd_global.user_id
   , last_update_login = fnd_global.login_id
   , request_status = nvl(p_request_status, request_status)
   , party_site_id = p_party_site_id
   , address_request_id = p_address_request_id
  where assignment_request_id = p_assignment_request_id;

Line: 374

END update_row_pos_acnt_addr_req;