[Home] [Help]
PACKAGE: APPS.OKC_PHL_PVT
Source
1 PACKAGE OKC_PHL_PVT AS
2 /* $Header: OKCSPHLS.pls 120.0 2005/05/26 09:57:26 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKC_PH_LINE_BREAKS_V Record Spec
7 TYPE okc_ph_line_breaks_v_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,cle_id NUMBER := OKC_API.G_MISS_NUM
10 ,value_from NUMBER := OKC_API.G_MISS_NUM
11 ,value_to NUMBER := OKC_API.G_MISS_NUM
12 ,pricing_type OKC_PH_LINE_BREAKS_V.PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
13 ,value NUMBER := OKC_API.G_MISS_NUM
14 ,start_date OKC_PH_LINE_BREAKS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,end_date OKC_PH_LINE_BREAKS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17 ,created_by NUMBER := OKC_API.G_MISS_NUM
18 ,creation_date OKC_PH_LINE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20 ,last_update_date OKC_PH_LINE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22 ,program_id NUMBER := OKC_API.G_MISS_NUM
23 ,program_update_date OKC_PH_LINE_BREAKS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24 ,request_id NUMBER := OKC_API.G_MISS_NUM
25 ,integrated_with_qp OKC_PH_LINE_BREAKS_V.INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR
26 ,qp_reference_id NUMBER := OKC_API.G_MISS_NUM
27 ,ship_to_organization_id NUMBER := OKC_API.G_MISS_NUM
28 ,ship_to_location_id NUMBER := OKC_API.G_MISS_NUM
29 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
30 GMissOkcPhLineBreaksVRec okc_ph_line_breaks_v_rec_type;
31 TYPE okc_ph_line_breaks_v_tbl_type IS TABLE OF okc_ph_line_breaks_v_rec_type
32 INDEX BY BINARY_INTEGER;
33 -- OKC_PH_LINE_BREAKS Record Spec
34 TYPE okc_ph_line_breaks_rec_type IS RECORD (
35 id NUMBER := OKC_API.G_MISS_NUM
36 ,cle_id NUMBER := OKC_API.G_MISS_NUM
37 ,value_from NUMBER := OKC_API.G_MISS_NUM
38 ,value_to NUMBER := OKC_API.G_MISS_NUM
39 ,pricing_type OKC_PH_LINE_BREAKS.PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
40 ,value NUMBER := OKC_API.G_MISS_NUM
41 ,start_date OKC_PH_LINE_BREAKS.START_DATE%TYPE := OKC_API.G_MISS_DATE
42 ,end_date OKC_PH_LINE_BREAKS.END_DATE%TYPE := OKC_API.G_MISS_DATE
43 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
44 ,created_by NUMBER := OKC_API.G_MISS_NUM
45 ,creation_date OKC_PH_LINE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47 ,last_update_date OKC_PH_LINE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
49 ,program_id NUMBER := OKC_API.G_MISS_NUM
50 ,program_update_date OKC_PH_LINE_BREAKS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
51 ,request_id NUMBER := OKC_API.G_MISS_NUM
52 ,integrated_with_qp OKC_PH_LINE_BREAKS.INTEGRATED_WITH_QP%TYPE := OKC_API.G_MISS_CHAR
53 ,qp_reference_id NUMBER := OKC_API.G_MISS_NUM
54 ,ship_to_organization_id NUMBER := OKC_API.G_MISS_NUM
55 ,ship_to_location_id NUMBER := OKC_API.G_MISS_NUM
56 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
57 G_MISS_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
58 TYPE okc_ph_line_breaks_tbl_type IS TABLE OF okc_ph_line_breaks_rec_type
59 INDEX BY BINARY_INTEGER;
60 ---------------------------------------------------------------------------
61 -- GLOBAL MESSAGE CONSTANTS
62 ---------------------------------------------------------------------------
63 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
64 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
65 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
66 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
67 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
68 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
69 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
70 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
71 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
72 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
73 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
74 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
75 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
76
77 ---------------------------------------------------------------------------
78 -- GLOBAL EXCEPTIONS
79 ---------------------------------------------------------------------------
80 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
81
82 ---------------------------------------------------------------------------
83 -- GLOBAL VARIABLES
84 ---------------------------------------------------------------------------
85 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PHL_PVT';
86 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
87 ---------------------------------------------------------------------------
88 -- Procedures and Functions
89 ---------------------------------------------------------------------------
90
91 PROCEDURE qc;
92 PROCEDURE change_version;
93 PROCEDURE api_copy;
94 PROCEDURE insert_row(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
101 x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type);
102 PROCEDURE insert_row(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
109 x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
110 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
111 PROCEDURE insert_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
118 x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type);
119 PROCEDURE lock_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type);
126 PROCEDURE lock_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
133 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
134 PROCEDURE lock_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type);
141 PROCEDURE update_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
148 x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type);
149 PROCEDURE update_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
156 x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
157 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
158 PROCEDURE update_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
165 x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type);
166 PROCEDURE delete_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type);
173 PROCEDURE delete_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
180 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
181 PROCEDURE delete_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type);
188 PROCEDURE validate_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type);
195 PROCEDURE validate_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
202 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
203 PROCEDURE validate_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type);
210
211
212 FUNCTION create_version(
213 p_chr_id IN NUMBER,
214 p_major_version IN NUMBER) RETURN VARCHAR2;
215
216 FUNCTION restore_version(
217 p_chr_id IN NUMBER,
218 p_major_version IN NUMBER) RETURN VARCHAR2;
219
220
221 END OKC_PHL_PVT;