The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT to_char(sysdate,'dd-mm-yyyy-HH24-MI-SS')
FROM dual;
SELECT user_name
FROM fnd_user
WHERE user_id=cp_user_id;
SELECT party_name ,party_number,email_address
FROM hz_parties
WHERE party_id=cp_party_id;
SELECT email_address
FROM fnd_user
WHERE user_name=cp_user_name;
select party_name, email_address
from hz_parties
where party_id=cp_req_id;
SELECT user_name
FROM fnd_user
WHERE PERSON_PARTY_ID=cp_req_id;
INSERT INTO igp_ac_account_ints (item_key,
int_account_id,
party_id,
acc_classification_code,
access_expiration_date,
user_id,
user_name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES(
l_item_key,
igp_ac_account_ints_s.NEXTVAL,
l_party_id,
l_classification_cd,
l_expiration_dt,
null,
l_user_name,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id
);
INSERT INTO igp_ac_account_ints (item_key,
int_account_id,
party_id,
acc_classification_code,
access_expiration_date,
user_id,
user_name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES(
l_item_key,
igp_ac_account_ints_s.NEXTVAL,
l_party_id,
l_classification_cd,
l_expiration_dt,
l_user_id,
null,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id
);
select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3)) INTO l_url_part1 FROM dual;
select FND_PROFILE.VALUE('ICX_OA_HTML') INTO l_url_part2 FROM dual;
SELECT 'Y'
FROM igp_ac_accounts ac,
igp_ac_acc_classes acc
WHERE ac.user_id=cp_user_id AND
acc.acc_classification_code=cp_acc_type AND
ac.account_id=acc.account_id;
DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
if FND_SSO_MANAGER.isUserCreateUpdateAllowed() then
IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.validate_user_name', ' User create and update allowed.');
end if; -- FOR FND_SSO_MANAGER.isUserCreateUpdateAllowed()
DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;
select USER_ID into l_user_id
from FND_USER
where USER_NAME = l_user_name;
delete from igp_ac_account_ints where item_key= itemkey;
SELECT responsibility_id
FROM igp_as_resp_mappings
WHERE acc_classification_code=cp_class_cd
AND tag='IGP'
AND enable_flag='Y';
SELECT b.responsibility_id,b.end_date
FROM fnd_user a,
fnd_user_resp_groups_direct b
WHERE a.user_id=cp_user_id AND
a.user_id=b.user_id AND
b.responsibility_id=cp_resp;
SELECT account_id
FROM igp_ac_accounts a
WHERE party_id=cp_party_id;
SELECT user_id
FROM fnd_user
WHERE user_name=cp_user_name;
SELECT description
FROM fnd_responsibility_tl
WHERE responsibility_id=cp_resp_id AND
language = USERENV('LANG');
ELSIF (l_account_id IS NULL) THEN --Call the TBH of the IGP_AC_ACCOUNTS table to insert into the table.
BEGIN
igp_ac_accounts_pkg.insert_row (
x_mode => 'R',
x_rowid => lv_rowid, -- OUT param
x_account_id => l_account_id, -- OUT param
x_party_id => l_party_id, -- HZ party ID.
x_user_id => l_fnd_user_id, -- FND user ID.
x_object_version_number => 1 -- OVN is always 1 for a newly created record.
);
IF (c_chk_resp_rec.responsibility_id IS NOT NULL) THEN --check if we need to update the end date of the FND resp.
l_fnd_resp_end_dt:=c_chk_resp_rec.end_date;
IF (l_expiration_dt IS NULL) THEN -- Update the FNd resp to be not end dated,.
OPEN c_get_resp_desc(c_get_resp_rec.responsibility_id); -- get the desc of the resp. reqd for API call.
fnd_user_resp_groups_api.update_assignment(
user_id => l_fnd_user_id, -- FND user ID.
responsibility_id =>c_get_resp_rec.responsibility_id, -- RESP ID.
responsibility_application_id =>8405,
security_group_id => 0,
start_date => sysdate,
end_date => l_expiration_dt, -- Expiration date.
description =>l_desc -- Description.
);
IF (l_expiration_dt > l_fnd_resp_end_dt) THEN --Update the new FND resp end date.
OPEN c_get_resp_desc(c_get_resp_rec.responsibility_id); -- get the desc of the resp. reqd for API call.
fnd_user_resp_groups_api.update_assignment(
user_id => l_fnd_user_id, -- FND user ID.
responsibility_id =>c_get_resp_rec.responsibility_id, -- RESP ID.
responsibility_application_id =>8405,
security_group_id => 0,
start_date => sysdate,
end_date => l_expiration_dt, -- Expiration date.
description =>l_desc -- Description.
);
fnd_user_resp_groups_api.insert_assignment(
user_id => l_fnd_user_id, -- FND user ID.
responsibility_id =>c_get_resp_rec.responsibility_id, -- RESP ID.
responsibility_application_id =>8405,
security_group_id => 0,
start_date => sysdate,
end_date => l_expiration_dt, -- Expiration date.
description =>l_desc -- Description.
);
igp_ac_acc_classes_pkg.insert_row ( x_mode => 'R',
x_rowid => lv_rowid,
x_acc_classification_id => l_acc_classification_id, -- PK of the table. OUT param.
x_account_id => l_account_id , -- FK to the account ID.
x_acc_classification_code => l_classification_cd, -- Acc classification code.
x_access_expiration_date => l_expiration_dt, -- Access expiration date.
x_object_version_number => 1
);
DELETE FROM igp_ac_account_ints
WHERE party_id=l_party_id
AND acc_classification_code=l_classification_cd;
SELECT hz.party_name,hz.party_number
FROM hz_parties hz,igp_ac_accounts ac
WHERE ac.user_id=cp_user_id AND
ac.party_id=hz.party_id;
SELECT user_name
FROM fnd_user
WHERE user_id=cp_user_id;
SELECT hz.person_last_name||', '||hz.person_first_name req_name,
fu.email_address req_email
FROM
hz_parties hz,
fnd_user fu,
igp_ac_Accounts acc
WHERE
hz.party_id=cp_req_id AND
hz.party_id=acc.party_id AND
acc.user_id=fu.user_id;
DELETE FROM igp_ac_account_ints WHERE item_key=itemkey;