[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_DELETE_GROUP_TYPE CONSTANT NUMBER := 2;
G_DELETE_GROUP_PROCESS CONSTANT VARCHAR2(30) := 'DELETE_GROUP_PROCESS';
SELECT user1.user_name, user1.party_id, user1.party_name, f.grantee_key
FROM fnd_grants f, fnd_menus m, fnd_objects o, ego_user_v user1
WHERE f.instance_pk1_value = to_char(cp_group_id)
AND f.start_date <= SYSDATE
AND NVL(f.end_date, SYSDATE) >= SYSDATE
AND (f.grantee_key like 'HZ_PARTY:%'
AND REPLACE(f.grantee_key,'HZ_PARTY:','') = user1.party_id)
AND f.menu_id = m.menu_id
AND m.menu_name = 'EGO_MANAGE_GROUP'
AND f.object_id = o.object_id
AND o.obj_name = 'EGO_GROUP';
SELECT preference_value
FROM fnd_user_preferences user_prefs,
fnd_user users,
hz_parties parties
WHERE user_prefs.preference_name = 'MAILTYPE'
AND user_prefs.user_name = users.user_name
AND users.customer_id = parties.party_id
AND parties.party_id = cp_party_id;
SELECT user_name, party_name
FROM ego_user_v
WHERE party_id = p_party_id;
SELECT relationship_id
FROM hz_relationships
WHERE subject_id = p_member_id
AND object_id = p_group_id
AND status = 'A'
AND relationship_type = G_MEMBER_GROUP_REL_TYPE
AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
SELECT Decode (l_owner_id, null, '', To_char(l_owner_id))
INTO l_values_out_tbl(i)
FROM dual;
SELECT Decode (l_group_id, null, '', To_char(l_group_id))
INTO l_values_out_tbl(i)
FROM dual;
SELECT Decode (l_member_id, null, '', To_char(l_member_id))
INTO l_values_out_tbl(i)
FROM dual;
SELECT Decode (l_group_member_rel_id, null, '', To_char(l_group_member_rel_id))
INTO l_values_out_tbl(i)
FROM dual;
p_process_type = G_DELETE_GROUP_TYPE
) THEN
IF ( l_names_tbl.count > 0) THEN
FOR i IN l_names_tbl.first .. l_names_tbl.last LOOP
mdebug('setting attribute: '|| l_names_tbl(i) || ' value - ' || l_values_tbl(i));
SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
FROM dual;
PROCEDURE Start_Delete_Group_Process
(
p_group_id IN NUMBER,
p_group_name IN VARCHAR2,
p_name_value_pairs IN VARCHAR2
)
IS
----------------------------------------------------------------------
-- Start OF comments
--
-- Procedure name : Start_Delete_Group_Process
-- Type : Public
-- Pre-reqs : None
-- Functionality : Starts the workflow process to Delete Group.
-- Notes :
--
-- History :
-- 21-jul-2002 Sridhar Rajaparthi Creation
--
-- END OF comments
----------------------------------------------------------------------
l_return_status VARCHAR2(100);
l_wf_process VARCHAR2(30) := G_DELETE_GROUP_PROCESS;
SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
FROM dual;
mdebug (' EGO_GROUP_WF_PKG.Start_Delete_Group_Process ');
setWFItemAttributes(G_DELETE_GROUP_TYPE, l_item_type, l_item_key, l_xml_str);
END Start_Delete_Group_Process;
SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
FROM dual;
SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
FROM dual;
SELECT 'Y'
FROM EGO_GROUP_MEMBERS_V
WHERE group_id = cp_group_id
AND member_person_id = cp_member_id;
SELECT object_version_number
FROM hz_relationships
WHERE relationship_id = cp_relationship_id;
PROCEDURE Delete_Group
(
p_item_type IN VARCHAR2,
p_item_key IN VARCHAR2,
p_actid IN NUMBER,
p_funcmode IN VARCHAR2,
x_result OUT NOCOPY VARCHAR2
)
IS
----------------------------------------------------------------------
-- Start OF comments
--
-- Procedure name : Delete_Group
-- Type : Public
-- Pre-reqs : None
-- Functionality : Deletes the group
--
-- Notes :
--
-- History :
-- 21-jul-2002 Sridhar Rajaparthi Creation
--
-- END OF comments
----------------------------------------------------------------------
l_group_id NUMBER;
SELECT object_version_number
FROM hz_parties
WHERE party_id = cp_group_id
AND party_type = 'GROUP'
AND status = 'A';
mdebug (' Entered Delete Group after sending notifications ');
mdebug (' Group to be deleted ' || to_char(l_group_id));
mdebug (' Calling EGO_PARTY_PUB.Delete Group ');
EGO_PARTY_PUB.Delete_group
(p_api_version => 1.0
,p_init_msg_list => FND_API.G_TRUE
,p_commit => FND_API.G_FALSE
,p_group_id => l_group_id
,p_object_version_no_group => l_object_version_number
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
mdebug (' Exited out of EGO_PARTY_PUB.Delete Group ');
wf_core.context(G_PACKAGE_NAME,'Delete_Group',p_item_type,p_item_key);
END Delete_Group;
SELECT member_user_name, member_person_name, member_person_id
FROM ego_group_members_v
WHERE group_id = cp_group_id;
SELECT party_name
FROM ego_user_v
WHERE user_name = cp_user_name;
SELECT A.user_name
INTO l_responder_name
FROM wf_user_roles a, wf_users b
WHERE a.user_name = b.name
AND a.role_name = G_GROUP_OBJECT_NAME || itemkey
AND upper(b.EMAIL_ADDRESS) = upper(l_email_address)
AND rownum = 1;
SELECT count(1)
FROM wf_local_user_roles
WHERE user_name = cp_user_name
AND role_name = cp_role_name
AND role_orig_system = 'WF_LOCAL_ROLES'
AND role_orig_system_id = 0;