eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_REASONS_PVT dependencies on CN_REASONS

Line 1: PACKAGE BODY cn_reasons_pvt AS

1: PACKAGE BODY cn_reasons_pvt AS
2: -- $Header: cnvresnb.pls 115.2 2002/11/21 21:16:49 hlchen ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1994 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 10: -- cn_reasons_pvt

6: -- | All rights reserved. |
7: -- +======================================================================+
8: --
9: -- Package Name
10: -- cn_reasons_pvt
11: -- Purpose
12: -- Package Body to display the analyst comments for a payment worksheet.
13: -- History
14: -- 04/02/02 Rao.Chenna Created

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_REASONS_PVT';

11: -- Purpose
12: -- Package Body to display the analyst comments for a payment worksheet.
13: -- History
14: -- 04/02/02 Rao.Chenna Created
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_REASONS_PVT';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpresnb.pls';
17: --
18: /*
19: PROCEDURE my_debug(

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 78: SELECT cn_reasons_s.NEXTVAL

74: -- API body
75: l_reasons_all_rec := p_reasons_all_rec;
76: --
77: BEGIN
78: SELECT cn_reasons_s.NEXTVAL
79: INTO l_reasons_all_rec.reason_id
80: FROM DUAL;
81: EXCEPTION
82: WHEN OTHERS THEN

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 142: FROM cn_reasons r

138: x_loading_status OUT NOCOPY VARCHAR2) IS
139: --
140: CURSOR reason_cur(l_reason_id NUMBER) IS
141: SELECT *
142: FROM cn_reasons r
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;

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 270: FROM cn_reasons r

266: x_loading_status OUT NOCOPY VARCHAR2) IS
267: --
268: CURSOR reason_cur(l_reason_id NUMBER) IS
269: SELECT *
270: FROM cn_reasons r
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;

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 390: FROM cn_reasons

386: x_loading_status OUT NOCOPY VARCHAR2) IS
387: --
388: CURSOR reason_cur IS
389: SELECT reason_id
390: FROM cn_reasons
391: WHERE upd_table_id = p_payment_worksheet_id;
392: --
393: CURSOR history_cur IS
394: SELECT reason_history_id

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