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 202: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 539: tokenValueOneIn => ame_engine.getActionTypeName(tempApprover.action_type_id),

535: if l_error_code = -20213 then
536: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
537: messageNameIn => 'AME_400834_INV_HANDLR_APR',
538: tokenNameOneIn => 'ACTION_TYPE_NAME',
539: tokenValueOneIn => ame_engine.getActionTypeName(tempApprover.action_type_id),
540: tokenNameTwoIn => 'ORIG_SYSTEM',
541: tokenValueTwoIn => ame_util.perOrigSystem,
542: tokenNameThreeIn => 'ORIG_SYSEM_ID',
543: tokenValueThreeIn => tempApprover.orig_system_id);