APPS.AME_SUPERVISORY_HANDLER SQL Statements

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

Line: 36

      select supervisor_id
      into supervisorPersonId
      from
        per_all_assignments_f
      where
        person_id = personIdIn and
        per_all_assignments_f.primary_flag = 'Y' and
        per_all_assignments_f.assignment_type in ('E','C') and
        per_all_assignments_f.assignment_status_type_id not in
          (select assignment_status_type_id
             from per_assignment_status_types
             where per_system_status = 'TERM_ASSIGN') and
        trunc(sysdate) between
          per_all_assignments_f.effective_start_date and
          per_all_assignments_f.effective_end_date;

Line: 158

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

Line: 176

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

Line: 179

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

Line: 201

    COAInsertee ame_util.approverRecord2;

Line: 253

      /* Check for COA 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: 264

        Start building the chain from the COA Insertee if defined otherwise from the non-default
        starting point or the requestor's supervisor.
      */
      if COAInsertee.name is  null then
        /* Fetch some of the required attributes. */
        startingPointId :=
          to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.supStartingPointAttribute));

Line: 293

              tempApprover.api_insertion := ame_util.oamGenerated;

Line: 311

        tempApprover.api_insertion := ame_util.oamGenerated;

Line: 317

        tempApprover.name := COAInsertee.name;

Line: 318

        tempApprover.orig_system := COAInsertee.orig_system;

Line: 319

        tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 320

        tempApprover.display_name :=  COAInsertee.display_name;

Line: 321

        firstApproverSource := COAInsertee.source;

Line: 322

        tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 333

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

Line: 358

        /* 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.
        */
        currentApproverPersonId := tempApprover.orig_system_id;

Line: 363

          /* Initialize COAInsertee approver record 2 */
          COAInsertee := ame_util.emptyApproverRecord2;

Line: 365

          /* Check if there are any chain of authority insertions */
          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: 378

          if COAInsertee.name is  null then
            exit;

Line: 381

            if COAInsertee.source <> ame_util.specialForwardInsertion then
              coaInsAuthForward := true;

Line: 383

              currentApproverPersonId := COAInsertee.orig_system_id;

Line: 385

            tempApprover.name := COAInsertee.name;

Line: 386

            tempApprover.orig_system := COAInsertee.orig_system;

Line: 387

            tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 388

            tempApprover.display_name :=  COAInsertee.display_name;

Line: 389

            tempApprover.source := COAInsertee.source;

Line: 391

            tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 419

        /*if the next approver because of first auth insertion the populate the date and reason*/
        if firstAuthInsExists then
          ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);

Line: 426

        tempApprover.api_insertion := ame_util.oamGenerated;