DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_TEMP_OLD_APPROVER_LISTS

Line 47: delete from ame_temp_old_approver_lists

43: transactionIdIn => transactionIdIn,
44: transactionTypeIdIn => transactionTypeIn);
45: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
46: transactionTypeIdIn => transactionTypeIn);
47: delete from ame_temp_old_approver_lists
48: where
49: application_id = ameAppId and
50: transaction_id = transactionIdIn;
51: delete from ame_temp_insertions

Line 1612: from ame_temp_old_approver_lists

1608: if clearChainStatusYNIn = ame_util.booleanFalse then
1609: /* Check whether any chain-of-authority approvers have acted on the transaction's chain */
1610: select count(*)
1611: into tempCount
1612: from ame_temp_old_approver_lists
1613: where
1614: application_id = ameApplicationId and
1615: transaction_id = transactionIdIn and
1616: item_class = approverIn.item_class and

Line 1629: update ame_temp_old_approver_lists set

1625: end if;
1626: else /* clearChainStatusYNIn = 'Y' */
1627: /* Clear the status of the relevant chain for all approvers who have responded and have an approval
1628: approver category. Approvers with a status of 'NOTIFIED' will not be cleared */
1629: update ame_temp_old_approver_lists set
1630: approval_status = ame_util.nullStatus
1631: where
1632: application_id = ameApplicationId and
1633: transaction_id = transactionIdIn and