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: 155

            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: 168

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

Line: 170

          groupIds.delete(i - 1);

Line: 171

          groupOrderNumbers.delete(i - 1);

Line: 172

          ruleIds.delete(i - 1);

Line: 173

          parameters.delete(i - 1);

Line: 174

          parameterTwos.delete(i - 1);

Line: 175

          sources.delete(i - 1);

Line: 176

          votingRegimes.delete(i - 1);