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 1687: update AME_TRANS_APPROVAL_HISTORY set

1683: api_insertion in (ame_util.oamGenerated, ame_util.apiAuthorityInsertion) and
1684: approval_status not in (ame_util.nullStatus,ame_util.notifiedStatus);
1685: /* update all existing history rows from the Approval Notification History table
1686: to indicate the rows were cleared */
1687: update AME_TRANS_APPROVAL_HISTORY set
1688: date_cleared = sysdate
1689: where
1690: application_id = ameApplicationId and
1691: transaction_id = transactionIdIn and