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