APPS.AME_RELATIVE_JOB_LEVEL_HANDLER SQL Statements

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

Line: 109

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

Line: 127

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

Line: 130

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

Line: 171

    COAInsertee ame_util.approverRecord2;

Line: 226

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

Line: 236

      if COAInsertee.name is  null then
        /* Fetch some of the required attributes. */
        startingPointId :=
            to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.jobLevelStartingPointAttribute));

Line: 255

        tempApprover.api_insertion := ame_util.oamGenerated;

Line: 257

        tempApprover.name := COAInsertee.name;

Line: 258

        tempApprover.orig_system := COAInsertee.orig_system;

Line: 259

        tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 260

        tempApprover.display_name :=  COAInsertee.display_name;

Line: 261

        firstApproverSource := COAInsertee.source;

Line: 262

        tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 276

         But in case of no COAInsertion and no startingPointId, the chain must start from requestor's manager. This could
         not be set above as the threshhold has to be the requestor's approval authority. */
      if(COAInsertee.name is null and
         startingPointId is null )
        then
        /* Check to make sure requestor is not the topDogPersonId, if yes check for autoapproval */
        if (requestorId = topDogPersonId ) then
            if(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowAutoApprovalAttribute)
                 = ame_util.booleanAttributeTrue) then
              /* insert the requestor into the chain set the requestor's status to approved
                 end the chain with the requestor */
              tempApprover.orig_system_id := requestorId;

Line: 303

              tempApprover.api_insertion := ame_util.oamGenerated;

Line: 340

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

Line: 356

        tempApprover.api_insertion := ame_util.oamGenerated;

Line: 367

        /* 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: 374

          /* 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: 387

          if COAInsertee.name is null then
            exit;

Line: 390

            tempApprover.name := COAInsertee.name;

Line: 391

            tempApprover.orig_system := COAInsertee.orig_system;

Line: 392

            tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 393

            tempApprover.display_name :=  COAInsertee.display_name;

Line: 407

            tempApprover.source := COAInsertee.source;

Line: 409

            tempApprover.api_insertion := ame_util.apiAuthorityInsertion;