APPS.AME_APPROVER_GROUP_API dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 99: -- delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);

95: end if;
96:
97: for idx in 1 .. l_grp_id_list.count loop
98:
99: -- delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
100:
101: if p_delete_group = false or l_grp_id_list(idx) <> p_approval_group_id then
102: update ame_approval_group_members
103: set approval_group_id = hr_api.g_number

Line 102: update ame_approval_group_members

98:
99: -- delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
100:
101: if p_delete_group = false or l_grp_id_list(idx) <> p_approval_group_id then
102: update ame_approval_group_members
103: set approval_group_id = hr_api.g_number
104: where approval_group_id = l_grp_id_list(idx);
105:
106: for r2 in c_expanded_nested_grps( l_grp_id_list(idx)) loop

Line 125: from ame_approval_group_members

121: exception
122: when no_data_found then
123: select orig_system, orig_system_id
124: into l_orig_system, l_orig_system_id
125: from ame_approval_group_members
126: where approval_group_id = hr_api.g_number
127: and parameter_name = 'wf_roles_name'
128: and parameter =r2.param
129: and rownum <2;

Line 139: insert into ame_approval_group_members

135: where to_char(approval_group_id) = r2.param
136: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
137: end if;
138:
139: insert into ame_approval_group_members
140: (
141: approval_group_id
142: ,parameter_name
143: ,parameter

Line 161: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;

157: ,l_orig_system
158: ,l_orig_system_id
159: );
160: end loop;
161: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;
162: else
163: delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
164: end if;
165: end loop;

Line 163: delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);

159: );
160: end loop;
161: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;
162: else
163: delete from ame_approval_group_members where approval_group_id = l_grp_id_list(idx);
164: end if;
165: end loop;
166: exception
167: when others then

Line 294: --ame_approval_group_members table using refresh_group_dependents

290: end loop;
291:
292: --
293: --if the created group is dynamic, then we have to update the
294: --ame_approval_group_members table using refresh_group_dependents
295: --
296: if p_is_static = 'N' then
297: refresh_group_dependents(p_approval_group_id => l_approval_group_id);
298: end if;

Line 490: --need to be updated in ame_approval_group_members table also.

486: end loop;
487: end if;
488: --
489: --since we are updating the group, values like query_string,
490: --need to be updated in ame_approval_group_members table also.
491: --Also in case a static group is updated into a dynamic group,
492: --we need to update members table.
493: --
494: refresh_group_dependents(p_approval_group_id => p_approval_group_id);

Line 1534: --update ame_approval_Group_members table to update order_number

1530: ,p_object_version_number => p_object_version_number
1531: ,p_start_date => l_start_date
1532: ,p_end_date => l_end_date
1533: );
1534: --update ame_approval_Group_members table to update order_number
1535: --of dependent groups
1536:
1537: refresh_group_dependents(p_approval_group_id => l_approval_group_id);
1538: --