DBA Data[Home] [Help]

APPS.POS_SBD_TBL_PKG dependencies on POS_ACNT_ADDR_REQ_S

Line 146: select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;

142:
143: BEGIN
144:
145: l_step := 0;
146: select POS_ACNT_ADDR_REQ_S.nextval into x_assignment_request_id from dual;
147:
148: l_step := 1;
149: insert into POS_ACNT_ADDR_REQ (
150: assignment_request_id

Line 349: update POS_ACNT_ADDR_REQ set

345:
346: if l_object_version_number = p_object_version_number then
347:
348: l_step := 2;
349: update POS_ACNT_ADDR_REQ set
350: last_update_date = sysdate
351: , last_updated_by = fnd_global.user_id
352: , last_update_login = fnd_global.login_id
353: , request_status = nvl(p_request_status, request_status)