APPS.AME_API2 dependencies on AME_TEMP_INSERTIONS

Line 51: delete from ame_temp_insertions

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
52: where
53: application_id = ameAppId and
54: transaction_id = transactionIdIn;
55: delete from ame_temp_deletions

Line 1511: tempParameter ame_temp_insertions.parameter%type;

1507: errorMessage ame_util.longStringType;
1508: invalidApproverException exception;
1509: tempCount integer;
1510: tempOrderNumber integer;
1511: tempParameter ame_temp_insertions.parameter%type;
1512: tooLateException exception;
1513: origSystemList ame_util.stringList;
1514: actionTypeCount number;
1515: invalidActionTypeException exception;

Line 1660: delete from ame_temp_insertions

1656: /* If there is already a firstAuthority in the insertions table for the transaction, item class, item_id ,
1657: delete it. */
1658: if(ame_engine.insertionExists(orderTypeIn => ame_util.firstAuthority,
1659: parameterIn => tempParameter)) then
1660: delete from ame_temp_insertions
1661: where
1662: application_id = ameApplicationId and
1663: transaction_id = transactionIdIn and
1664: item_class = approverIn.item_class and

Line 1670: insert into ame_temp_insertions(

1666: order_type = ame_util.firstAuthority;
1667: end if;
1668: -- Perform the insertion.
1669: tempCount := ame_engine.getNextInsertionOrder;
1670: insert into ame_temp_insertions(
1671: transaction_id,
1672: application_id,
1673: insertion_order,
1674: order_type,