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_PUB dependencies on CN_REASONS

Line 1: PACKAGE BODY CN_REASONS_PUB AS

1: PACKAGE BODY CN_REASONS_PUB AS
2: -- $Header: cnpresnb.pls 115.3 2003/07/04 01:36:09 jjhuang ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1994 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 10: -- cn_reasons_pub

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

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_REASONS_PUB';

13: -- History
14: -- 04/02/02 Rao.Chenna Created
15: -- 06/16/03 Julia Huang Added show_last_analyst_note for 11.5.10
16: --
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_REASONS_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpresnb.pls';
19: --
20: /*
21: PROCEDURE my_debug(

Line 58: x_worksheet_rec OUT NOCOPY cn_reasons_pub.worksheet_rec,

54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: x_loading_status OUT NOCOPY VARCHAR2,
58: x_worksheet_rec OUT NOCOPY cn_reasons_pub.worksheet_rec,
59: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,
60: x_notes_count OUT NOCOPY NUMBER) IS
61: --
62: CURSOR c1 IS

Line 59: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,

55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: x_loading_status OUT NOCOPY VARCHAR2,
58: x_worksheet_rec OUT NOCOPY cn_reasons_pub.worksheet_rec,
59: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,
60: x_notes_count OUT NOCOPY NUMBER) IS
61: --
62: CURSOR c1 IS
63: SELECT w.payment_worksheet_id,w.role_id,w.worksheet_status,

Line 80: FROM cn_reasons r,fnd_user u,cn_lookups l

76: AND w.payment_worksheet_id = p_payment_worksheet_id;
77: --
78: CURSOR c2 IS
79: SELECT r.*, u.user_name,l.meaning
80: FROM cn_reasons r,fnd_user u,cn_lookups l
81: WHERE upd_table_id = p_payment_worksheet_id
82: AND r.lookup_type = p_lookup_type
83: AND updated_table = p_table_name
84: AND r.last_updated_by = u.user_id

Line 91: l_worksheet_rec cn_reasons_pub.worksheet_rec;

87: ORDER BY r.last_update_date;
88: --
89: l_api_name CONSTANT VARCHAR2(30) := 'show_analyst_notes';
90: l_api_version CONSTANT NUMBER := 1.0;
91: l_worksheet_rec cn_reasons_pub.worksheet_rec;
92: l_tbl_count NUMBER := 0;
93: l_total_rows NUMBER := 0;
94: l_clob_loc CLOB;
95: l_clob_length NUMBER;

Line 197: p_notes_tbl IN cn_reasons_pub.notes_tbl,

193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
195: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
196: p_commit IN VARCHAR2 := CN_API.G_FALSE,
197: p_notes_tbl IN cn_reasons_pub.notes_tbl,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: x_loading_status OUT NOCOPY VARCHAR2) IS

Line 205: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;

201: x_loading_status OUT NOCOPY VARCHAR2) IS
202: --
203: l_api_name CONSTANT VARCHAR2(30) := 'manage_analyst_notes';
204: l_api_version CONSTANT NUMBER := 1.0;
205: l_reasons_all_rec CN_REASONS_PKG.REASONS_ALL_REC_TYPE;
206: --
207: BEGIN
208: -- Standard Start of API savepoint
209: SAVEPOINT manage_analyst_notes;

Line 260: cn_reasons_pvt.insert_row(

256: l_reasons_all_rec.attribute15 := p_notes_tbl(i).attribute15;
257: l_reasons_all_rec.object_version_number:= p_notes_tbl(i).object_version_number;
258: --
259: IF (p_notes_tbl(i).dml_flag = 'INSERT') THEN
260: cn_reasons_pvt.insert_row(
261: p_api_version => l_api_version,
262: p_init_msg_list => p_init_msg_list,
263: p_validation_level => p_validation_level,
264: p_commit => p_commit,

Line 271: cn_reasons_pvt.update_row(

267: x_msg_count => x_msg_count,
268: x_msg_data => x_msg_data,
269: x_loading_status => x_loading_status);
270: ELSIF (p_notes_tbl(i).dml_flag = 'UPDATE') THEN
271: cn_reasons_pvt.update_row(
272: p_api_version => l_api_version,
273: p_init_msg_list => p_init_msg_list,
274: p_validation_level => p_validation_level,
275: p_commit => p_commit,

Line 354: cn_reasons_pvt.delete_notes(

350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352: x_loading_status := 'CN_INSERTED';
353: -- API body
354: cn_reasons_pvt.delete_notes(
355: p_api_version => l_api_version,
356: p_init_msg_list => p_init_msg_list,
357: p_validation_level => p_validation_level,
358: p_commit => p_commit,

Line 416: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,

412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: x_loading_status OUT NOCOPY VARCHAR2,
416: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,
417: x_notes_count OUT NOCOPY NUMBER)
418: IS
419: CURSOR get_notes_count(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
420: p_lookup_type cn_reasons.lookup_type%TYPE,

Line 420: p_lookup_type cn_reasons.lookup_type%TYPE,

416: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,
417: x_notes_count OUT NOCOPY NUMBER)
418: IS
419: CURSOR get_notes_count(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
420: p_lookup_type cn_reasons.lookup_type%TYPE,
421: p_table_name cn_reasons.updated_table%TYPE)
422: IS
423: SELECT COUNT(1) cnt
424: FROM cn_reasons r

Line 421: p_table_name cn_reasons.updated_table%TYPE)

417: x_notes_count OUT NOCOPY NUMBER)
418: IS
419: CURSOR get_notes_count(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
420: p_lookup_type cn_reasons.lookup_type%TYPE,
421: p_table_name cn_reasons.updated_table%TYPE)
422: IS
423: SELECT COUNT(1) cnt
424: FROM cn_reasons r
425: WHERE r.upd_table_id = p_payment_worksheet_id

Line 424: FROM cn_reasons r

420: p_lookup_type cn_reasons.lookup_type%TYPE,
421: p_table_name cn_reasons.updated_table%TYPE)
422: IS
423: SELECT COUNT(1) cnt
424: FROM cn_reasons r
425: WHERE r.upd_table_id = p_payment_worksheet_id
426: AND r.lookup_type = p_lookup_type
427: AND r.updated_table = p_table_name;
428:

Line 430: p_lookup_type cn_reasons.lookup_type%TYPE,

426: AND r.lookup_type = p_lookup_type
427: AND r.updated_table = p_table_name;
428:
429: CURSOR get_notes_info(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
430: p_lookup_type cn_reasons.lookup_type%TYPE,
431: p_table_name cn_reasons.updated_table%TYPE)
432: IS
433: SELECT v.*
434: FROM

Line 431: p_table_name cn_reasons.updated_table%TYPE)

427: AND r.updated_table = p_table_name;
428:
429: CURSOR get_notes_info(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
430: p_lookup_type cn_reasons.lookup_type%TYPE,
431: p_table_name cn_reasons.updated_table%TYPE)
432: IS
433: SELECT v.*
434: FROM
435: (

Line 437: FROM cn_reasons r,fnd_user u,cn_lookups l

433: SELECT v.*
434: FROM
435: (
436: SELECT r.*, u.user_name,l.meaning
437: FROM cn_reasons r,fnd_user u,cn_lookups l
438: WHERE upd_table_id = p_payment_worksheet_id
439: AND r.lookup_type = p_lookup_type
440: AND updated_table = p_table_name
441: AND r.last_updated_by = u.user_id