APPS.CN_REASONS_PVT dependencies on CN_REASONS_PKG

Line 47: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,

43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
45: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
46: p_commit IN VARCHAR2 := CN_API.G_FALSE,
47: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 55: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;

51: x_loading_status OUT NOCOPY VARCHAR2) IS
52: --
53: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;
56: --
57: BEGIN
58: -- Standard Start of API savepoint
59: SAVEPOINT insert_row;

Line 97: cn_reasons_pkg.insert_row(l_reasons_all_rec);

93: END IF;
94: x_loading_status := 'CN_REQUIRED_FIELDS';
95: RAISE FND_API.G_EXC_ERROR;
96: ELSE
97: cn_reasons_pkg.insert_row(l_reasons_all_rec);
98: END IF;
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO insert_row;

Line 134: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,

130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
132: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
133: p_commit IN VARCHAR2 := CN_API.G_FALSE,
134: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 147: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;

143: WHERE r.reason_id = l_reason_id;
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;

Line 223: cn_reasons_pkg.lock_update_row(l_reasons_all_rec);

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;
226: END IF;
227: EXCEPTION

Line 344: cn_reasons_pkg.delete_row(p_reason_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;
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN

Line 434: cn_reasons_pkg.delete_row(reason_rec.reason_id);

430: END LOOP;
431: --
432: FOR reason_rec IN reason_cur
433: LOOP
434: cn_reasons_pkg.delete_row(reason_rec.reason_id);
435: END LOOP;
436: --
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN