DBA Data[Home] [Help]

APPS.AME_APPROVER_DEVIATION_PKG dependencies on AME_TXN_APPROVERS

Line 244: select ame_txn_approvers_s.nextval

240: tempDate := deviationListIn(approverIndex).effectiveDate;
241: end if;
242: begin
243: approverDeviationId := null;
244: select ame_txn_approvers_s.nextval
245: into approverDeviationId from dual;
246: insert into ame_txn_approvers
247: (
248: txn_approvers_id

Line 246: insert into ame_txn_approvers

242: begin
243: approverDeviationId := null;
244: select ame_txn_approvers_s.nextval
245: into approverDeviationId from dual;
246: insert into ame_txn_approvers
247: (
248: txn_approvers_id
249: ,temp_transactions_id
250: ,name

Line 416: delete from ame_txn_approvers

412: if tempTransactionKey is null then
413: return;
414: end if;
415: begin
416: delete from ame_txn_approvers
417: where temp_transactions_id = tempTransactionKey;
418: update ame_temp_transactions
419: set end_Date = null
420: ,trans_deviation_flag = null

Line 457: delete from ame_txn_approvers

453: fetch getTransKey into tempTransSeq;
454: close getTransKey;
455: if tempTransSeq is not null then
456: begin
457: delete from ame_txn_approvers
458: where temp_transactions_id = tempTransSeq;
459: update ame_temp_transactions
460: set end_date = null
461: ,transaction_requestor = null