APPS.CN_REASONS_PKG dependencies on CN_REASONS

Line 1: PACKAGE BODY CN_REASONS_PKG AS

1: PACKAGE BODY CN_REASONS_PKG AS
2: /* $Header: cntresnb.pls 115.1 2002/04/24 12:04:58 pkm ship $*/
3:
4:
5: -- * -------------------------------------------------------------------------*

Line 22: INSERT into CN_REASONS

18: l_reason VARCHAR2(8000);
19: --
20: BEGIN
21: l_reason := p_reasons_all_rec.reason;
22: INSERT into CN_REASONS
23: ( REASON_ID,
24: UPDATED_TABLE,
25: UPD_TABLE_ID,
26: REASON,

Line 128: UPDATE CN_REASONS_ALL oldrec

124: l_reason VARCHAR2(8000);
125: --
126: BEGIN
127: l_reason := p_reasons_all_rec.REASON;
128: UPDATE CN_REASONS_ALL oldrec
129: SET
130: UPDATED_TABLE = DECODE(p_reasons_all_rec.UPDATED_TABLE,
131: FND_API.G_MISS_CHAR,
132: oldrec.UPDATED_TABLE,

Line 240: FROM CN_REASONS_ALL

236: ( p_reasons_all_rec IN REASONS_ALL_REC_TYPE) IS
237:
238: CURSOR c IS
239: SELECT object_version_number
240: FROM CN_REASONS_ALL
241: WHERE reason_id = p_reasons_all_rec.reason_id;
242:
243: tlinfo c%ROWTYPE ;
244: --

Line 263: UPDATE CN_REASONS_ALL oldrec

259: fnd_msg_pub.add;
260: raise fnd_api.g_exc_unexpected_error;
261: end if;
262: l_reason := p_reasons_all_rec.REASON;
263: UPDATE CN_REASONS_ALL oldrec
264: SET
265: UPDATED_TABLE = DECODE(p_reasons_all_rec.UPDATED_TABLE,
266: FND_API.G_MISS_CHAR,
267: oldrec.UPDATED_TABLE,

Line 366: DELETE FROM CN_REASONS_ALL

362: -- * -------------------------------------------------------------------------*
363: PROCEDURE delete_row(
364: p_reason_id NUMBER) IS
365: BEGIN
366: DELETE FROM CN_REASONS_ALL
367: WHERE reason_id = p_reason_id;
368: END Delete_row;
369: --
370: END CN_REASONS_PKG;

Line 370: END CN_REASONS_PKG;

366: DELETE FROM CN_REASONS_ALL
367: WHERE reason_id = p_reason_id;
368: END Delete_row;
369: --
370: END CN_REASONS_PKG;