DBA Data[Home] [Help]

APPS.AME_NON_FINAL_HANDLER dependencies on AME_ENGINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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