DBA Data[Home] [Help]

APPS.ZPB_DVAC_WF dependencies on ZPB_MEASURE_SCOPE_EXEMPT_USERS

Line 19: from zpb_measure_scope_exempt_users a

15: x_msg_data varchar2(4000);
16: x_validation_level number := FND_API.G_VALID_LEVEL_FULL;
17: cursor exempt_users is
18: select a.user_id, a.exemption_id
19: from zpb_measure_scope_exempt_users a
20: where business_process_entity_type = 'A'
21: -- bug 4587184
22: -- and business_process_entity_id = BP_ID
23: and business_process_entity_id = instanceId

Line 105: delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS

101: where INSTANCE_AC_ID = BP_ID;
102:
103: -- delete current list of exempt users for instanceId
104: -- bug 5842494: replaced with l_instance_ac_id
105: delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS
106: where BUSINESS_PROCESS_ENTITY_ID = l_instance_ac_id
107: and BUSINESS_PROCESS_ENTITY_TYPE = 'I';
108:
109: --copy entries for exempt user specification

Line 112: insert into zpb_measure_scope_exempt_users

108:
109: --copy entries for exempt user specification
110: -- bug 5842494: replaced with l_instance_ac_id
111: for each in exempt_users loop
112: insert into zpb_measure_scope_exempt_users
113: (user_id, exemption_id, business_process_entity_id,
114: business_process_entity_type, created_by, creation_date,
115: last_updated_by, last_update_date, last_update_login)
116: values(each.user_id, each.exemption_id, l_instance_ac_id, 'I',