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 139: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;

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

Line 851: l_status_code umx_reg_requests.status_code%type;

847: l_description_i number;
848:
849: l_reg_request_id umx_reg_requests.reg_request_id%type;
850: l_reg_service_type umx_reg_requests.reg_service_type%type;
851: l_status_code umx_reg_requests.status_code%type;
852: l_requested_start_date umx_reg_requests.requested_start_date%type;
853: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
854: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;
855: l_requested_for_user_name fnd_user.user_name%type;