14: -- End : PRASJAIN : Bug# 6268782
15: ------------------------------------------------------------------------------
16: -- Global Variables
17: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AP_EXTENSION_PVT';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
22: ------------------------------------------------------------------------------
27:
28: --Object type procedure for insert
29: PROCEDURE create_pxh_extension(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER
34: ,x_msg_data OUT NOCOPY VARCHAR2
35: ,p_pxhv_rec IN pxhv_rec_type
40:
41: --Object type procedure for update
42: PROCEDURE update_pxh_extension(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45: ,x_return_status OUT NOCOPY VARCHAR2
46: ,x_msg_count OUT NOCOPY NUMBER
47: ,x_msg_data OUT NOCOPY VARCHAR2
48: ,p_pxhv_rec IN pxhv_rec_type
53:
54: --Object type procedure for validate
55: PROCEDURE validate_pxh_extension(
56: p_api_version IN NUMBER
57: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_pxhv_rec IN pxhv_rec_type
65:
66: --Object type procedure for create
67: PROCEDURE create_pxh_extension(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_pxhv_tbl IN pxhv_tbl_type,
75:
76: --Object type procedure for create
77: PROCEDURE create_pxh_extension(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pxhv_rec IN pxhv_rec_type,
85:
86: --Object type procedure for lock
87: PROCEDURE lock_pxh_extension(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_pxhv_tbl IN pxhv_tbl_type);
94:
95: --Object type procedure for lock
96: PROCEDURE lock_pxh_extension(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_pxhv_rec IN pxhv_rec_type);
103:
104: --Object type procedure for update
105: PROCEDURE update_pxh_extension(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pxhv_tbl IN pxhv_tbl_type,
113:
114: --Object type procedure for update
115: PROCEDURE update_pxh_extension(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_pxhv_rec IN pxhv_rec_type,
123:
124: --Object type procedure for delete
125: PROCEDURE delete_pxh_extension(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_pxhv_tbl IN pxhv_tbl_type);
132:
133: --Object type procedure for delete
134: PROCEDURE delete_pxh_extension(
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_pxhv_rec IN pxhv_rec_type);
141:
142: --Object type procedure for validate
143: PROCEDURE validate_pxh_extension(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pxhv_tbl IN pxhv_tbl_type);
150:
151: --Object type procedure for validate
152: PROCEDURE validate_pxh_extension(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_pxhv_rec IN pxhv_rec_type);
159:
160: --Object type procedure for create
161: PROCEDURE create_pxl_extension(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pxlv_tbl IN pxlv_tbl_type,
169:
170: --Object type procedure for create
171: PROCEDURE create_pxl_extension(
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_pxlv_rec IN pxlv_rec_type,
179:
180: --Object type procedure for lock
181: PROCEDURE lock_pxl_extension(
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_pxlv_tbl IN pxlv_tbl_type);
188:
189: --Object type procedure for lock
190: PROCEDURE lock_pxl_extension(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_pxlv_rec IN pxlv_rec_type);
197:
198: --Object type procedure for update
199: PROCEDURE update_pxl_extension(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_pxlv_tbl IN pxlv_tbl_type,
207:
208: --Object type procedure for update
209: PROCEDURE update_pxl_extension(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_pxlv_rec IN pxlv_rec_type,
217:
218: --Object type procedure for delete
219: PROCEDURE delete_pxl_extension(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_pxlv_tbl IN pxlv_tbl_type);
226:
227: --Object type procedure for delete
228: PROCEDURE delete_pxl_extension(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_pxlv_rec IN pxlv_rec_type);
235:
236: --Object type procedure for validate
237: PROCEDURE validate_pxl_extension(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_pxlv_tbl IN pxlv_tbl_type);
244:
245: --Object type procedure for validate
246: PROCEDURE validate_pxl_extension(
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_pxlv_rec IN pxlv_rec_type);
254: --Object type procedure for insert
255: --Added for Bug# 6268782 : PRASJAIN
256: PROCEDURE create_pxh_extension(
257: p_api_version IN NUMBER
258: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2
262: ,p_pxh_rec IN pxh_rec_type
267: --Object type procedure for insert
268: --Added for Bug# 6268782 : PRASJAIN
269: PROCEDURE create_pxl_extension(
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
272: ,x_return_status OUT NOCOPY VARCHAR2
273: ,x_msg_count OUT NOCOPY NUMBER
274: ,x_msg_data OUT NOCOPY VARCHAR2
275: ,p_pxl_rec IN pxl_rec_type