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 1554: tempParameter ame_temp_insertions.parameter%type;

1550: errorMessage ame_util.longStringType;
1551: invalidApproverException exception;
1552: tempCount integer;
1553: tempOrderNumber integer;
1554: tempParameter ame_temp_insertions.parameter%type;
1555: tooLateException exception;
1556: origSystemList ame_util.stringList;
1557: actionTypeCount number;
1558: invalidActionTypeException exception;

Line 1704: delete from ame_temp_insertions

1700: /* If there is already a firstAuthority in the insertions table for the transaction, item class, item_id ,
1701: delete it. */
1702: if(ame_engine.insertionExists(orderTypeIn => ame_util.firstAuthority,
1703: parameterIn => tempParameter)) then
1704: delete from ame_temp_insertions
1705: where
1706: application_id = ameApplicationId and
1707: transaction_id = transactionIdIn and
1708: item_class = approverIn.item_class and

Line 1714: insert into ame_temp_insertions(

1710: order_type = ame_util.firstAuthority;
1711: end if;
1712: -- Perform the insertion.
1713: tempCount := ame_engine.getNextInsertionOrder;
1714: insert into ame_temp_insertions(
1715: transaction_id,
1716: application_id,
1717: insertion_order,
1718: order_type,