APPS.POS_SBD_TBL_PKG dependencies on POS_ACNT_ADDR_SUMM_REQ

Line 17: delete from pos_acnt_addr_summ_req where assignment_id = p_assignment_id;

13: BEGIN
14:
15: l_step := 0;
16:
17: delete from pos_acnt_addr_summ_req where assignment_id = p_assignment_id;
18:
19: l_step := 1;
20:
21: x_status := 'S';

Line 102: update pos_acnt_addr_summ_req set

98: BEGIN
99:
100: l_step:= 0;
101:
102: update pos_acnt_addr_summ_req set
103: last_update_date = sysdate
104: , last_updated_by = fnd_global.user_id
105: , last_update_login = fnd_global.login_id
106: , ext_bank_account_id = nvl(p_ext_bank_account_id,ext_bank_account_id)

Line 268: select POS_ACNT_ADDR_SUMM_REQ_S.nextval into x_assignment_id from dual;

264:
265: BEGIN
266:
267: l_step := 0;
268: select POS_ACNT_ADDR_SUMM_REQ_S.nextval into x_assignment_id from dual;
269:
270: l_step := 1;
271: insert into POS_ACNT_ADDR_SUMM_REQ (
272: assignment_id

Line 271: insert into POS_ACNT_ADDR_SUMM_REQ (

267: l_step := 0;
268: select POS_ACNT_ADDR_SUMM_REQ_S.nextval into x_assignment_id from dual;
269:
270: l_step := 1;
271: insert into POS_ACNT_ADDR_SUMM_REQ (
272: assignment_id
273: , creation_date
274: , created_by
275: , last_update_date