[Home] [Help]
PACKAGE: APPS.OKE_NOTE_PVT
Source
1 PACKAGE OKE_NOTE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVNOTS.pls 115.11 2002/11/20 20:42:03 who ship $*/
3 -- GLOBAL DATA STRUCTURES
4
5 TYPE note_rec_type IS RECORD(
6
7 STANDARD_NOTES_ID NUMBER:= OKE_API.G_MISS_NUM,
8 CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
9 CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
10 LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
11 LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
12 LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
13 K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
14 K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
15 DELIVERABLE_ID NUMBER:= OKE_API.G_MISS_NUM,
16 TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17 ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18 ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19 ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20 ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21 ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22 ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23 ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24 ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25 ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26 ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27 ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28 ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29 ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30 ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31 ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32 ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33
34 SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35 DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36 NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37 TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38
39 default_flag OKE_K_STANDARD_NOTES_B.default_flag%TYPE:=OKE_API.G_MISS_CHAR
40
41 );
42
43 TYPE note_tbl_type IS TABLE OF note_rec_type
44 INDEX BY BINARY_INTEGER;
45
46 -- GLOBAL MESSAGE CONSTANTS
47
48 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
49
50 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
51 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
52
53 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
54
55 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
56 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
57 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
58 G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
59 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
60 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
61
62 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
63 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
64 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
65 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
66 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
67 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_NOTE_PVT';
68 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
69 G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_STANDARD_NOTES_VL';
70
71 G_EXCEPTION_HALT_VALIDATION exception;
72
73 -- Procedures and functions
74
75 PROCEDURE insert_row(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_note_rec IN note_rec_type,
82 x_note_rec OUT NOCOPY note_rec_type);
83
84 PROCEDURE insert_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_note_tbl IN note_tbl_type,
91 x_note_tbl OUT NOCOPY note_tbl_type);
92
93 PROCEDURE update_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_note_rec IN note_rec_type,
100 x_note_rec OUT NOCOPY note_rec_type);
101
102 PROCEDURE update_row(
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 note_tbl_type,
109 x_note_tbl OUT NOCOPY note_tbl_type);
110
111 PROCEDURE delete_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_del_id IN NUMBER);
118
119 PROCEDURE delete_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_cle_id IN NUMBER);
126
127 PROCEDURE delete_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_hdr_id IN NUMBER);
134
135
136 PROCEDURE delete_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_note_rec IN note_rec_type);
143
144 PROCEDURE delete_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_note_tbl IN note_tbl_type);
151
152
153 PROCEDURE validate_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_note_rec IN note_rec_type);
160
161 PROCEDURE validate_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_note_tbl IN note_tbl_type);
168
169 PROCEDURE lock_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_note_rec IN note_rec_type);
176
177 PROCEDURE add_language;
178
179 END OKE_NOTE_PVT;
180