APPS.AME_APPROVAL_GROUP_PKG dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 20: updateDependentGroups updates ame_approval_group_members for the group with

16: parametersOut out nocopy ame_util.stringList,
17: orderNumbersOut out nocopy ame_util.idList,
18: queryStringsOut out nocopy ame_util.longestStringList);
19: /*
20: updateDependentGroups updates ame_approval_group_members for the group with
21: group ID groupIdIn, and all groups depending on it (explicitly or implicitly).
22: If deleteGroupIn is true, updateDependentGroups also removes (end-dates) the
23: group with ID groupIdIn from dependent group's item lists.
24: */

Line 2797: update those groups in ame_approval_group_members.

2793: processingDate between start_date and
2794: nvl(end_date - ame_util.oneSecond, processingDate) ;
2795: /*
2796: Remove the group from any groups containing it, and
2797: update those groups in ame_approval_group_members.
2798: */
2799: updateDependentGroups(groupIdIn => approvalGroupIdIn,
2800: deleteGroupIn => true);
2801: commit;

Line 3023: delete from ame_approval_group_members

3019: tempCount integer;
3020: upperLimit integer;
3021: begin
3022: /* Clear the old nonrecursive membership list. */
3023: delete from ame_approval_group_members
3024: where approval_group_id = groupIdIn;
3025: /* Rebuid the nonrecursive membership list. */
3026: getNestedMembers(groupIdIn => groupIdIn,
3027: effectiveDateIn => effectiveDateIn,

Line 3038: from ame_approval_group_members

3034: memberIndex := 0;
3035: for i in 1 .. upperLimit loop
3036: select count(*)
3037: into tempCount
3038: from ame_approval_group_members
3039: where
3040: approval_group_id = groupIdIn and
3041: parameter_name = parameterNames(i) and
3042: parameter = parameters(i);

Line 3073: insert into ame_approval_group_members(

3069: else
3070: origSystem := null;
3071: origSystemId := null;
3072: end if;
3073: insert into ame_approval_group_members(
3074: approval_group_id,
3075: parameter_name,
3076: parameter,
3077: orig_system,

Line 3090: ame_approval_group_members_s.nextval);

3086: origSystem,
3087: origSystemId,
3088: queryStrings(i),
3089: orderNumbers(i),
3090: ame_approval_group_members_s.nextval);
3091: end if;
3092: end loop;
3093: exception
3094: when others then

Line 3147: The call to setGroupMembers below updates ame_approval_group_members for dependent

3143: if(deleteGroupIn and currentGroup > 1) then
3144: /*
3145: Delete the target group (groupIdIn) from the item list of the current group.
3146: (Don't do it for currentGroup = 1 because the group is never a member of itself.)
3147: The call to setGroupMembers below updates ame_approval_group_members for dependent
3148: groups.
3149: */
3150: update ame_approval_group_items
3151: set end_date = processingDate