APPS.UMX_REGISTRATION_PVT dependencies on UMX_REG_REQUESTS_S

Line 17: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

13:
14: l_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
15: l_user_name FND_USER.USER_NAME%TYPE;
16: l_party_id FND_USER.PERSON_PARTY_ID%TYPE;
17: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
18: j NUMBER;
19: l_index_to_add NUMBER;
20:
21: BEGIN

Line 137: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;

133: l_event_name := 'oracle.apps.fnd.umx.startaccountrequestwf';
134: end if;
135:
136: if l_item_key is null then
137: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;
138: l_index_to_add := p_registration_data.last + 1;
139: p_registration_data(l_index_to_add).ATTR_NAME := 'reg_request_id';
140: p_registration_data(l_index_to_add).ATTR_VALUE := l_item_key;
141: end if;

Line 836: l_status_code umx_reg_requests.status_code%type;

832: l_description_i number;
833:
834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%type;
836: l_status_code umx_reg_requests.status_code%type;
837: l_requested_start_date umx_reg_requests.requested_start_date%type;
838: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
839: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;
840: l_requested_for_user_name fnd_user.user_name%type;