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 160: ,ame_approval_group_members_s.nextval

156: ,r2.ord_no
157: ,null
158: ,l_orig_system
159: ,l_orig_system_id
160: ,ame_approval_group_members_s.nextval
161: );
162: end loop;
163: delete from ame_approval_group_members where approval_group_id = hr_api.g_number;
164: else

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

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

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

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

Line 296: --ame_approval_group_members table using refresh_group_dependents

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

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

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

Line 1536: --update ame_approval_Group_members table to update order_number

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