APPS.EDR_TRANS_ACKN_PUB dependencies on EDR_TRANS_ACKN

Line 1: package body EDR_TRANS_ACKN_PUB as

1: package body EDR_TRANS_ACKN_PUB as
2: /* $Header: EDRPACKB.pls 120.0.12000000.1 2007/01/18 05:54:16 appldev ship $ */
3:
4: procedure SEND_ACKN
5: ( p_api_version IN NUMBER ,

Line 43: from edr_trans_ackn

39: l_existing_ack_count PLS_INTEGER := 0;
40:
41: cursor l_ack_csr is
42: select transaction_status
43: from edr_trans_ackn
44: where erecord_id = p_erecord_id;
45:
46: INVALID_ERECORD_ERROR EXCEPTION;
47: INVALID_ACK_STATUS_ERROR EXCEPTION;

Line 106: l_valid_status := EDR_TRANS_ACKN_PVT.IS_STATUS_VALID

102:
103: -- now validate that the value of the trans ackn status is
104: -- valid
105:
106: l_valid_status := EDR_TRANS_ACKN_PVT.IS_STATUS_VALID
107: ( p_status => p_trans_status ,
108: p_mode => EDR_TRANS_ACKN_PVT.G_UPDATE_MODE
109: );
110:

Line 108: p_mode => EDR_TRANS_ACKN_PVT.G_UPDATE_MODE

104: -- valid
105:
106: l_valid_status := EDR_TRANS_ACKN_PVT.IS_STATUS_VALID
107: ( p_status => p_trans_status ,
108: p_mode => EDR_TRANS_ACKN_PVT.G_UPDATE_MODE
109: );
110:
111: if not l_valid_status then
112: RAISE INVALID_ACK_STATUS_ERROR;

Line 152: EDR_TRANS_ACKN_PVT.SEND_ACKN_AUTO

148: -- if an auto commit is required call the corresponding
149: -- auto txn
150:
151: IF FND_API.To_Boolean(p_autonomous_commit) THEN
152: EDR_TRANS_ACKN_PVT.SEND_ACKN_AUTO
153: ( p_api_version => 1.0 ,
154: p_init_msg_list => FND_API.G_FALSE ,
155: x_return_status => l_return_status ,
156: x_msg_count => l_msg_count ,

Line 180: update EDR_TRANS_ACKN SET

176: last_updated_by => l_last_updated_by ,
177: last_update_login => l_last_update_login
178: );
179:
180: update EDR_TRANS_ACKN SET
181: ACKN_DATE = SYSDATE ,
182: TRANSACTION_STATUS = p_trans_status ,
183: ACKN_BY = p_ackn_by ,
184: ACKN_NOTE = p_ackn_note ,

Line 357: end EDR_TRANS_ACKN_PUB;

353: edr_ctx_pkg.unset_secure_attr;
354: -- END Bug : 3834375
355: end SEND_ACKN;
356:
357: end EDR_TRANS_ACKN_PUB;