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 476: (transactionIdIn ame_trans_approval_history.transaction_id%type

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

Line 477: ,applicationIdIn ame_trans_approval_history.application_id%type

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

Line 478: ,orderNumberIn ame_trans_approval_history.order_number%type

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

Line 479: ,nameIn ame_trans_approval_history.name%type

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

Line 480: ,appCategoryIn ame_trans_approval_history.approver_category%type

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

Line 481: ,itemClassIn ame_trans_approval_history.item_class%type

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

Line 482: ,itemIdIn ame_trans_approval_history.item_id%type

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

Line 483: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

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

Line 484: ,authorityIn ame_trans_approval_history.authority%type

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

Line 485: ,statusIn ame_trans_approval_history.status%type

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

Line 486: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

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

Line 487: ,occurrenceIn ame_trans_approval_history.occurrence%type

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

Line 488: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

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

Line 489: ,memberOrderNumberIn ame_trans_approval_history.member_order_number%type

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

Line 490: ,notificationIdIn ame_trans_approval_history.notification_id%type

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

Line 491: ,userCommentsIn ame_trans_approval_history.user_comments%type

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

Line 492: ,dateClearedIn ame_trans_approval_history.date_cleared%type

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

Line 8962: (transactionIdIn ame_trans_approval_history.transaction_id%type

8958: exceptionStringIn => sqlerrm);
8959: raise;
8960: end insertApprovers;
8961: procedure insertIntoTransApprovalHistory
8962: (transactionIdIn ame_trans_approval_history.transaction_id%type
8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type

Line 8963: ,applicationIdIn ame_trans_approval_history.application_id%type

8959: raise;
8960: end insertApprovers;
8961: procedure insertIntoTransApprovalHistory
8962: (transactionIdIn ame_trans_approval_history.transaction_id%type
8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type

Line 8964: ,orderNumberIn ame_trans_approval_history.order_number%type

8960: end insertApprovers;
8961: procedure insertIntoTransApprovalHistory
8962: (transactionIdIn ame_trans_approval_history.transaction_id%type
8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type

Line 8965: ,nameIn ame_trans_approval_history.name%type

8961: procedure insertIntoTransApprovalHistory
8962: (transactionIdIn ame_trans_approval_history.transaction_id%type
8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

Line 8966: ,appCategoryIn ame_trans_approval_history.approver_category%type

8962: (transactionIdIn ame_trans_approval_history.transaction_id%type
8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type

Line 8967: ,itemClassIn ame_trans_approval_history.item_class%type

8963: ,applicationIdIn ame_trans_approval_history.application_id%type
8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type

Line 8968: ,itemIdIn ame_trans_approval_history.item_id%type

8964: ,orderNumberIn ame_trans_approval_history.order_number%type
8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

Line 8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type

8965: ,nameIn ame_trans_approval_history.name%type
8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type

Line 8970: ,authorityIn ame_trans_approval_history.authority%type

8966: ,appCategoryIn ame_trans_approval_history.approver_category%type
8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

Line 8971: ,statusIn ame_trans_approval_history.status%type

8967: ,itemClassIn ame_trans_approval_history.item_class%type
8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

Line 8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type

8968: ,itemIdIn ame_trans_approval_history.item_id%type
8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type

Line 8973: ,occurrenceIn ame_trans_approval_history.occurrence%type

8969: ,actionTypeIdIn ame_trans_approval_history.action_type_id%type
8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type

Line 8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type

8970: ,authorityIn ame_trans_approval_history.authority%type
8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type

Line 8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type

8971: ,statusIn ame_trans_approval_history.status%type
8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as

Line 8976: ,notificationIdIn ame_trans_approval_history.notification_id%type

8972: ,grpOrChainIdIn ame_trans_approval_history.group_or_chain_id%type
8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;

Line 8977: ,userCommentsIn ame_trans_approval_history.user_comments%type

8973: ,occurrenceIn ame_trans_approval_history.occurrence%type
8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;

Line 8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type

8974: ,apiInsertionIn ame_trans_approval_history.api_insertion%type
8975: ,memberorderNumberIn ame_trans_approval_history.member_order_number%type
8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;

Line 8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;

8976: ,notificationIdIn ame_trans_approval_history.notification_id%type
8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;

Line 8981: tempItemClass ame_trans_approval_history.item_class%type;

8977: ,userCommentsIn ame_trans_approval_history.user_comments%type
8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;

Line 8982: tempItemId ame_trans_approval_history.item_id%type;

8978: ,dateClearedIn ame_trans_approval_history.date_cleared%type
8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;

Line 8983: tempOrderNumber ame_trans_approval_history.order_number%type;

8979: ,historyTypeIn varchar2) as
8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;

Line 8984: tempAuthority ame_trans_approval_history.authority%type;

8980: tempTransHistoryId ame_trans_approval_history.trans_history_id%type;
8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;

Line 8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;

8981: tempItemClass ame_trans_approval_history.item_class%type;
8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;

Line 8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;

8982: tempItemId ame_trans_approval_history.item_id%type;
8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
8990: tempName ame_trans_approval_history.name%type;

Line 8987: tempOccurrence ame_trans_approval_history.occurrence%type;

8983: tempOrderNumber ame_trans_approval_history.order_number%type;
8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
8990: tempName ame_trans_approval_history.name%type;
8991: approvers ame_util.approversTable2;

Line 8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;

8984: tempAuthority ame_trans_approval_history.authority%type;
8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
8990: tempName ame_trans_approval_history.name%type;
8991: approvers ame_util.approversTable2;
8992: begin

Line 8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;

8985: tempActionTypeId ame_trans_approval_history.action_type_id%type;
8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
8990: tempName ame_trans_approval_history.name%type;
8991: approvers ame_util.approversTable2;
8992: begin
8993: tempName := nameIn;

Line 8990: tempName ame_trans_approval_history.name%type;

8986: tempGroupOrChainId ame_trans_approval_history.group_or_chain_id%type;
8987: tempOccurrence ame_trans_approval_history.occurrence%type;
8988: tempApiInsertion ame_trans_approval_history.api_insertion%type;
8989: tempMemberOrderNumber ame_trans_approval_history.member_order_number%type;
8990: tempName ame_trans_approval_history.name%type;
8991: approvers ame_util.approversTable2;
8992: begin
8993: tempName := nameIn;
8994: if historyTypeIn = 'BEATBYFIRSTRESPONDER' then

Line 9005: select ame_trans_approval_history_s.nextval

9001: and approvers(i).group_or_chain_id = grpOrChainIdIn
9002: and approvers(i).approver_category = ame_util.approvalApproverCategory
9003: and approvers(i).approval_status = ame_util.notifiedStatus
9004: then
9005: select ame_trans_approval_history_s.nextval
9006: into tempTransHistoryId
9007: from dual;
9008: insert into AME_TRANS_APPROVAL_HISTORY
9009: (TRANS_HISTORY_ID

Line 9008: insert into AME_TRANS_APPROVAL_HISTORY

9004: then
9005: select ame_trans_approval_history_s.nextval
9006: into tempTransHistoryId
9007: from dual;
9008: insert into AME_TRANS_APPROVAL_HISTORY
9009: (TRANS_HISTORY_ID
9010: ,TRANSACTION_ID
9011: ,APPLICATION_ID
9012: ,ROW_TIMESTAMP

Line 9052: select ame_trans_approval_history_s.nextval

9048: end if;
9049: end loop;
9050: return;
9051: end if;
9052: select ame_trans_approval_history_s.nextval
9053: into tempTransHistoryId
9054: from dual;
9055: if historyTypeIn = 'APPROVERPRESENT' then
9056: insert into AME_TRANS_APPROVAL_HISTORY

Line 9056: insert into AME_TRANS_APPROVAL_HISTORY

9052: select ame_trans_approval_history_s.nextval
9053: into tempTransHistoryId
9054: from dual;
9055: if historyTypeIn = 'APPROVERPRESENT' then
9056: insert into AME_TRANS_APPROVAL_HISTORY
9057: (TRANS_HISTORY_ID
9058: ,TRANSACTION_ID
9059: ,APPLICATION_ID
9060: ,ROW_TIMESTAMP

Line 9116: from ame_trans_approval_history atah

9112: ,tempGroupOrChainId
9113: ,tempOccurrence
9114: ,tempApiInsertion
9115: ,tempMemberOrderNumber
9116: from ame_trans_approval_history atah
9117: ,fnd_lookups lookup
9118: ,fnd_lookups lookup2
9119: ,ame_approval_groups apg
9120: where atah.date_cleared is null

Line 9126: from ame_trans_approval_history b

9122: and atah.application_id = applicationIdIn
9123: and atah.name = tempName
9124: and atah.trans_history_id =
9125: (select max(b.trans_history_id)
9126: from ame_trans_approval_history b
9127: where atah.transaction_id = b.transaction_id
9128: and atah.application_id = b.application_id
9129: and atah.name = b.name
9130: and atah.approver_category = b.approver_category

Line 9183: insert into AME_TRANS_APPROVAL_HISTORY

9179: end if;
9180: if memberorderNumberIn is not null then
9181: tempMemberOrderNumber := memberorderNumberIn;
9182: end if;
9183: insert into AME_TRANS_APPROVAL_HISTORY
9184: (TRANS_HISTORY_ID
9185: ,TRANSACTION_ID
9186: ,APPLICATION_ID
9187: ,ROW_TIMESTAMP

Line 12324: update AME_TRANS_APPROVAL_HISTORY

12320: /* As approver is no longer in the approval list, log the message in the
12321: history table with a cleared date equal to sysdate. Also, first set
12322: date_cleared for other possible rows for this approver in the history
12323: table so that rows do not appear in the history table. */
12324: update AME_TRANS_APPROVAL_HISTORY
12325: set date_cleared = sysdate
12326: where transaction_id = transactionIdIn
12327: and application_id = ameApplicationId
12328: and name = approver.name