[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PERSON_PARTY_ID
from FND_USER
where USER_ID = X_USER_ID
and nvl( END_DATE, sysdate+1) > sysdate;
select URS.REG_SERVICE_TYPE, URS.WF_ROLE_NAME, URS.AME_APPLICATION_ID,
URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
URS.EMAIL_VERIFICATION_FLAG
from UMX_REG_SERVICES_B URS, WF_EVENTS WE
where URS.REG_SERVICE_CODE = X_REG_SERVICE_CODE
and nvl(URS.END_DATE, sysdate+1) > sysdate
and URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;
select URS.REG_SERVICE_TYPE, URS.REG_SERVICE_CODE, URS.AME_APPLICATION_ID,
URS.AME_TRANSACTION_TYPE_ID, URS.REG_FUNCTION_ID, WE.NAME,
URS.EMAIL_VERIFICATION_FLAG
from UMX_REG_SERVICES_B URS, WF_EVENTS WE
where URS.WF_ROLE_NAME = x_wf_role_name
and nvl(URS.END_DATE, sysdate+1) > sysdate
and URS.REG_SERVICE_TYPE = 'ADDITIONAL_ACCESS'
and URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;
SELECT 'Y'
FROM fnd_lookup_values
WHERE lookup_type = p_lookup_type
AND lookup_code = p_column_value
AND ROWNUM = 1;
procedure update_reg_request (p_reg_request in out NOCOPY REG_REQUEST_TYPE) IS
BEGIN
if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
'fnd.plsql.UMXVRRSB.update_reg_request.begin', 'Begin');
UMX_REG_REQUESTS_PKG.update_row (
X_REG_REQUEST_ID => p_reg_request.reg_request_id,
X_STATUS_CODE => p_reg_request.status_code,
X_REQUESTED_BY_USER_ID => fnd_global.user_id,
X_REQUESTED_FOR_USER_ID => p_reg_request.requested_for_user_id,
X_REQUESTED_FOR_PARTY_ID => p_reg_request.requested_for_party_id,
X_REQUESTED_USERNAME => upper (p_reg_request.requested_username),
X_REQUESTED_START_DATE => p_reg_request.requested_start_date,
X_REQUESTED_END_DATE => p_reg_request.requested_end_date,
X_WF_ROLE_NAME => p_reg_request.wf_role_name,
X_REG_SERVICE_CODE => p_reg_request.reg_service_code,
X_AME_APPLICATION_ID => p_reg_request.ame_application_id,
X_AME_TRANSACTION_TYPE_ID => p_reg_request.ame_transaction_type_id,
X_JUSTIFICATION => p_reg_request.justification
);
'fnd.plsql.UMXVRRSB.update_reg_request.end', 'End');
END update_reg_request;
procedure delete_reg_request (
p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
) is
BEGIN
if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
'fnd.plsql.UMXVRRSB.delete_reg_request.begin',
'regRequestId: ' || p_reg_request_id);
UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_id);
'fnd.plsql.UMXVRRSB.delete_reg_request.end', 'End');
END delete_reg_request;
select user_name
from fnd_user
where user_name = l_username;
select requested_by_user_id
from umx_reg_requests
where reg_request_id = p_reg_request_id;
UMX_REG_REQUESTS_PKG.update_row (
X_REG_REQUEST_ID => p_reg_request_id,
X_REQUESTED_BY_USER_ID => l_requested_by_user_id,
X_REQUESTED_FOR_USER_ID => l_USER_ID,
X_REQUESTED_USERNAME => p_username,
X_STATUS_CODE => 'PENDING');
fnd_user_pkg.UpdateUserParty (
x_user_name => p_username,
x_owner => NULL,
x_person_party_id => p_person_party_id);
SELECT user_id
INTO uid
FROM FND_USER
WHERE USER_NAME = UPPER(p_username) ;
SELECT orig_system_reference
INTO oid
FROM HZ_PARTIES
WHERE party_id = p_person_party_id ;
SELECT EMPLOYEE_ID
INTO eid
FROM FND_USER
WHERE USER_NAME = UPPER(p_username) ;
SELECT person_id
INTO pid
FROM per_people_f
WHERE party_id = p_person_party_id
AND rownum =1;
fnd_user_pkg.UpdateUser (x_user_name =>p_username, x_owner => NULL , x_employee_id =>pid);
UPDATE AK_WEB_USER_SEC_ATTR_VALUES
SET NUMBER_VALUE = eid ,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_DATE = SYSDATE ,
LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE WEB_USER_ID = uid
AND ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID'
AND ATTRIBUTE_APPLICATION_ID = 178;
INSERT
INTO ak_web_user_sec_attr_values
(
web_user_id ,
attribute_code ,
attribute_application_id,
number_value ,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login
)
VALUES
(
uid ,
'ICX_HR_PERSON_ID',
178 ,
eid ,
fnd_global.user_id,
SYSDATE ,
fnd_global.user_id,
SYSDATE ,
fnd_global.login_id
);
UPDATE AK_WEB_USER_SEC_ATTR_VALUES
SET NUMBER_VALUE = eid ,
LAST_UPDATED_BY =fnd_global.user_id,
LAST_UPDATE_DATE = SYSDATE ,
LAST_UPDATE_LOGIN = fnd_global.login_id
WHERE WEB_USER_ID = uid
AND ATTRIBUTE_CODE = 'TO_PERSON_ID'
AND ATTRIBUTE_APPLICATION_ID = 178;
INSERT
INTO ak_web_user_sec_attr_values
(
web_user_id ,
attribute_code ,
attribute_application_id,
number_value ,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login
)
VALUES
(
uid ,
'TO_PERSON_ID' ,
178 ,
eid ,
fnd_global.user_id,
SYSDATE ,
fnd_global.user_id,
SYSDATE ,
fnd_global.login_id
);
FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin', 'When inserting security attributes');
UMX_REG_REQUESTS_PKG.update_row (
X_REG_REQUEST_ID => p_reg_request_id,
X_STATUS_CODE => 'APPROVED',
X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
select requested_by_user_id
from umx_reg_requests
where reg_request_id = p_reg_request_id;
UMX_REG_REQUESTS_PKG.update_row (
X_REG_REQUEST_ID => p_reg_request_id,
X_STATUS_CODE => p_status_code,
X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
X_STATUS_CODE => p_status_code);
select ame_application_id, ame_transaction_type_id
from umx_reg_requests
where reg_request_id = p_reg_request_id;
select reg_request_id, status_code, ame_application_id,
ame_transaction_type_id, requested_username, justification
from umx_reg_requests
where requested_for_user_id = p_user_id
and requested_username is not null;
select status_code, ame_application_id, ame_transaction_type_id, justification
from umx_reg_requests
where reg_request_id = p_reg_req_id;
select user_name
from fnd_user
where user_id = l_user_id;
select * from wf_items
where parent_item_type = umx_registration_util.g_item_type
and parent_item_key = p_reg_request_id;
select reg_request_id
from umx_reg_requests
where requested_for_user_id = l_user_id;