APPS.CN_REASONS_PKG dependencies on CN_REASONS_ALL

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;