APPS.AME_DUAL_CHAINS_HANDLER SQL Statements

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

Line: 111

        /* Update hasFinalAuthorityYN as needed. */
        if(not tempRuleSatisfied and
           hasFinalAuthorityYN = ame_util.booleanTrue) then
          hasFinalAuthorityYN := ame_util.booleanFalse;

Line: 129

          /* Update source. */
          ame_util.appendRuleIdToSource(ruleIdIn => ruleIds(i),
                                        sourceInOut => source);

Line: 132

          /* Update category as needed. */
          if(category = ame_util.fyiApproverCategory and
             approverCategories(i) = ame_util.approvalApproverCategory) then
            category := ame_util.approvalApproverCategory;

Line: 174

    COAInsertee ame_util.approverRecord2;

Line: 233

        /* Check for COA 'firstAuthority' insertions */
        ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
                                              itemIdIn => tempApprover.item_id,
                                              actionTypeIdIn =>tempApprover.action_type_id,
                                              groupOrChainIdIn => chainCounter,
                                              nameOut => COAInsertee.name,
                                              origSystemOut => COAInsertee.orig_system,
                                              origSystemIdOut =>COAInsertee.orig_system_id,
                                              displayNameOut => COAInsertee.display_name,
                                              sourceOut => COAInsertee.source);

Line: 243

        if COAInsertee.name is  null then
          if chainCounter = 1 then
            /* Fetch the required attributes. */
            firstStartingPointId :=
              to_number(ame_engine.getHeaderAttValue2(attributeNameIn =>
                                          ame_util.firstStartingPointAttribute));

Line: 263

          tempApprover.api_insertion := ame_util.oamGenerated;

Line: 270

          tempApprover.name := COAInsertee.name;

Line: 271

          tempApprover.orig_system := COAInsertee.orig_system;

Line: 272

          tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 273

          tempApprover.display_name :=  COAInsertee.display_name;

Line: 274

          firstApproverSource := COAInsertee.source;

Line: 275

          tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 310

          /* reassign the value of source in case approver was a firstAuthority insertee */
          if firstApproverSource is not null then
            tempApprover.source := firstApproverSource;

Line: 341

          /* check to see if there is a COA insertion after this approver. If a COA
             insertion is found, keep checking till no more COA insertions. The check
             for final authority will need to be done again.  */
          loop
            /* Initialize COAInsertee approverRecord2 */
            COAInsertee := ame_util.emptyApproverRecord2;

Line: 347

            /* Check if there are any COAInsertions */
            ame_engine.getHandlerCOAInsertion(nameIn => tempApprover.name,
                                            itemClassIn => tempApprover.item_class,
                                            itemIdIn => tempApprover.item_id,
                                            actionTypeIdIn => tempApprover.action_type_id,
                                            groupOrChainIdIn => tempApprover.group_or_chain_id,
                                            occurrenceIn => tempApprover.occurrence,
                                            approvalStatusIn => tempApprover.approval_status,
                                            nameOut => COAInsertee.name,
                                            origSystemOut => COAInsertee.orig_system,
                                            origSystemIdOut => COAInsertee.orig_system_id,
                                            displayNameOut => COAInsertee.display_name,
                                            sourceOut => COAInsertee.source);

Line: 360

            if COAInsertee.name is null then
              exit;

Line: 363

              tempApprover.name := COAInsertee.name;

Line: 364

              tempApprover.orig_system := COAInsertee.orig_system;

Line: 365

              tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 366

              tempApprover.display_name :=  COAInsertee.display_name;

Line: 379

              tempApprover.source := COAInsertee.source;

Line: 381

              tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 442

          tempApprover.api_insertion := ame_util.oamGenerated;

Line: 537

      parameterNumbers.delete;

Line: 538

      parameterSigns.delete;

Line: 539

      approverCategories.delete;

Line: 540

      ruleIds.delete;