[Home] [Help]
36: IS
37: CURSOR C_Proc_Owner IS
38: select TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
39: from fnd_grants grants,
40: fnd_objects obj,
41: fnd_menus granted_menu
42: where obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
43: AND grants.object_id = obj.object_id
44: AND grants.grantee_type ='USER'
60:
61: CURSOR C_Org_Owner IS
62: select TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
63: from fnd_grants grants,
64: fnd_objects obj,
65: fnd_menus granted_menu
66: where obj.obj_name = 'AMW_ORGANIZATION'
67: AND grants.object_id = obj.object_id
68: AND grants.grantee_type ='USER'
135: PROCEDURE get_proc_ownerlist(p_certification_id IN NUMBER, p_organization_id IN NUMBER, p_process_id IN NUMBER) IS
136: CURSOR c_proc_owner IS
137: SELECT to_number(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) process_owner_id
138: FROM fnd_grants grants,
139: fnd_objects obj,
140: fnd_menus granted_menu
141: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
142: AND grants.object_id = obj.object_id
143: AND grants.grantee_type = 'USER'
159:
160: CURSOR c_org_owner IS
161: SELECT to_number(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) org_owner_id
162: FROM fnd_grants grants,
163: fnd_objects obj,
164: fnd_menus granted_menu
165: WHERE obj.obj_name = 'AMW_ORGANIZATION'
166: AND grants.object_id = obj.object_id
167: AND grants.grantee_type = 'USER'
508: TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
509: process_owner_id
510: from amw_execution_scope exscope,
511: fnd_grants grants,
512: fnd_objects obj,
513: fnd_menus granted_menu
514: where exscope.ENTITY_TYPE = 'BUSIPROC_CERTIFICATION'
515: and exscope.ENTITY_ID = p_entity_id
516: and obj.obj_name = 'AMW_PROCESS_ORGANIZATION'