APPS.EDR_TRANS_ACKN_PVT dependencies on EDR_TRANS_ACKN

Line 1: package body EDR_TRANS_ACKN_PVT as

1: package body EDR_TRANS_ACKN_PVT as
2: /* $Header: EDRVACKB.pls 120.0.12000000.1 2007/01/18 05:55:58 appldev ship $ */
3:
4: -- Private Utility Functions --
5:

Line 80: from edr_trans_ackn

76: DUPLICATE_ACK_ERROR EXCEPTION;
77:
78: cursor l_ack_csr is
79: select count(ackn_id)
80: from edr_trans_ackn
81: where erecord_id = p_erecord_id;
82:
83: begin
84: -- Standard call to check for call compatibility.

Line 153: select edr_trans_ackn_s.nextval

149:
150: -- after all the validations are done, insert the row in the
151: -- database
152:
153: select edr_trans_ackn_s.nextval
154: into l_ackn_id
155: from dual;
156:
157: EDR_UTILITIES.getWhoColumns

Line 165: insert into EDR_TRANS_ACKN(

161: last_updated_by => l_last_updated_by ,
162: last_update_login => l_last_update_login
163: );
164:
165: insert into EDR_TRANS_ACKN(
166: ACKN_ID
167: ,ERECORD_ID
168: ,ACKN_DATE
169: ,TRANSACTION_STATUS

Line 339: update EDR_TRANS_ACKN SET

335: last_updated_by => l_last_updated_by ,
336: last_update_login => l_last_update_login
337: );
338:
339: update EDR_TRANS_ACKN SET
340: ACKN_DATE = SYSDATE ,
341: TRANSACTION_STATUS = p_trans_status ,
342: ACKN_BY = p_ackn_by ,
343: ACKN_NOTE = p_ackn_note ,

Line 382: end EDR_TRANS_ACKN_PVT;

378: );
379:
380: end SEND_ACKN_AUTO;
381:
382: end EDR_TRANS_ACKN_PVT;