APPS.AME_POSITION_HANDLER SQL Statements

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

Line: 104

    COAInsertee ame_util.approverRecord2;

Line: 149

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

      /* Start building the chain from the COA Insertee if defined otherwise from the
         non-default starting point or the requestor's supervisor.  */
      isRequestor := true;

Line: 162

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

Line: 173

          /* Check if requestor can self approve. If so, insert the approver as the
             only approver, with a status of approved, and return.*/
          if(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowAutoApprovalAttribute)
                 = ame_util.booleanAttributeTrue)
            then
            getCatSourceAndAuthority(positionIdIn           => requestorId,
                                 categoryOut            => tempApprover.approver_category,
                                 sourceOut              => tempApprover.source,
                                 hasFinalAuthorityYNOut => tempHasFinalAuthorityYN);

Line: 183

              tempApprover.api_insertion := ame_util.oamGenerated;

Line: 210

        tempApprover.api_insertion := ame_util.oamGenerated;

Line: 216

        tempApprover.name := COAInsertee.name;

Line: 217

        tempApprover.orig_system := COAInsertee.orig_system;

Line: 218

        tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 219

        tempApprover.display_name :=  COAInsertee.display_name;

Line: 220

        firstApproverSource := COAInsertee.source;

Line: 221

        tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 251

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

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

          if COAInsertee.name is null then
            exit;

Line: 274

            tempApprover.name := COAInsertee.name;

Line: 275

            tempApprover.orig_system := COAInsertee.orig_system;

Line: 276

            tempApprover.orig_system_id := COAInsertee.orig_system_id;

Line: 277

            tempApprover.display_name :=  COAInsertee.display_name;

Line: 282

            tempApprover.source := COAInsertee.source;

Line: 283

            tempApprover.api_insertion := ame_util.apiAuthorityInsertion;

Line: 325

        tempApprover.api_insertion := ame_util.oamGenerated;