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

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

194: l_error_code number;
195: begin
196: errorCode := -20236;
197: includeAllJobLevelApprovers :=
198: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.includeAllApproversAttribute) =
199: ame_util.booleanAttributeTrue;
200: /* Populate some of the package variables. */
201: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
202: /* Set the fields in tempApprover that are constant for the entire handler cycle. */

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

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

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

201: topDogPersonId := to_number(ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.topSupPersonIdAttribute));
202: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
203: tempApprover.orig_system := ame_util.perOrigSystem;
204: tempApprover.authority := ame_util.authorityApprover;
205: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;

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

202: /* Set the fields in tempApprover that are constant for the entire handler cycle. */
203: tempApprover.orig_system := ame_util.perOrigSystem;
204: tempApprover.authority := ame_util.authorityApprover;
205: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
210: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;

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

203: tempApprover.orig_system := ame_util.perOrigSystem;
204: tempApprover.authority := ame_util.authorityApprover;
205: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
210: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
211: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);

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

204: tempApprover.authority := ame_util.authorityApprover;
205: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
210: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
211: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
212: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);

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

205: tempApprover.action_type_id := ame_engine.getHandlerActionTypeId;
206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
210: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
211: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
212: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
213: /*

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

206: tempApprover.item_class := ame_engine.getHandlerItemClassName;
207: tempApprover.item_class_order_number := ame_engine.getHandlerItemClassOrderNumber;
208: tempApprover.item_order_number := ame_engine.getHandlerItemOrderNumber;
209: tempApprover.sub_list_order_number := ame_engine.getHandlerSublistOrderNum;
210: tempApprover.action_type_order_number := ame_engine.getHandlerActionTypeOrderNum;
211: votingRegimeType := ame_engine.getActionTypeVotingRegime(actionTypeIdIn => tempApprover.action_type_id);
212: chainOrderMode := ame_engine.getActionTypeChainOrderMode(actionTypeIdIn => tempApprover.action_type_id);
213: /*
214: The engine only calls a handler if a rule requiring it exists, so we can assume that

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

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

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

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

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

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

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

215: the package variables that ame_engine.getHandlerRules initializes are nonempty.
216: Fetch the rules and sort them in increasing parameter order. (Duplicate parameters
217: are harmless here.)
218: */
219: ame_engine.getHandlerRules2(ruleIdsOut => ruleIds,
220: approverCategoriesOut => approverCategories,
221: parametersOut => parameters);
222: parametersCount := parameters.count;
223: /* get the Item class Id for Line Item Item class */

Line 224: itemClassId := ame_engine.getItemClassId(itemClassNameIn => ame_util.lineItemItemClassName);

220: approverCategoriesOut => approverCategories,
221: parametersOut => parameters);
222: parametersCount := parameters.count;
223: /* get the Item class Id for Line Item Item class */
224: itemClassId := ame_engine.getItemClassId(itemClassNameIn => ame_util.lineItemItemClassName);
225: /* call ame_engine.getItemClassItemIds() to get the item Id list */
226: ame_engine.getItemClassItemIds(itemClassIdIn => itemClassId,
227: itemIdsOut => itemIds);
228: for chainCounter in 1..itemIds.count loop

Line 225: /* call ame_engine.getItemClassItemIds() to get the item Id list */

221: parametersOut => parameters);
222: parametersCount := parameters.count;
223: /* get the Item class Id for Line Item Item class */
224: itemClassId := ame_engine.getItemClassId(itemClassNameIn => ame_util.lineItemItemClassName);
225: /* call ame_engine.getItemClassItemIds() to get the item Id list */
226: ame_engine.getItemClassItemIds(itemClassIdIn => itemClassId,
227: itemIdsOut => itemIds);
228: for chainCounter in 1..itemIds.count loop
229: errorCode := -20236;

Line 226: ame_engine.getItemClassItemIds(itemClassIdIn => itemClassId,

222: parametersCount := parameters.count;
223: /* get the Item class Id for Line Item Item class */
224: itemClassId := ame_engine.getItemClassId(itemClassNameIn => ame_util.lineItemItemClassName);
225: /* call ame_engine.getItemClassItemIds() to get the item Id list */
226: ame_engine.getItemClassItemIds(itemClassIdIn => itemClassId,
227: itemIdsOut => itemIds);
228: for chainCounter in 1..itemIds.count loop
229: errorCode := -20236;
230: firstAuthInsExists := false;

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

231: coaInsAuthForward := false;
232: finalAuthorityApproverCategory := null;
233: finalAuthoritySource := null;
234: /* Set the tempApprover variables for this line item cycle */
235: tempApprover.item_id := ame_engine.getHandlerItemId;
236: tempApprover.group_or_chain_id := chainCounter;
237: /* Check for COA 'firstAuthority' insertions */
238: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
239: itemIdIn => tempApprover.item_id,

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

234: /* Set the tempApprover variables for this line item cycle */
235: tempApprover.item_id := ame_engine.getHandlerItemId;
236: tempApprover.group_or_chain_id := chainCounter;
237: /* Check for COA 'firstAuthority' insertions */
238: ame_engine.getHandlerCOAFirstApprover(itemClassIn => tempApprover.item_class,
239: itemIdIn => tempApprover.item_id,
240: actionTypeIdIn =>tempApprover.action_type_id,
241: groupOrChainIdIn => chainCounter,
242: nameOut => COAInsertee.name,

Line 248: /* call ame_engine.getItemAttValue2() inside the loop to get the line

244: origSystemIdOut =>COAInsertee.orig_system_id,
245: displayNameOut => COAInsertee.display_name,
246: sourceOut => COAInsertee.source);
247: if COAInsertee.name is null then
248: /* call ame_engine.getItemAttValue2() inside the loop to get the line
249: item starting point person id */
250: lineItemStartingPointPersonId := to_number(ame_engine.getItemAttValue2(
251: attributeNameIn => ame_util.lineItemStartingPointAttribute,
252: itemIdIn => itemIds(chainCounter)));

Line 250: lineItemStartingPointPersonId := to_number(ame_engine.getItemAttValue2(

246: sourceOut => COAInsertee.source);
247: if COAInsertee.name is null then
248: /* call ame_engine.getItemAttValue2() inside the loop to get the line
249: item starting point person id */
250: lineItemStartingPointPersonId := to_number(ame_engine.getItemAttValue2(
251: attributeNameIn => ame_util.lineItemStartingPointAttribute,
252: itemIdIn => itemIds(chainCounter)));
253: if(lineItemStartingPointPersonId is null ) then
254: raise nullFirstIdException;

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

308: tempApprover.approver_category := finalAuthorityApproverCategory;
309: tempApprover.source := finalAuthoritySource;
310: end if;
311: tempApprover.api_insertion := ame_util.oamGenerated;
312: tempApprover.occurrence := ame_engine.getHandlerOccurrence(
313: nameIn=>tempApprover.name,
314: itemClassIn => tempApprover.item_class,
315: itemIdIn => tempApprover.item_id,
316: actionTypeIdIn => tempApprover.action_type_id,

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

320: tempApprover.member_order_number := tempMemberOrderNumber;
321: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
322: tempApprover.member_order_number := 1;
323: end if;
324: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
325: /* The engine will set tempApprover.approver_order_number; leave it null here. */
326: ame_engine.addApprover(approverIn => tempApprover);
327: /* check to see if there is a COA insertion after this approver. If a COA
328: insertion is found, keep checking till no more COA insertions. The check

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

322: tempApprover.member_order_number := 1;
323: end if;
324: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
325: /* The engine will set tempApprover.approver_order_number; leave it null here. */
326: ame_engine.addApprover(approverIn => tempApprover);
327: /* check to see if there is a COA insertion after this approver. If a COA
328: insertion is found, keep checking till no more COA insertions. The check
329: for final authority will need to be done again. */
330: loop

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

330: loop
331: /* Initialize COAInsertee approverRecord2 */
332: COAInsertee := ame_util.emptyApproverRecord2;
333: /* Check if there are any COAInsertions */
334: ame_engine.getHandlerCOAInsertion(nameIn => tempApprover.name,
335: itemClassIn => tempApprover.item_class,
336: itemIdIn => tempApprover.item_id,
337: actionTypeIdIn => tempApprover.action_type_id,
338: groupOrChainIdIn => tempApprover.group_or_chain_id,

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

369: tempApprover.member_order_number := tempMemberOrderNumber;
370: else /* votingRegimeType in (ame_util.consensusVoting, ame_util.firstApproverVoting) */
371: tempApprover.member_order_number := 1;
372: end if;
373: tempApprover.occurrence := ame_engine.getHandlerOccurrence(nameIn => tempApprover.name,
374: itemClassIn => tempApprover.item_class,
375: itemIdIn => tempApprover.item_id,
376: actionTypeIdIn => tempApprover.action_type_id,
377: groupOrChainIdIn => tempApprover.group_or_chain_id);

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

374: itemClassIn => tempApprover.item_class,
375: itemIdIn => tempApprover.item_id,
376: actionTypeIdIn => tempApprover.action_type_id,
377: groupOrChainIdIn => tempApprover.group_or_chain_id);
378: tempApprover.approval_status := ame_engine.getHandlerApprovalStatus(approverIn => tempApprover);
379: /* If approver has a status of ame_util.approve or ame_util.approveAndForwardStatus or
380: ame_util.nullStatus check to see if approver could have final authority */
381: if ((tempApprover.approval_status is null) or
382: (tempApprover.approval_status in

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

390: tempHasFinalAuthorityYN = ame_util.booleanTrue) then
391: finalAuthorityFound := true;
392: end if;
393: end if;
394: ame_engine.addApprover(approverIn => tempApprover);
395: coaInsAuthForward := true;
396: end if;
397: end loop;
398: /* Decide whether to end the chain. */

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

428: origSystemIdIn => tempApprover.orig_system_id,
429: nameOut => tempApprover.name,
430: displayNameOut => tempApprover.display_name);
431: if firstAuthInsExists then
432: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
433: end if;
434: if coaInsAuthForward then
435: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
436: end if;

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

431: if firstAuthInsExists then
432: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.firstauthHandlerInsReason,null);
433: end if;
434: if coaInsAuthForward then
435: ame_engine.setDeviationReasonDate(ame_approver_deviation_pkg.forwarHandlerAuthInsReason,null);
436: end if;
437: end loop;
438: end loop;
439: exception

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

480: if l_error_code = -20213 then
481: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
482: messageNameIn => 'AME_400834_INV_HANDLR_APR',
483: tokenNameOneIn => 'ACTION_TYPE_NAME',
484: tokenValueOneIn => ame_engine.getActionTypeName(tempApprover.action_type_id),
485: tokenNameTwoIn => 'ORIG_SYSTEM',
486: tokenValueTwoIn => ame_util.perOrigSystem,
487: tokenNameThreeIn => 'ORIG_SYSEM_ID',
488: tokenValueThreeIn => tempApprover.orig_system_id);