[Home] [Help]
PACKAGE: APPS.OKS_INTERACTION_HIST_PVT
Source
1 PACKAGE OKS_INTERACTION_HIST_PVT AS
2 /* $Header: OKSINTHS.pls 120.0 2005/05/25 18:21:43 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_INTERACTION_HIST_V Record Spec
7 TYPE inhv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,chr_id NUMBER := OKC_API.G_MISS_NUM
10 ,contract_number OKS_INTERACTION_HIST_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11 ,contract_number_modifier OKS_INTERACTION_HIST_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
12 ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13 ,party_id NUMBER := OKC_API.G_MISS_NUM
14 ,user_id NUMBER := OKC_API.G_MISS_NUM
15 ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16 ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17 ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18 ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19 ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20 ,created_by NUMBER := OKC_API.G_MISS_NUM
21 ,last_update_date OKS_INTERACTION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24 ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
25 G_MISS_inhv_rec inhv_rec_type;
26 TYPE inhv_tbl_type IS TABLE OF inhv_rec_type
27 INDEX BY BINARY_INTEGER;
28 -- OKS_INTERACTION_HISTORY Record Spec
29 TYPE inh_rec_type IS RECORD (
30 id NUMBER := OKC_API.G_MISS_NUM
31 ,chr_id NUMBER := OKC_API.G_MISS_NUM
32 ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33 ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34 ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35 ,party_id NUMBER := OKC_API.G_MISS_NUM
36 ,user_id NUMBER := OKC_API.G_MISS_NUM
37 ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38 ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39 ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40 ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41 ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42 ,created_by NUMBER := OKC_API.G_MISS_NUM
43 ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46 ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
47 G_MISS_inh_rec inh_rec_type;
48 TYPE inh_tbl_type IS TABLE OF inh_rec_type
49 INDEX BY BINARY_INTEGER;
50 ---------------------------------------------------------------------------
51 -- GLOBAL MESSAGE CONSTANTS
52 ---------------------------------------------------------------------------
53 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
54 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
55 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
56 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
57 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
58 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
59 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
60 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
61 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
62 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
63 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
64 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
65 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
66
67 ---------------------------------------------------------------------------
68 -- GLOBAL EXCEPTIONS
69 ---------------------------------------------------------------------------
70 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
71
72 ---------------------------------------------------------------------------
73 -- GLOBAL VARIABLES
74 ---------------------------------------------------------------------------
75 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_INTERACTION_HIST_PVT';
76 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
77 ---------------------------------------------------------------------------
78 -- Procedures and Functions
79 ---------------------------------------------------------------------------
80
81 PROCEDURE qc;
82 PROCEDURE change_version;
83 PROCEDURE api_copy;
84 PROCEDURE insert_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_inhv_rec IN inhv_rec_type,
91 x_inhv_rec OUT NOCOPY inhv_rec_type);
92 PROCEDURE insert_row(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_inhv_tbl IN inhv_tbl_type,
99 x_inhv_tbl OUT NOCOPY inhv_tbl_type,
100 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
101 PROCEDURE insert_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_inhv_tbl IN inhv_tbl_type,
108 x_inhv_tbl OUT NOCOPY inhv_tbl_type);
109 PROCEDURE lock_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_inhv_rec IN inhv_rec_type);
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_inhv_tbl IN inhv_tbl_type,
123 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
124 PROCEDURE lock_row(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_inhv_tbl IN inhv_tbl_type);
131 PROCEDURE update_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_inhv_rec IN inhv_rec_type,
138 x_inhv_rec OUT NOCOPY inhv_rec_type);
139 PROCEDURE update_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_inhv_tbl IN inhv_tbl_type,
146 x_inhv_tbl OUT NOCOPY inhv_tbl_type,
147 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148 PROCEDURE update_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_inhv_tbl IN inhv_tbl_type,
155 x_inhv_tbl OUT NOCOPY inhv_tbl_type);
156 PROCEDURE delete_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_inhv_rec IN inhv_rec_type);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_inhv_tbl IN inhv_tbl_type,
170 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_inhv_tbl IN inhv_tbl_type);
178 PROCEDURE validate_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_inhv_rec IN inhv_rec_type);
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_inhv_tbl IN inhv_tbl_type,
192 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193 PROCEDURE validate_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_inhv_tbl IN inhv_tbl_type);
200 END OKS_INTERACTION_HIST_PVT;