APPS.AME_MULTI_TENANCY_PKG dependencies on AME_APPROVAL_GROUPS

Line 719: from ame_approval_Groups

715: l_ovn number;
716: --+
717: cursor chkGrp(c_name_in in varchar2) is
718: select approval_Group_id
719: from ame_approval_Groups
720: where name = c_name_in
721: and sysdate between start_date and nvl(end_Date,sysdate);
722: --+
723: cursor getGrpUpdate(c_current_grp_id in number,c_query_string in varchar2) is

Line 725: from ame_approval_groups ent

721: and sysdate between start_date and nvl(end_Date,sysdate);
722: --+
723: cursor getGrpUpdate(c_current_grp_id in number,c_query_string in varchar2) is
724: select ent.object_version_number
725: from ame_approval_groups ent
726: where ent.approval_group_id = c_current_grp_id
727: and c_query_string <> ent.query_string
728: and sysdate between ent.start_date and nvl(ent.end_Date,sysdate)
729: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse;

Line 751: update ame_approval_groups

747: ,p_start_date => l_start_date
748: ,p_end_date => l_end_Date
749: ,p_object_version_number => l_ovn
750: );
751: update ame_approval_groups
752: set created_by = getSeedUser
753: ,last_updated_by = getSeedUser
754: where approval_group_id = l_current_grp_id
755: and sysdate between start_date and nvl(end_Date,sysdate);

Line 757: update ame_approval_groups_tl

753: ,last_updated_by = getSeedUser
754: where approval_group_id = l_current_grp_id
755: and sysdate between start_date and nvl(end_Date,sysdate);
756: --
757: update ame_approval_groups_tl
758: set created_by = getSeedUser
759: ,last_updated_by = getSeedUser
760: where approval_group_id = l_current_grp_id;
761: --

Line 779: update ame_approval_groups

775: ,p_object_version_number => l_ovn
776: ,p_start_date => l_start_date
777: ,p_end_date => l_end_date
778: );
779: update ame_approval_groups
780: set created_by = getSeedUser
781: ,last_updated_by = getSeedUser
782: where approval_group_id = l_current_grp_id
783: and sysdate between start_date and nvl(end_Date,sysdate);

Line 785: update ame_approval_groups_tl

781: ,last_updated_by = getSeedUser
782: where approval_group_id = l_current_grp_id
783: and sysdate between start_date and nvl(end_Date,sysdate);
784: --
785: update ame_approval_groups_tl
786: set created_by = getSeedUser
787: ,last_updated_by = getSeedUser
788: where approval_group_id = l_current_grp_id
789: and language = userenv('LANG');

Line 809: ,ame_approval_Groups agp

805: cursor fetchTxnGroups is
806: select agp.approval_group_id
807: ,agp.name
808: from ame_approval_group_config agc
809: ,ame_approval_Groups agp
810: where agc.application_id = g_seed_appl_id
811: and agc.approval_Group_id = agp.approval_group_id
812: and sysdate between agp.start_date and nvl(agp.end_Date,sysdate)
813: and sysdate between agc.start_date and nvl(agc.end_Date,sysdate);

Line 852: from ame_approval_Groups

848: select action_id
849: from ame_actions
850: where parameter =
851: (select to_char(approval_Group_id)
852: from ame_approval_Groups
853: where name = c_name
854: and sysdate between start_Date and nvl(end_Date,sysdate))
855: and action_type_id = c_action_type_id
856: and sysdate between start_date and nvl(end_Date,sysdate);

Line 1352: from ame_approval_Groups groups

1348: ,groups.last_updated_by group_last_updated_by
1349: ,config.last_updated_by config_last_updated_by
1350: ,groups.creation_date group_creation_date
1351: ,config.creation_date config_creation_date
1352: from ame_approval_Groups groups
1353: ,ame_approval_group_config config
1354: where application_id = g_seed_appl_id
1355: and groups.approval_group_id = config.approval_group_id
1356: and sysdate between groups.start_date and nvl(groups.end_Date,sysdate)