1 PACKAGE OKE_STANDARD_NOTES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPNOTS.pls 115.6 2002/08/14 01:42:27 alaw ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_STANDARD_NOTES_PUB';
5 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6
7 SUBTYPE note_rec_type IS oke_note_pvt.note_rec_type;
8
9 PROCEDURE create_standard_note(
10
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2,
16
17 p_note_rec IN oke_note_pvt.note_rec_type,
18 x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
19
20 PROCEDURE create_standard_note(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26
27 p_note_tbl IN oke_note_pvt.note_tbl_type,
28 x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
29
30
31 PROCEDURE update_standard_note(
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_note_rec IN oke_note_pvt.note_rec_type,
38 x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
39
40
41 PROCEDURE update_standard_note(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_note_tbl IN oke_note_pvt.note_tbl_type,
48 x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
49
50
51 PROCEDURE delete_standard_note(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_note_rec IN oke_note_pvt.note_rec_type);
58
59
60 PROCEDURE delete_standard_note(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_note_tbl IN oke_note_pvt.note_tbl_type);
67
68
69 /* this one below takes in standard_note_id straight */
70
71 PROCEDURE delete_standard_note(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_note_id IN NUMBER);
78
79
80 /* this one takes one of these three, k_header_id,k_line_id,deliverable_id
81 the other two Must be left NULL */
82
83 PROCEDURE delete_standard_note(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_hdr_id IN NUMBER,
90 p_cle_id IN NUMBER,
91 p_del_id IN NUMBER);
92
93
94 PROCEDURE validate_standard_note(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_note_rec IN oke_note_pvt.note_rec_type);
101
102 PROCEDURE validate_standard_note(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_note_tbl IN oke_note_pvt.note_tbl_type);
109
110
111 /*
112 10/11/2000
113 I have modified this procedure to allow for more flexible copy.
114 The old way of calling this procedure is still compatible.
115 The new way of using this procedure is as follows:
116
117 You still specify only one 'from' value.
118 either p_from_hdr_id, p_from_cle_id or p_from_del_id.
119 This is where the standard_note(s) will be sourced. For example,
120 if you specify a p_from_hdr_id, the procedure will grab all
121 the standard_notes belonging to that header
122 (but NOT its children).
123
124 However, now you can specify one or more 'to' values.
125 If you do not specify a particular 'to' value ( p_to_hdr_id,
126 p_to_cle_id or p_to_del_id ), then the k_header_id,k_line_id,
127 deliverable_id will be copied along from the old standard_note
128 record into the new standard_note record respectively.
129
130 Note: if you do not specify any of the 3 'to' values, you would
131 have basically copied the standard_notes from the origin back
132 into the origin, creating a duplicate!
133
134 ---!!ATTENTION!! below is the old comment ---------
135 same for copy, only one pair may be not null. the other
136 two pairs Must be NULL.
137 No cross-copying allowed. eg. copying from header12's Line to
138 header27's Line.
139 */
140
141 PROCEDURE copy_standard_note(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_from_hdr_id IN NUMBER,
148 p_to_hdr_id IN NUMBER,
149 p_from_cle_id IN NUMBER,
150 p_to_cle_id IN NUMBER,
151 p_from_del_id IN NUMBER,
152 p_to_del_id IN NUMBER,
153 default_flag IN VARCHAR2
154 );
155
156
157 PROCEDURE lock_standard_note(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_note_rec IN OKE_NOTE_PVT.note_rec_type);
164
165 PROCEDURE lock_standard_note(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_note_tbl IN oke_note_pvt.note_tbl_type);
172
173 END OKE_STANDARD_NOTES_PUB;
174