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_DUAL_CHAINS_HANDLER dependencies on AME_ENGINE

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

199: coaInsAuthForward boolean := false;
200: l_error_code number;
201: begin
202: includeAllJobLevelApprovers :=
203: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
204: ame_util.booleanAttributeTrue;
205: /* Populate some of the package variables. */
206: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
207: /* Set the fields in tempApprover that are constant for the entire handler cycle. */

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

202: includeAllJobLevelApprovers :=
203: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
204: ame_util.booleanAttributeTrue;
205: /* Populate some of the package variables. */
206: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
207: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
208: tempApprover.orig_system := ame_util.perOrigSystem;
209: tempApprover.authority := ame_util.authorityApprover;
210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;

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

206: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
207: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
208: tempApprover.orig_system := ame_util.perOrigSystem;
209: tempApprover.authority := ame_util.authorityApprover;
210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;

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

207: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
208: tempApprover.orig_system := ame_util.perOrigSystem;
209: tempApprover.authority := ame_util.authorityApprover;
210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;

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

208: tempApprover.orig_system := ame_util.perOrigSystem;
209: tempApprover.authority := ame_util.authorityApprover;
210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;

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

209: tempApprover.authority := ame_util.authorityApprover;
210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);

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

210: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);

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

211: tempApprover.item_class := ame_engine.getHandlerItemClassName;
212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
219: /*

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

212: tempApprover.item_id := ame_engine.getHandlerItemId;
213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
219: /*
220: The engine only calls a handler if a rule requiring it exists, so we can assume that

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

213: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
219: /*
220: The engine only calls a handler if a rule requiring it exists, so we can assume that
221: the package variables that ame_engine.getHandlerRules initializes are nonempty.

Line 218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);

214: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
215: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
216: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
219: /*
220: The engine only calls a handler if a rule requiring it exists, so we can assume that
221: the package variables that ame_engine.getHandlerRules initializes are nonempty.
222: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters

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

217: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
218: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
219: /*
220: The engine only calls a handler if a rule requiring it exists, so we can assume that
221: the package variables that ame_engine.getHandlerRules initializes are nonempty.
222: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters
223: are harmless here.)
224: */
225: ame_engine.getHandlerRules2(ruleIdsOut => ruleIdsDual,

Line 225: ame_engine.getHandlerRules2(ruleIdsOut => ruleIdsDual,

221: the package variables that ame_engine.getHandlerRules initializes are nonempty.
222: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters
223: are harmless here.)
224: */
225: ame_engine.getHandlerRules2(ruleIdsOut => ruleIdsDual,
226: approverCategoriesOut => approverCategoriesDual,
227: parametersOut => parameters);
228: parametersCount := parameters.count;
229: for chainCounter in 1..2 loop

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

232: coaInsAuthForward := false;
233: finalAuthorityApproverCategory := null;
234: finalAuthoritySource := null;
235: /* Check for COA 'firstAuthority' insertions */
236: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
237: itemIdIn => tempApprover.item_id,
238: actionTypeIdIn =>tempApprover.action_type_id,
239: groupOrChainIdIn => chainCounter,
240: nameOut => COAInsertee.name,

Line 249: to_number(ame_engine.getHeaderAttValue2(attributeNameIn =>

245: if COAInsertee.name is null then
246: if chainCounter = 1 then
247: /* Fetch the required attributes. */
248: firstStartingPointId :=
249: to_number(ame_engine.getHeaderAttValue2(attributeNameIn =>
250: ame_util.firstStartingPointAttribute));
251: if(firstStartingPointId is null ) then
252: raise nullFirstIdException;
253: end if;

Line 258: to_number(ame_engine.getHeaderAttValue2(attributeNameIn =>

254: tempApprover.orig_system_id := firstStartingPointId;
255: else /* Chain is 2*/
256: /* Fetch the required attributes. */
257: secondStartingPointId :=
258: to_number(ame_engine.getHeaderAttValue2(attributeNameIn =>
259: ame_util.secondStartingPointAttribute));
260: if( secondStartingPointId is null) then
261: raise nullSecondIdException;
262: end if;

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

325: finalAuthoritySource is not null ) then
326: tempApprover.approver_category := finalAuthorityApproverCategory;
327: tempApprover.source := finalAuthoritySource;
328: end if;
329: tempApprover.occurrence := ame_engine.getHandlerOccurrence(nameIn=>tempApprover.name,
330: itemClassIn => tempApprover.item_class,
331: itemIdIn => tempApprover.item_id,
332: actionTypeIdIn => tempApprover.action_type_id,
333: groupOrChainIdIn => tempApprover.group_or_chain_id);

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

337: tempApprover.member_order_number := tempMemberOrderNumber;
338: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
339: tempApprover.member_order_number := 1;
340: end if;
341: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
342: /* The engine will set tempApprover.approver_order_number; leave it null here. */
343: ame_engine.addApprover(approverIn => tempApprover);
344: /* check to see if there is a COA insertion after this approver. If a COA
345: insertion is found, keep checking till no more COA insertions. The check

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

339: tempApprover.member_order_number := 1;
340: end if;
341: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
342: /* The engine will set tempApprover.approver_order_number; leave it null here. */
343: ame_engine.addApprover(approverIn => tempApprover);
344: /* check to see if there is a COA insertion after this approver. If a COA
345: insertion is found, keep checking till no more COA insertions. The check
346: for final authority will need to be done again. */
347: loop

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

347: loop
348: /* Initialize COAInsertee approverRecord2 */
349: COAInsertee := ame_util.emptyApproverRecord2;
350: /* Check if there are any COAInsertions */
351: ame_engine.getHandlerCOAInsertion(nameIn => tempApprover.name,
352: itemClassIn => tempApprover.item_class,
353: itemIdIn => tempApprover.item_id,
354: actionTypeIdIn => tempApprover.action_type_id,
355: groupOrChainIdIn => tempApprover.group_or_chain_id,

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

387: tempApprover.member_order_number := tempMemberOrderNumber;
388: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
389: tempApprover.member_order_number := 1;
390: end if;
391: tempApprover.occurrence := ame_engine.getHandlerOccurrence(nameIn => tempApprover.name,
392: itemClassIn => tempApprover.item_class,
393: itemIdIn => tempApprover.item_id,
394: actionTypeIdIn => tempApprover.action_type_id,
395: groupOrChainIdIn => tempApprover.group_or_chain_id);

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

392: itemClassIn => tempApprover.item_class,
393: itemIdIn => tempApprover.item_id,
394: actionTypeIdIn => tempApprover.action_type_id,
395: groupOrChainIdIn => tempApprover.group_or_chain_id);
396: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
397: /* If approver has a status of ame_util.approve or ame_util.approveAndForwardStatus or
398: ame_util.nullStatus check to see if approver could have final authority */
399: if ((tempApprover.approval_status is null) or
400: (tempApprover.approval_status in

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

408: tempHasFinalAuthorityYN = ame_util.booleanTrue) then
409: finalAuthorityFound := true;
410: end if;
411: end if;
412: ame_engine.addApprover(approverIn => tempApprover);
413: coaInsAuthForward := true;
414: end if;
415: end loop;
416: /* Decide whether to end the chain. */

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

448: origSystemIdIn => tempApprover.orig_system_id,
449: nameOut => tempApprover.name,
450: displayNameOut => tempApprover.display_name);
451: if firstAuthInsExists then
452: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
453: end if;
454: if coaInsAuthForward then
455: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
456: end if;

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

451: if firstAuthInsExists then
452: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
453: end if;
454: if coaInsAuthForward then
455: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
456: end if;
457: end loop;
458: end loop;
459: exception

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

525: if l_error_code = -20213 then
526: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
527: messageNameIn => 'AME_400834_INV_HANDLR_APR',
528: tokenNameOneIn => 'ACTION_TYPE_NAME',
529: tokenValueOneIn => ame_engine.getActionTypeName(tempApprover.action_type_id),
530: tokenNameTwoIn => 'ORIG_SYSTEM',
531: tokenValueTwoIn => ame_util.perOrigSystem,
532: tokenNameThreeIn => 'ORIG_SYSEM_ID',
533: tokenValueThreeIn => tempApprover.orig_system_id);