DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_TRANS_APPROVAL_HISTORY

Line 61: update AME_TRANS_APPROVAL_HISTORY set

57: application_id = ameAppId and
58: transaction_id = transactionIdIn;
59: /* update all existing history rows from the Approval Notification History table
60: to indicate the rows were cleared */
61: update AME_TRANS_APPROVAL_HISTORY set
62: date_cleared = sysdate
63: where
64: application_id = ameAppId and
65: transaction_id = transactionIdIn

Line 1643: update AME_TRANS_APPROVAL_HISTORY set

1639: api_insertion in (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) and
1640: approval_status not in (ame_util.nullStatus,ame_util.notifiedStatus);
1641: /* update all existing history rows from the Approval Notification History table
1642: to indicate the rows were cleared */
1643: update AME_TRANS_APPROVAL_HISTORY set
1644: date_cleared = sysdate
1645: where
1646: application_id = ameApplicationId and
1647: transaction_id = transactionIdIn and