eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RELATIVE_JOB_LEVEL_HANDLER dependencies on AME_ENGINE

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

196: begin
197: finalAuthorityApproverCategory := null;
198: finalAuthoritySource := null;
199: includeAllJobLevelApprovers :=
200: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
201: ame_util.booleanAttributeTrue;
202: /* Populate some of the package variables. */
203: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
204: /*

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

199: includeAllJobLevelApprovers :=
200: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
201: ame_util.booleanAttributeTrue;
202: /* Populate some of the package variables. */
203: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
204: /*
205: The engine only calls a handler if a rule requiring it exists, so we can assume that
206: the package variables that ame_engine.getHandlerRules initializes are nonempty.
207: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters

Line 206: the package variables that ame_engine.getHandlerRules initializes are nonempty.

202: /* Populate some of the package variables. */
203: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
204: /*
205: The engine only calls a handler if a rule requiring it exists, so we can assume that
206: the package variables that ame_engine.getHandlerRules initializes are nonempty.
207: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters
208: are harmless here.)
209: */
210: ame_engine.getHandlerRules2(ruleIdsOut => ruleIds,

Line 210: ame_engine.getHandlerRules2(ruleIdsOut => ruleIds,

206: the package variables that ame_engine.getHandlerRules initializes are nonempty.
207: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters
208: are harmless here.)
209: */
210: ame_engine.getHandlerRules2(ruleIdsOut => ruleIds,
211: approverCategoriesOut => approverCategories,
212: parametersOut => parameters);
213: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
214: tempApprover.orig_system := ame_util.perOrigSystem;

Line 216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;

212: parametersOut => parameters);
213: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
214: tempApprover.orig_system := ame_util.perOrigSystem;
215: tempApprover.authority := ame_util.authorityApprover;
216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;

Line 217: tempApprover.item_class := ame_engine.getHandlerItemClassName;

213: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
214: tempApprover.orig_system := ame_util.perOrigSystem;
215: tempApprover.authority := ame_util.authorityApprover;
216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;

Line 218: tempApprover.item_id := ame_engine.getHandlerItemId;

214: tempApprover.orig_system := ame_util.perOrigSystem;
215: tempApprover.authority := ame_util.authorityApprover;
216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;

Line 219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;

215: tempApprover.authority := ame_util.authorityApprover;
216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
223: tempApprover.group_or_chain_order_number := 1;

Line 220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;

216: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
223: tempApprover.group_or_chain_order_number := 1;
224: tempApprover.group_or_chain_id := 1;

Line 221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;

217: tempApprover.item_class := ame_engine.getHandlerItemClassName;
218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
223: tempApprover.group_or_chain_order_number := 1;
224: tempApprover.group_or_chain_id := 1;
225: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);

Line 222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;

218: tempApprover.item_id := ame_engine.getHandlerItemId;
219: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
220: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
223: tempApprover.group_or_chain_order_number := 1;
224: tempApprover.group_or_chain_id := 1;
225: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
226: /* Check for COA 'firstAuthority' insertions */

Line 225: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);

221: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
222: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
223: tempApprover.group_or_chain_order_number := 1;
224: tempApprover.group_or_chain_id := 1;
225: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
226: /* Check for COA 'firstAuthority' insertions */
227: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
228: itemIdIn => tempApprover.item_id,
229: actionTypeIdIn => tempApprover.action_type_id,

Line 227: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,

223: tempApprover.group_or_chain_order_number := 1;
224: tempApprover.group_or_chain_id := 1;
225: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
226: /* Check for COA 'firstAuthority' insertions */
227: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
228: itemIdIn => tempApprover.item_id,
229: actionTypeIdIn => tempApprover.action_type_id,
230: groupOrChainIdIn => tempApprover.group_or_chain_id,
231: nameOut => COAInsertee.name,

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

235: sourceOut => COAInsertee.source);
236: if COAInsertee.name is null then
237: /* Fetch some of the required attributes. */
238: startingPointId :=
239: to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.jobLevelStartingPointAttribute));
240: if(startingPointId is null) then
241: requestorId :=
242: to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.transactionRequestorAttribute));
243: if (requestorId is null) then

Line 242: to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.transactionRequestorAttribute));

238: startingPointId :=
239: to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.jobLevelStartingPointAttribute));
240: if(startingPointId is null) then
241: requestorId :=
242: to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.transactionRequestorAttribute));
243: if (requestorId is null) then
244: raise nullFirstIdException;
245: end if;
246: tempApprover.orig_system_id := requestorId;

Line 283: if(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowAutoApprovalAttribute)

279: startingPointId is null )
280: then
281: /* Check to make sure requestor is not the topDogPersonId, if yes check for autoapproval */
282: if (requestorId = topDogPersonId ) then
283: if(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowAutoApprovalAttribute)
284: = ame_util.booleanAttributeTrue) then
285: /* insert the requestor into the chain set the requestor's status to approved
286: end the chain with the requestor */
287: tempApprover.orig_system_id := requestorId;

Line 296: tempApprover.occurrence := ame_engine.getHandlerOccurrence(

292: sourceOut => tempApprover.source,
293: hasFinalAuthorityYNOut => tempHasFinalAuthorityYN,
294: supervisorJobLevelOut => tempSupervisorJobLevel,
295: nextSupervisorIdOut => tempNextSupervisorId);
296: tempApprover.occurrence := ame_engine.getHandlerOccurrence(
297: nameIn => tempApprover.name,
298: itemClassIn => tempApprover.item_class,
299: itemIdIn => tempApprover.item_id,
300: actionTypeIdIn => tempApprover.action_type_id,

Line 309: ame_engine.addApprover(approverIn => tempApprover);

305: ame_approver_type_pkg.getWfRolesNameAndDisplayName(origSystemIn => ame_util.perOrigSystem,
306: origSystemIdIn => tempApprover.orig_system_id,
307: nameOut => tempApprover.name,
308: displayNameOut => tempApprover.display_name);
309: ame_engine.addApprover(approverIn => tempApprover);
310: return;
311: else
312: raise topDogRequestorException;
313: end if;

Line 364: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);

360: tempApprover.member_order_number := tempMemberOrderNumber;
361: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
362: tempApprover.member_order_number := 1;
363: end if;
364: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
365: /* The engine will set tempApprover.approver_order_number; leave it null here. */
366: ame_engine.addApprover(approverIn => tempApprover);
367: /* check to see if there is a COA insertion after this approver. If a COA insertion is
368: found, keep checking till no more COA insertions. The check for final authority will need to be

Line 366: ame_engine.addApprover(approverIn => tempApprover);

362: tempApprover.member_order_number := 1;
363: end if;
364: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
365: /* The engine will set tempApprover.approver_order_number; leave it null here. */
366: ame_engine.addApprover(approverIn => tempApprover);
367: /* check to see if there is a COA insertion after this approver. If a COA insertion is
368: found, keep checking till no more COA insertions. The check for final authority will need to be
369: done again.
370: */

Line 375: ame_engine.getHandlerCOAInsertion(nameIn => tempApprover.name,

371: loop
372: /* Initialize COAInsertee approverRecord2 */
373: COAInsertee := ame_util.emptyApproverRecord2;
374: /* Check if there are any COAInsertions */
375: ame_engine.getHandlerCOAInsertion(nameIn => tempApprover.name,
376: itemClassIn => tempApprover.item_class,
377: itemIdIn => tempApprover.item_id,
378: actionTypeIdIn => tempApprover.action_type_id,
379: groupOrChainIdIn => tempApprover.group_or_chain_id,

Line 416: tempApprover.occurrence := ame_engine.getHandlerOccurrence(nameIn => tempApprover.name,

412: tempApprover.member_order_number := tempMemberOrderNumber;
413: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
414: tempApprover.member_order_number := 1;
415: end if;
416: tempApprover.occurrence := ame_engine.getHandlerOccurrence(nameIn => tempApprover.name,
417: itemClassIn => tempApprover.item_class,
418: itemIdIn => tempApprover.item_id,
419: actionTypeIdIn => tempApprover.action_type_id,
420: groupOrChainIdIn => tempApprover.group_or_chain_id);

Line 421: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);

417: itemClassIn => tempApprover.item_class,
418: itemIdIn => tempApprover.item_id,
419: actionTypeIdIn => tempApprover.action_type_id,
420: groupOrChainIdIn => tempApprover.group_or_chain_id);
421: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
422: /* If approver has a status of ame_util.approve or ame_util.approveAndForwardStatus or
423: ame_util.nullStatus check to see if approver could have final authority */
424: if ((tempApprover.approval_status is null) or
425: (tempApprover.approval_status in

Line 437: ame_engine.addApprover(approverIn => tempApprover);

433: tempHasFinalAuthorityYN = ame_util.booleanTrue) then
434: finalAuthorityFound := true;
435: end if;
436: end if;
437: ame_engine.addApprover(approverIn => tempApprover);
438: end if;
439: end loop;
440: /* Decide whether to end the chain. */
441: if(topDogFound or

Line 475: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);

471: origSystemIdIn =>tempApprover.orig_system_id,
472: nameOut => tempApprover.name,
473: displayNameOut => tempApprover.display_name);
474: if firstAuthInsExists then
475: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
476: end if;
477: if coaInsAuthForward then
478: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
479: end if;

Line 478: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);

474: if firstAuthInsExists then
475: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
476: end if;
477: if coaInsAuthForward then
478: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
479: end if;
480: end loop;
481: exception
482: when noSupervisorException then