DBA Data[Home] [Help]

APPS.AME_API5 dependencies on AME_TRANS_APPROVAL_HISTORY

Line 47: update AME_TRANS_APPROVAL_HISTORY set

43: ,transactionIdIn => transactionIdIn );
44: end if;
45: /* update all existing history rows from the Approval Notification History table
46: to indicate the rows were cleared */
47: update AME_TRANS_APPROVAL_HISTORY set
48: date_cleared = sysdate
49: where
50: application_id = ameAppId and
51: transaction_id = transactionIdIn and

Line 123: update AME_TRANS_APPROVAL_HISTORY set

119: ,transactionIdIn => transactionIdIn );
120: end if;
121: /* update all existing history rows from the Approval Notification History table
122: to indicate the rows were cleared */
123: update AME_TRANS_APPROVAL_HISTORY set
124: date_cleared = sysdate
125: where
126: application_id = ameAppId and
127: transaction_id = transactionIdIn and