DBA Data[Home] [Help]

APPS.AME_NON_FINAL_HANDLER dependencies on AME_ENGINE

Line 240: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));

236: l_error_code number;
237: begin
238: /* Populate some of the package variables. */
239: includeAllJobLevelApprovers := null;
240: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
241: ame_engine.getHandlerRules3(ruleIdsOut => allRuleIds,
242: ruleIndexesOut => allRuleIndexes,
243: parametersOut => actionParameters,
244: listModParameterOnesOut => listModParameterOnes,

Line 241: ame_engine.getHandlerRules3(ruleIdsOut => allRuleIds,

237: begin
238: /* Populate some of the package variables. */
239: includeAllJobLevelApprovers := null;
240: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
241: ame_engine.getHandlerRules3(ruleIdsOut => allRuleIds,
242: ruleIndexesOut => allRuleIndexes,
243: parametersOut => actionParameters,
244: listModParameterOnesOut => listModParameterOnes,
245: listModParameterTwosOut => listModParameterTwos);

Line 260: ame_engine.getHandlerLMApprovers(listModParameterOneIn => listModParameterOnes(currentRuleIdCount),

256: exit;
257: end if;
258: tempApproverIndexes.delete;
259: insertionThreshhold := 0;
260: ame_engine.getHandlerLMApprovers(listModParameterOneIn => listModParameterOnes(currentRuleIdCount),
261: listModParameterTwoIn => listModParameterTwos(currentRuleIdCount),
262: includeFyiApproversIn => false,
263: includeApprovalGroupsIn => false,
264: returnForwardeesIn => true,

Line 272: ame_engine.getApprovers(approversOut => tempApprovers);

268: finalAuthorityNotFound := true;
269: finalAuthoritySource := null;
270: tempIndex := lastForwardeeIndexes(j) + insertionThreshhold;
271: /* Get the approver list. This should be inside the loop so that we get the latest list*/
272: ame_engine.getApprovers(approversOut => tempApprovers);
273: /* Check that the action type id of the target is based on job level handler */
274: if (tempApprovers(tempIndex).action_type_id =
275: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.absoluteJobLevelTypeName) or
276: tempApprovers(tempIndex).action_type_id =

Line 275: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.absoluteJobLevelTypeName) or

271: /* Get the approver list. This should be inside the loop so that we get the latest list*/
272: ame_engine.getApprovers(approversOut => tempApprovers);
273: /* Check that the action type id of the target is based on job level handler */
274: if (tempApprovers(tempIndex).action_type_id =
275: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.absoluteJobLevelTypeName) or
276: tempApprovers(tempIndex).action_type_id =
277: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.relativeJobLevelTypeName) or
278: tempApprovers(tempIndex).action_type_id =
279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or

Line 277: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.relativeJobLevelTypeName) or

273: /* Check that the action type id of the target is based on job level handler */
274: if (tempApprovers(tempIndex).action_type_id =
275: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.absoluteJobLevelTypeName) or
276: tempApprovers(tempIndex).action_type_id =
277: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.relativeJobLevelTypeName) or
278: tempApprovers(tempIndex).action_type_id =
279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or
280: tempApprovers(tempIndex).action_type_id =
281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or

Line 279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or

275: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.absoluteJobLevelTypeName) or
276: tempApprovers(tempIndex).action_type_id =
277: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.relativeJobLevelTypeName) or
278: tempApprovers(tempIndex).action_type_id =
279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or
280: tempApprovers(tempIndex).action_type_id =
281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or
282: tempApprovers(tempIndex).action_type_id =
283: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.lineItemJobLevelTypeName) or

Line 281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or

277: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.relativeJobLevelTypeName) or
278: tempApprovers(tempIndex).action_type_id =
279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or
280: tempApprovers(tempIndex).action_type_id =
281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or
282: tempApprovers(tempIndex).action_type_id =
283: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.lineItemJobLevelTypeName) or
284: tempApprovers(tempIndex).action_type_id =
285: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.dualChainsAuthorityTypeName) )

Line 283: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.lineItemJobLevelTypeName) or

279: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.managerFinalApproverTypeName) or
280: tempApprovers(tempIndex).action_type_id =
281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or
282: tempApprovers(tempIndex).action_type_id =
283: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.lineItemJobLevelTypeName) or
284: tempApprovers(tempIndex).action_type_id =
285: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.dualChainsAuthorityTypeName) )
286: then
287: if(includeAllJobLevelApprovers is null) then

Line 285: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.dualChainsAuthorityTypeName) )

281: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.finalApproverOnlyTypeName) or
282: tempApprovers(tempIndex).action_type_id =
283: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.lineItemJobLevelTypeName) or
284: tempApprovers(tempIndex).action_type_id =
285: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.dualChainsAuthorityTypeName) )
286: then
287: if(includeAllJobLevelApprovers is null) then
288: includeAllJobLevelApprovers :=
289: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =

Line 289: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =

285: ame_engine.getActionTypeId(actionTypeNameIn => ame_util.dualChainsAuthorityTypeName) )
286: then
287: if(includeAllJobLevelApprovers is null) then
288: includeAllJobLevelApprovers :=
289: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
290: ame_util.booleanAttributeTrue;
291: end if;
292: /* First, get the orig_system_id and job level of the target approver. */
293: if tempApprovers(tempIndex).orig_system_id is null then

Line 307: ame_engine.setRuleApplied(ruleIndexIn => ruleIndexes(i));

303: threshholdJobLevel := tempJobLevel;
304: parseAndSortRules;
305: for i in 1 .. ruleIds.count loop
306: ruleSatisfiedYN(i) := ame_util.booleanFalse;
307: ame_engine.setRuleApplied(ruleIndexIn => ruleIndexes(i));
308: end loop;
309: /*
310: Third, walk the chain starting with the target and ending with the last forwardee,
311: checking for final authority.

Line 315: as this is done in the ame_engine.getHandlerLMApprovers() */

311: checking for final authority.
312: */
313: for k in tempApproverIndexes(j) .. lastForwardeeIndexes(j) loop
314: /* no need to check that the approver is in the same chain as the target approver
315: as this is done in the ame_engine.getHandlerLMApprovers() */
316: /* Check whether the approver has sufficient authority as per the
317: actionParameter defined */
318: ame_absolute_job_level_handler.getJobLevelAndSupervisor(
319: personIdIn => tempApprovers(k).orig_system_id,

Line 389: extensionApprovers(extIndex).occurrence := ame_engine.getHandlerOccurrence(

385: ame_approver_type_pkg.getWfRolesNameAndDisplayName(origSystemIn => ame_util.perOrigSystem,
386: origSystemIdIn => extensionApprovers(extIndex).orig_system_id,
387: nameOut => extensionApprovers(extIndex).name,
388: displayNameOut => extensionApprovers(extIndex).display_name);
389: extensionApprovers(extIndex).occurrence := ame_engine.getHandlerOccurrence(
390: nameIn =>extensionApprovers(extIndex).name,
391: itemClassIn => extensionApprovers(extIndex).item_class,
392: itemIdIn => extensionApprovers(extIndex).item_id,
393: actionTypeIdIn => extensionApprovers(extIndex).action_type_id,

Line 397: extensionApprovers(extIndex).approval_status := ame_engine.getHandlerApprovalStatus(

393: actionTypeIdIn => extensionApprovers(extIndex).action_type_id,
394: groupOrChainIdIn => extensionApprovers(extIndex).group_or_chain_id);
395: tempMemberOrderNumber := tempMemberOrderNumber + 1;
396: extensionApprovers(extIndex).member_order_number := tempMemberOrderNumber;
397: extensionApprovers(extIndex).approval_status := ame_engine.getHandlerApprovalStatus(
398: approverIn => extensionApprovers(extIndex));
399: /* The engine will set extensionApprovers(extIndex).approver_order_number; leave it null here. */
400: /* check to see if there is a COA insertion after this approver. If a COA
401: insertion is found, keep checking till no more COA insertions. The check

Line 407: ame_engine.getHandlerCOAInsertion(nameIn => extensionApprovers(extIndex).name,

403: loop
404: /* Initialize COAInsertee approverRecord2 */
405: COAInsertee := ame_util.emptyApproverRecord2;
406: /* Check if there are any COAInsertions */
407: ame_engine.getHandlerCOAInsertion(nameIn => extensionApprovers(extIndex).name,
408: itemClassIn => extensionApprovers(extIndex).item_class,
409: itemIdIn => extensionApprovers(extIndex).item_id,
410: actionTypeIdIn => extensionApprovers(extIndex).action_type_id,
411: groupOrChainIdIn => extensionApprovers(extIndex).group_or_chain_id,

Line 433: extensionApprovers(extIndex).action_type_id := ame_engine.getHandlerActionTypeId;

429: supervisorIdOut => tempSupervisorId);
430: extensionApprovers(extIndex).orig_system_id := tempSupervisorId;
431: extensionApprovers(extIndex).orig_system := ame_util.perOrigSystem;
432: extensionApprovers(extIndex).authority := ame_util.authorityApprover;
433: extensionApprovers(extIndex).action_type_id := ame_engine.getHandlerActionTypeId;
434: extensionApprovers(extIndex).item_class := tempApprovers(tempIndex).item_class;
435: extensionApprovers(extIndex).item_id := tempApprovers(tempIndex).item_id;
436: extensionApprovers(extIndex).item_class_order_number := tempApprovers(tempIndex).item_class_order_number;
437: extensionApprovers(extIndex).item_order_number := tempApprovers(tempIndex).item_order_number;

Line 453: extensionApprovers(extIndex).occurrence := ame_engine.getHandlerOccurrence(

449: extensionApprovers(extIndex).source := COAInsertee.source;
450: extensionApprovers(extIndex).api_insertion := ame_util.apiAuthorityInsertion;
451: tempMemberOrderNumber := tempMemberOrderNumber + 1;
452: extensionApprovers(extIndex).member_order_number := tempMemberOrderNumber;
453: extensionApprovers(extIndex).occurrence := ame_engine.getHandlerOccurrence(
454: nameIn => extensionApprovers(extIndex).name,
455: itemClassIn => extensionApprovers(extIndex).item_class,
456: itemIdIn => extensionApprovers(extIndex).item_id,
457: actionTypeIdIn => extensionApprovers(extIndex).action_type_id,

Line 460: ame_engine.getHandlerApprovalStatus(approverIn => extensionApprovers(extIndex));

456: itemIdIn => extensionApprovers(extIndex).item_id,
457: actionTypeIdIn => extensionApprovers(extIndex).action_type_id,
458: groupOrChainIdIn => extensionApprovers(extIndex).group_or_chain_id);
459: extensionApprovers(extIndex).approval_status :=
460: ame_engine.getHandlerApprovalStatus(approverIn => extensionApprovers(extIndex));
461: /* If approver has a status of ame_util.approve or
462: ame_util.approveAndForwardStatus or ame_util.nullStatus check to see
463: if approver could have final authority */
464: if extensionApprovers(extIndex).approval_status in (ame_util.approvedStatus, ame_util.approveAndForwardStatus,

Line 507: ame_engine.insertApprovers(firstIndexIn => lastForwardeeIndexes(j)+ insertionThreshhold + 1,

503: extensionApprovers(extIndex).orig_system_id := tempSupervisorId;
504: tempJobLevel := tempSupervisorJobLevel;
505: tempSupervisorId := tempNextSupervisorId;
506: end loop;
507: ame_engine.insertApprovers(firstIndexIn => lastForwardeeIndexes(j)+ insertionThreshhold + 1,
508: approversIn => extensionApprovers);
509: insertionThreshhold := insertionThreshhold + extensionApprovers.count;
510: end if;
511: end if; /* This if corresponds to the check that action type id is valid */

Line 559: tokenValueOneIn => ame_engine.getActionTypeId(actionTypeNameIn => ame_util.nonFinalAuthority),

555: if errorCode = 1 then
556: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
557: messageNameIn => 'AME_400833_INV_HANDLR_APR',
558: tokenNameOneIn => 'ACTION_TYPE_NAME',
559: tokenValueOneIn => ame_engine.getActionTypeId(actionTypeNameIn => ame_util.nonFinalAuthority),
560: tokenNameTwoIn => 'NAME',
561: tokenValueTwoIn => tempApprovers(tempIndex).name);
562: end if;
563: if errorCode = 2 then

Line 567: tokenValueOneIn => ame_engine.getActionTypeId(actionTypeNameIn => ame_util.nonFinalAuthority),

563: if errorCode = 2 then
564: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
565: messageNameIn => 'AME_400834_INV_HANDLR_APR',
566: tokenNameOneIn => 'ACTION_TYPE_NAME',
567: tokenValueOneIn => ame_engine.getActionTypeId(actionTypeNameIn => ame_util.nonFinalAuthority),
568: tokenNameTwoIn => 'ORIG_SYSTEM',
569: tokenValueTwoIn => ame_util.perOrigSystem,
570: tokenNameThreeIn => 'ORIG_SYSEM_ID',
571: tokenValueThreeIn => extensionApprovers(extIndex).orig_system_id);