1 PACKAGE cn_reasons_pvt AUTHID CURRENT_USER AS
2 -- $Header: cnvresns.pls 115.1 2002/11/21 21:16:51 hlchen ship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- Package Name
10 -- CN_REASON_PVT
11 -- Purpose
12 -- Package specifications for Analyst Notes (JSP). This package is built
13 -- on top of the table handler.
14 -- History
15 -- 04/02/02 Rao.Chenna Created
16 /*--------------------------------------------------------------------------
17 API name : insert_row
18 Type : Private
19 Pre-reqs :
20 Usage : This is the main procedure that gets the data populate the
21 Analyst Notes JSP.
22 Desc :
23 Parameters
24 IN : p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
26 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27 p_commit IN VARCHAR2 := CN_API.G_FALSE,
28 p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
29
30 OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_loading_status OUT NOCOPY VARCHAR2
34
35 Notes : This procedure calls the table handler to create a record in the
36 cn_reasons table. reason_id is the primary key in the table and the
37 value is derived from sequence number in this procedure. It also
38 validates for the NOT NULL columns.
39 --------------------------------------------------------------------------*/
40 PROCEDURE insert_row(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
43 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
44 p_commit IN VARCHAR2 := CN_API.G_FALSE,
45 p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_loading_status OUT NOCOPY VARCHAR2);
50
51 /*--------------------------------------------------------------------------
52 API name : update_row
53 Type : Private
54 Pre-reqs :
55 Usage : This is the main procedure that gets the data populate the
56 Analyst Notes JSP.
57 Desc :
58 Parameters
59 IN : p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
62 p_commit IN VARCHAR2 := CN_API.G_FALSE,
63 p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
64
65 OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_loading_status OUT NOCOPY VARCHAR2
69
70 Notes : This procedure calls the update table handler to update
71 the exsiting data. While updating, it will keep the
72 original data in cn_reason_history table. It also does
73 the validation for NOT NULL columns.
74 --------------------------------------------------------------------------*/
75
76 PROCEDURE update_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
80 p_commit IN VARCHAR2 := CN_API.G_FALSE,
81 p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 x_loading_status OUT NOCOPY VARCHAR2);
86 /*--------------------------------------------------------------------------
87 API name : delete_notes
88 Type : Private
89 Pre-reqs :
90 Usage : This is the main procedure to delete the analyst notes
91 corresponding to the checkboxes selected from the JSP.
92 Desc :
93 Parameters
94 IN : p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
96 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97 p_commit IN VARCHAR2 := CN_API.G_FALSE,
98 p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
99
100 OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 x_loading_status OUT NOCOPY VARCHAR2
104
105 Notes : This procedure deletes the record from cn_reasons table
106 and create a new record with the same data in
107 cn_reason_history table.
108 --------------------------------------------------------------------------*/
109 PROCEDURE delete_notes(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113 p_commit IN VARCHAR2 := CN_API.G_FALSE,
114 p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 x_loading_status OUT NOCOPY VARCHAR2);
119 /*--------------------------------------------------------------------------
120 API name : delete_worksheet_notes
121 Type : Private
122 Pre-reqs :
123 Usage : This is the main procedure to delete all the analyst notes
124 corresponding to a worksheet.
125 Desc :
126 Parameters
127 IN : p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
130 p_commit IN VARCHAR2 := CN_API.G_FALSE,
131 p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
132
133 OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 x_loading_status OUT NOCOPY VARCHAR2
137
138 Notes : Apart from deleting the records from cn_reasons table, it
139 also deletes the records in the cn_reason_history table.
140 --------------------------------------------------------------------------*/
141 PROCEDURE delete_worksheet_notes(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
144 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145 p_commit IN VARCHAR2 := CN_API.G_FALSE,
146 p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 x_loading_status OUT NOCOPY VARCHAR2);
151 END; -- Package spec