APPS.CN_REASONS_PUB dependencies on CN_REASONS_PUB

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 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 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,