APPS.AME_APPROVER_DEVIATION_PKG dependencies on AME_TEMP_TRANSACTIONS

Line 36: from ame_temp_transactions

32: ,transactionDescriptionIn in varchar2) as
33: deviationflag varchar2(1);
34: cursor chkTransDeviation(applId in number,transIdIn in varchar2) is
35: select trans_deviation_flag /*allowed values are Y and N*/
36: from ame_temp_transactions
37: where application_id = applId
38: and transaction_id = transIdIn;
39: begin
40: open chkTransDeviation(applicationIdIn,tranasactionId);

Line 45: update ame_temp_transactions

41: fetch chkTransDeviation into deviationflag;
42: close chkTransDeviation;
43: if deviationflag is null then
44: begin
45: update ame_temp_transactions
46: set trans_deviation_flag = 'Y'
47: ,end_date = sysdate
48: ,transaction_requestor = transactionRequesterIn
49: ,transaction_description = transactionDescriptionIn

Line 65: update ame_temp_transactions

61: if deviationflag = 'Y' then
62: return;
63: elsif deviationflag = 'N' then
64: begin
65: update ame_temp_transactions
66: set trans_deviation_flag = 'Y'
67: ,end_date = sysdate
68: ,transaction_requestor = transactionRequesterIn
69: ,transaction_description = transactionDescriptionIn

Line 184: from ame_temp_transactions

180: tempReason varchar2(100);
181: tempDate date;
182: cursor isTxnComplete(applnIdIn in number, txnIdIn in varchar2) is
183: select temp_transactions_id
184: from ame_temp_transactions
185: where application_id = applnIdIn
186: and transaction_id = txnIdIn
187: and end_date is not null;
188: cursor gettempTranskey(applnIdIn in number, txnIdIn in varchar2) is

Line 190: from ame_temp_transactions

186: and transaction_id = txnIdIn
187: and end_date is not null;
188: cursor gettempTranskey(applnIdIn in number, txnIdIn in varchar2) is
189: select temp_transactions_id
190: from ame_temp_transactions
191: where application_id = applnIdIn
192: and transaction_id = txnIdIn;
193: begin
194: open isTxnComplete(applicationIdIn,tranasactionIdIn);

Line 227: update ame_temp_transactions

223: end;
224: if IsTransactionDeviated(deviationListIn) then
225: markTransactionDeviation(applicationIdIn,tranasactionIdIn,tempDisplayName,tempTransDescr);
226: else
227: update ame_temp_transactions
228: set end_date = sysdate
229: ,trans_deviation_flag = 'N'
230: ,transaction_requestor = tempDisplayName
231: ,transaction_description = tempTransDescr

Line 389: from ame_temp_transactions

385: tempTransactionKey integer;
386: recordConfig varchar2(100) := 'recordDeviations';
387: cursor getTxnKey(applnId in number, transIdIn in varchar2) is
388: select temp_transactions_id
389: from ame_temp_transactions
390: where application_id = applnId
391: and transaction_id = transIdIn
392: and end_date is not null;
393: begin

Line 418: update ame_temp_transactions

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
421: ,transaction_requestor = null
422: ,transaction_description = null

Line 447: from ame_temp_transactions

443: ,transactionIdIn in varchar2 ) as
444: tempTransSeq number;
445: cursor getTransKey(applnId in number, transIdIn in varchar2) is
446: select temp_transactions_id
447: from ame_temp_transactions
448: where application_id = applnId
449: and transaction_id = transIdIn
450: and end_date is not null;
451: begin

Line 459: update ame_temp_transactions

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
462: ,transaction_description = null
463: ,trans_deviation_flag = null