APPS.ZPB_DVAC_WF dependencies on ZPB_MEASURE_SCOPE

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 43: delete from ZPB_MEASURE_SCOPE

39: x_vm_instance_id => l_instance_ac_id);
40:
41: --remove current instanceId row
42: -- bug 5842494: replaced with l_instance_ac_id
43: delete from ZPB_MEASURE_SCOPE
44: where INSTANCE_AC_ID = l_instance_ac_Id;
45:
46: --copy the BP definition entry as the new instance definition
47: insert into ZPB_MEASURE_SCOPE

Line 47: insert into ZPB_MEASURE_SCOPE

43: delete from ZPB_MEASURE_SCOPE
44: where INSTANCE_AC_ID = l_instance_ac_Id;
45:
46: --copy the BP definition entry as the new instance definition
47: insert into ZPB_MEASURE_SCOPE
48: (INSTANCE_AC_ID,
49: RESTRICTION_TYPE,
50: START_TIME_TYPE,
51: START_TIME_MEMBER_ID,

Line 94: update ZPB_MEASURE_SCOPE

90: where ANALYSIS_CYCLE_ID = instanceId
91: and TASK_ID = p_task_id;
92:
93: -- bug 5842494: replaced with l_instance_ac_id
94: update ZPB_MEASURE_SCOPE
95: set INSTANCE_AC_ID = l_instance_ac_id,
96: CREATED_BY = fnd_global.USER_ID,
97: CREATION_DATE = SYSDATE,
98: LAST_UPDATED_BY = fnd_global.USER_ID,

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',