APPS.AME_AG_HANDLERS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 62

      tempApprover.api_insertion := ame_util.oamGenerated;

Line: 80

        tempApproverNames.delete;

Line: 81

        tempApproverOrderNumbers.delete;

Line: 82

        tempApproverDisplayNames.delete;

Line: 83

        tempOrigSystemIds.delete;

Line: 84

        tempOrigSystems.delete;

Line: 156

            Preserve the deleted rule's ID in the preserved rule's source field, if space permits.
            In the very unlikely event otherwise, silently omit the extra source value(s).  (This
            is the same functionality as ame_util.appendRuleIdToSource, but here we could be
            appending several rule IDs, so we can't use that procedure.)
          */
          if(lengthb(sources(i - 1)) + lengthb(sources(i)) + 1 <= ame_util.longStringTypeLength) then
            sources(i) := sources(i) || ame_util.fieldDelimiter || sources(i - 1);

Line: 169

          /* Delete the duplicate group. */
          approverCategories.delete(i - 1);

Line: 171

          groupIds.delete(i - 1);

Line: 172

          groupOrderNumbers.delete(i - 1);

Line: 173

          ruleIds.delete(i - 1);

Line: 174

          parameters.delete(i - 1);

Line: 175

          parameterTwos.delete(i - 1);

Line: 176

          sources.delete(i - 1);

Line: 177

          votingRegimes.delete(i - 1);