DBA Data[Home] [Help]

APPS.OKL_AP_EXTENSION_PVT dependencies on OKC_API

Line 18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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: ------------------------------------------------------------------------------

Line 31: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 44: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 57: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 248: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 258: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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