APPS.CN_REASONS_PVT dependencies on CN_REASON_HISTORY_PKG

Line 148: l_history_rec cn_reason_history_pkg.reason_history_all_rec_type;

144: --
145: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
146: l_api_version CONSTANT NUMBER := 1.0;
147: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;
148: l_history_rec cn_reason_history_pkg.reason_history_all_rec_type;
149: l_reason VARCHAR2(4000);
150: l_clob_loc CLOB;
151: l_clob_length NUMBER;
152: --

Line 221: cn_reason_history_pkg.insert_row(l_history_rec);

217: SELECT cn_reason_history_s.NEXTVAL
218: INTO l_history_rec.reason_history_id
219: FROM dual;
220: --
221: cn_reason_history_pkg.insert_row(l_history_rec);
222: --
223: cn_reasons_pkg.lock_update_row(l_reasons_all_rec);
224: --
225: END LOOP;

Line 275: l_history_rec cn_reason_history_pkg.reason_history_all_rec_type;

271: WHERE r.reason_id = l_reason_id;
272: --
273: l_api_name CONSTANT VARCHAR2(30) := 'delete_notes';
274: l_api_version CONSTANT NUMBER := 1.0;
275: l_history_rec cn_reason_history_pkg.reason_history_all_rec_type;
276: l_reason VARCHAR2(4000);
277: l_clob_loc CLOB;
278: l_clob_length NUMBER;
279: --

Line 342: cn_reason_history_pkg.insert_row(l_history_rec);

338: SELECT cn_reason_history_s.NEXTVAL
339: INTO l_history_rec.reason_history_id
340: FROM dual;
341: --
342: cn_reason_history_pkg.insert_row(l_history_rec);
343: --
344: cn_reasons_pkg.delete_row(p_reason_id);
345: --
346: END LOOP;

Line 429: cn_reason_history_pkg.delete_row(history_rec.reason_history_id);

425: RAISE FND_API.G_EXC_ERROR ;
426: END IF;
427: FOR history_rec IN history_cur
428: LOOP
429: cn_reason_history_pkg.delete_row(history_rec.reason_history_id);
430: END LOOP;
431: --
432: FOR reason_rec IN reason_cur
433: LOOP