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_ENGINE dependencies on AME_TRANS_APPROVAL_HISTORY

Line 478: (transactionIdIn ame_trans_approval_history.transaction_id%type

474: procedure getLMCondition(ruleIdIn in integer,
475: parameterOneOut out nocopy varchar2,
476: parameterTwoOut out nocopy varchar2);
477: procedure insertIntoTransApprovalHistory
478: (transactionIdIn ame_trans_approval_history.transaction_id%type
479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type

Line 479: ,applicationIdIn ame_trans_approval_history.application_id%type

475: parameterOneOut out nocopy varchar2,
476: parameterTwoOut out nocopy varchar2);
477: procedure insertIntoTransApprovalHistory
478: (transactionIdIn ame_trans_approval_history.transaction_id%type
479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type

Line 480: ,orderNumberIn ame_trans_approval_history.order_number%type

476: parameterTwoOut out nocopy varchar2);
477: procedure insertIntoTransApprovalHistory
478: (transactionIdIn ame_trans_approval_history.transaction_id%type
479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type

Line 481: ,nameIn ame_trans_approval_history.name%type

477: procedure insertIntoTransApprovalHistory
478: (transactionIdIn ame_trans_approval_history.transaction_id%type
479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

Line 482: ,appCategoryIn ame_trans_approval_history.approver_category%type

478: (transactionIdIn ame_trans_approval_history.transaction_id%type
479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type

Line 483: ,itemClassIn ame_trans_approval_history.item_class%type

479: ,applicationIdIn ame_trans_approval_history.application_id%type
480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type

Line 484: ,itemIdIn ame_trans_approval_history.item_id%type

480: ,orderNumberIn ame_trans_approval_history.order_number%type
481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

Line 485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

481: ,nameIn ame_trans_approval_history.name%type
482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type

Line 486: ,authorityIn ame_trans_approval_history.authority%type

482: ,appCategoryIn ame_trans_approval_history.approver_category%type
483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

Line 487: ,statusIn ame_trans_approval_history.status%type

483: ,itemClassIn ame_trans_approval_history.item_class%type
484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type

Line 488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

484: ,itemIdIn ame_trans_approval_history.item_id%type
485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type

Line 489: ,occurrenceIn ame_trans_approval_history.occurrence%type

485: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type

Line 490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

486: ,authorityIn ame_trans_approval_history.authority%type
487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type
494: ,dateClearedIn ame_trans_approval_history.date_cleared%type

Line 491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type

487: ,statusIn ame_trans_approval_history.status%type
488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type
494: ,dateClearedIn ame_trans_approval_history.date_cleared%type
495: ,historyTypeIn varchar2);

Line 492: ,notificationIdIn ame_trans_approval_history.notification_id%type

488: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type
494: ,dateClearedIn ame_trans_approval_history.date_cleared%type
495: ,historyTypeIn varchar2);
496: procedure parseForwardingBehaviors(forwardingBehaviorsIn in varchar2);

Line 493: ,userCommentsIn ame_trans_approval_history.user_comments%type

489: ,occurrenceIn ame_trans_approval_history.occurrence%type
490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type
494: ,dateClearedIn ame_trans_approval_history.date_cleared%type
495: ,historyTypeIn varchar2);
496: procedure parseForwardingBehaviors(forwardingBehaviorsIn in varchar2);
497: procedure parsePriorityModes(priorityModesIn in varchar2);

Line 494: ,dateClearedIn ame_trans_approval_history.date_cleared%type

490: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
491: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type
492: ,notificationIdIn ame_trans_approval_history.notification_id%type
493: ,userCommentsIn ame_trans_approval_history.user_comments%type
494: ,dateClearedIn ame_trans_approval_history.date_cleared%type
495: ,historyTypeIn varchar2);
496: procedure parseForwardingBehaviors(forwardingBehaviorsIn in varchar2);
497: procedure parsePriorityModes(priorityModesIn in varchar2);
498: procedure populateEngStVariables;

Line 5380: from ame_trans_approval_history a

5376: select 1
5377: from dual
5378: where exists
5379: (select null
5380: from ame_trans_approval_history a
5381: where application_id = engAmeApplicationId
5382: and transaction_id = engTransactionId
5383: and group_or_chain_id = groupIdIn
5384: and name = c_nameIn

Line 5399: from ame_trans_approval_history

5395: ,ame_util2.forwardByRepeatedStatus)
5396: and name = c_nameIn
5397: and row_timestamp in
5398: (select max(row_timestamp)
5399: from ame_trans_approval_history
5400: where application_id = engAmeApplicationId
5401: and transaction_id = engTransactionId
5402: and group_or_chain_id = groupIdIn
5403: and name = c_nameIn

Line 9308: (transactionIdIn ame_trans_approval_history.transaction_id%type

9304: exceptionStringIn => sqlerrm);
9305: raise;
9306: end insertApprovers;
9307: procedure insertIntoTransApprovalHistory
9308: (transactionIdIn ame_trans_approval_history.transaction_id%type
9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type

Line 9309: ,applicationIdIn ame_trans_approval_history.application_id%type

9305: raise;
9306: end insertApprovers;
9307: procedure insertIntoTransApprovalHistory
9308: (transactionIdIn ame_trans_approval_history.transaction_id%type
9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type

Line 9310: ,orderNumberIn ame_trans_approval_history.order_number%type

9306: end insertApprovers;
9307: procedure insertIntoTransApprovalHistory
9308: (transactionIdIn ame_trans_approval_history.transaction_id%type
9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type

Line 9311: ,nameIn ame_trans_approval_history.name%type

9307: procedure insertIntoTransApprovalHistory
9308: (transactionIdIn ame_trans_approval_history.transaction_id%type
9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

Line 9312: ,appCategoryIn ame_trans_approval_history.approver_category%type

9308: (transactionIdIn ame_trans_approval_history.transaction_id%type
9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type

Line 9313: ,itemClassIn ame_trans_approval_history.item_class%type

9309: ,applicationIdIn ame_trans_approval_history.application_id%type
9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type

Line 9314: ,itemIdIn ame_trans_approval_history.item_id%type

9310: ,orderNumberIn ame_trans_approval_history.order_number%type
9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

Line 9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

9311: ,nameIn ame_trans_approval_history.name%type
9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type

Line 9316: ,authorityIn ame_trans_approval_history.authority%type

9312: ,appCategoryIn ame_trans_approval_history.approver_category%type
9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

Line 9317: ,statusIn ame_trans_approval_history.status%type

9313: ,itemClassIn ame_trans_approval_history.item_class%type
9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

Line 9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

9314: ,itemIdIn ame_trans_approval_history.item_id%type
9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type

Line 9319: ,occurrenceIn ame_trans_approval_history.occurrence%type

9315: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type

Line 9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

9316: ,authorityIn ame_trans_approval_history.authority%type
9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type

Line 9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

9317: ,statusIn ame_trans_approval_history.status%type
9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as

Line 9322: ,notificationIdIn ame_trans_approval_history.notification_id%type

9318: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;

Line 9323: ,userCommentsIn ame_trans_approval_history.user_comments%type

9319: ,occurrenceIn ame_trans_approval_history.occurrence%type
9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;

Line 9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type

9320: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
9321: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;

Line 9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;

9322: ,notificationIdIn ame_trans_approval_history.notification_id%type
9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;

Line 9327: tempItemClass ame_trans_approval_history.item_class%type;

9323: ,userCommentsIn ame_trans_approval_history.user_comments%type
9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;

Line 9328: tempItemId ame_trans_approval_history.item_id%type;

9324: ,dateClearedIn ame_trans_approval_history.date_cleared%type
9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;

Line 9329: tempOrderNumber ame_trans_approval_history.order_number%type;

9325: ,historyTypeIn varchar2) as
9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;

Line 9330: tempAuthority ame_trans_approval_history.authority%type;

9326: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;

Line 9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;

9327: tempItemClass ame_trans_approval_history.item_class%type;
9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;

Line 9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;

9328: tempItemId ame_trans_approval_history.item_id%type;
9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
9336: tempName ame_trans_approval_history.name%type;

Line 9333: tempOccurrence ame_trans_approval_history.occurrence%type;

9329: tempOrderNumber ame_trans_approval_history.order_number%type;
9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
9336: tempName ame_trans_approval_history.name%type;
9337: approvers ame_util.approversTable2;

Line 9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;

9330: tempAuthority ame_trans_approval_history.authority%type;
9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
9336: tempName ame_trans_approval_history.name%type;
9337: approvers ame_util.approversTable2;
9338: begin

Line 9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;

9331: tempActionTypeId ame_trans_approval_history.action_type_id%type;
9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
9336: tempName ame_trans_approval_history.name%type;
9337: approvers ame_util.approversTable2;
9338: begin
9339: tempName := nameIn;

Line 9336: tempName ame_trans_approval_history.name%type;

9332: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
9333: tempOccurrence ame_trans_approval_history.occurrence%type;
9334: tempApiInsertion ame_trans_approval_history.api_insertion%type;
9335: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
9336: tempName ame_trans_approval_history.name%type;
9337: approvers ame_util.approversTable2;
9338: begin
9339: tempName := nameIn;
9340: if historyTypeIn = 'BEATBYFIRSTRESPONDER' then

Line 9351: select ame_trans_approval_history_s.nextval

9347: and approvers(i).group_or_chain_id = grpOrChainIdIn
9348: and approvers(i).approver_category = ame_util.approvalApproverCategory
9349: and approvers(i).approval_status = ame_util.notifiedStatus
9350: then
9351: select ame_trans_approval_history_s.nextval
9352: into tempTransHistoryId
9353: from dual;
9354: insert into AME_TRANS_APPROVAL_HISTORY
9355: (TRANS_HISTORY_ID

Line 9354: insert into AME_TRANS_APPROVAL_HISTORY

9350: then
9351: select ame_trans_approval_history_s.nextval
9352: into tempTransHistoryId
9353: from dual;
9354: insert into AME_TRANS_APPROVAL_HISTORY
9355: (TRANS_HISTORY_ID
9356: ,TRANSACTION_ID
9357: ,APPLICATION_ID
9358: ,ROW_TIMESTAMP

Line 9409: select ame_trans_approval_history_s.nextval

9405: and approvers(i).group_or_chain_id = grpOrChainIdIn
9406: and approvers(i).approver_category = ame_util.approvalApproverCategory
9407: -- and approvers(i).approval_status = ame_util.notifiedStatus
9408: then
9409: select ame_trans_approval_history_s.nextval
9410: into tempTransHistoryId
9411: from dual;
9412: insert into AME_TRANS_APPROVAL_HISTORY
9413: (TRANS_HISTORY_ID

Line 9412: insert into AME_TRANS_APPROVAL_HISTORY

9408: then
9409: select ame_trans_approval_history_s.nextval
9410: into tempTransHistoryId
9411: from dual;
9412: insert into AME_TRANS_APPROVAL_HISTORY
9413: (TRANS_HISTORY_ID
9414: ,TRANSACTION_ID
9415: ,APPLICATION_ID
9416: ,ROW_TIMESTAMP

Line 9456: select ame_trans_approval_history_s.nextval

9452: end if;
9453: end loop;
9454: return;
9455: end if;
9456: select ame_trans_approval_history_s.nextval
9457: into tempTransHistoryId
9458: from dual;
9459: if historyTypeIn = 'APPROVERPRESENT' then
9460: insert into AME_TRANS_APPROVAL_HISTORY

Line 9460: insert into AME_TRANS_APPROVAL_HISTORY

9456: select ame_trans_approval_history_s.nextval
9457: into tempTransHistoryId
9458: from dual;
9459: if historyTypeIn = 'APPROVERPRESENT' then
9460: insert into AME_TRANS_APPROVAL_HISTORY
9461: (TRANS_HISTORY_ID
9462: ,TRANSACTION_ID
9463: ,APPLICATION_ID
9464: ,ROW_TIMESTAMP

Line 9520: from ame_trans_approval_history atah

9516: ,tempGroupOrChainId
9517: ,tempOccurrence
9518: ,tempApiInsertion
9519: ,tempMemberOrderNumber
9520: from ame_trans_approval_history atah
9521: ,fnd_lookups lookup
9522: ,fnd_lookups lookup2
9523: ,ame_approval_groups apg
9524: where atah.date_cleared is null

Line 9530: from ame_trans_approval_history b

9526: and atah.application_id = applicationIdIn
9527: and atah.name = tempName
9528: and atah.trans_history_id =
9529: (select max(b.trans_history_id)
9530: from ame_trans_approval_history b
9531: where atah.transaction_id = b.transaction_id
9532: and atah.application_id = b.application_id
9533: and atah.name = b.name
9534: and atah.approver_category = b.approver_category

Line 9587: insert into AME_TRANS_APPROVAL_HISTORY

9583: end if;
9584: if memberorderNumberIn is not null then
9585: tempMemberOrderNumber := memberorderNumberIn;
9586: end if;
9587: insert into AME_TRANS_APPROVAL_HISTORY
9588: (TRANS_HISTORY_ID
9589: ,TRANSACTION_ID
9590: ,APPLICATION_ID
9591: ,ROW_TIMESTAMP

Line 12818: update AME_TRANS_APPROVAL_HISTORY

12814: /* As approver is no longer in the approval list, log the message in the
12815: history table with a cleared date equal to sysdate. Also, first set
12816: date_cleared for other possible rows for this approver in the history
12817: table so that rows do not appear in the history table. */
12818: update AME_TRANS_APPROVAL_HISTORY
12819: set date_cleared = sysdate
12820: where transaction_id = transactionIdIn
12821: and application_id = ameApplicationId
12822: and name = approver.name