DBA Data[Home] [Help]

APPS.OKL_TRX_EXTENSION_PVT dependencies on OKC_API

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

17: -- End : PRASJAIN : Bug# 6268782
18: ------------------------------------------------------------------------------
19: -- Global Variables
20: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_EXTENSION_PVT';
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
25: ------------------------------------------------------------------------------

Line 34: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

30:
31: --Object type procedure for insert
32: PROCEDURE create_trx_extension(
33: p_api_version IN NUMBER
34: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
35: ,x_return_status OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER
37: ,x_msg_data OUT NOCOPY VARCHAR2
38: ,p_tehv_rec IN tehv_rec_type

Line 47: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

43:
44: --Object type procedure for update
45: PROCEDURE update_trx_extension(
46: p_api_version IN NUMBER
47: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
48: ,x_return_status OUT NOCOPY VARCHAR2
49: ,x_msg_count OUT NOCOPY NUMBER
50: ,x_msg_data OUT NOCOPY VARCHAR2
51: ,p_tehv_rec IN tehv_rec_type

Line 60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

56:
57: --Object type procedure for validate
58: PROCEDURE validate_trx_extension(
59: p_api_version IN NUMBER
60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
61: ,x_return_status OUT NOCOPY VARCHAR2
62: ,x_msg_count OUT NOCOPY NUMBER
63: ,x_msg_data OUT NOCOPY VARCHAR2
64: ,p_tehv_rec IN tehv_rec_type

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68:
69: --Object type procedure for create
70: PROCEDURE create_trx_extension(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_tehv_tbl IN tehv_tbl_type,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78:
79: --Object type procedure for create
80: PROCEDURE create_trx_extension(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_tehv_rec IN tehv_rec_type,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88:
89: --Object type procedure for lock
90: PROCEDURE lock_trx_extension(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_tehv_tbl IN tehv_tbl_type);

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

97:
98: --Object type procedure for lock
99: PROCEDURE lock_trx_extension(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_tehv_rec IN tehv_rec_type);

Line 110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

106:
107: --Object type procedure for update
108: PROCEDURE update_trx_extension(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_tehv_tbl IN tehv_tbl_type,

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

116:
117: --Object type procedure for update
118: PROCEDURE update_trx_extension(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_tehv_rec IN tehv_rec_type,

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

126:
127: --Object type procedure for delete
128: PROCEDURE delete_trx_extension(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_tehv_tbl IN tehv_tbl_type);

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

135:
136: --Object type procedure for delete
137: PROCEDURE delete_trx_extension(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_tehv_rec IN tehv_rec_type);

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

144:
145: --Object type procedure for validate
146: PROCEDURE validate_trx_extension(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_tehv_tbl IN tehv_tbl_type);

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153:
154: --Object type procedure for validate
155: PROCEDURE validate_trx_extension(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_tehv_rec IN tehv_rec_type);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162:
163: --Object type procedure for create
164: PROCEDURE create_txl_extension(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_telv_tbl IN telv_tbl_type,

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

172:
173: --Object type procedure for create
174: PROCEDURE create_txl_extension(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_telv_rec IN telv_rec_type,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

182:
183: --Object type procedure for lock
184: PROCEDURE lock_txl_extension(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_telv_tbl IN telv_tbl_type);

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

191:
192: --Object type procedure for lock
193: PROCEDURE lock_txl_extension(
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_telv_rec IN telv_rec_type);

Line 204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

200:
201: --Object type procedure for update
202: PROCEDURE update_txl_extension(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_telv_tbl IN telv_tbl_type,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210:
211: --Object type procedure for update
212: PROCEDURE update_txl_extension(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_telv_rec IN telv_rec_type,

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220:
221: --Object type procedure for delete
222: PROCEDURE delete_txl_extension(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_telv_tbl IN telv_tbl_type);

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229:
230: --Object type procedure for delete
231: PROCEDURE delete_txl_extension(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_telv_rec IN telv_rec_type);

Line 242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

238:
239: --Object type procedure for validate
240: PROCEDURE validate_txl_extension(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_telv_tbl IN telv_tbl_type);

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

247:
248: --Object type procedure for validate
249: PROCEDURE validate_txl_extension(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_telv_rec IN telv_rec_type);

Line 261: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

257: --Object type procedure for validate
258: --Added : PRASJAIN : Bug# 6268782
259: PROCEDURE create_trx_extension(
260: p_api_version IN NUMBER
261: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER
264: ,x_msg_data OUT NOCOPY VARCHAR2
265: ,p_teh_rec IN teh_rec_type

Line 274: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

270: --Object type procedure for validate
271: --Added : PRASJAIN : Bug# 6268782
272: PROCEDURE create_txl_extension(
273: p_api_version IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
275: ,x_return_status OUT NOCOPY VARCHAR2
276: ,x_msg_count OUT NOCOPY NUMBER
277: ,x_msg_data OUT NOCOPY VARCHAR2
278: ,p_tel_rec IN tel_rec_type

Line 287: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

283: --Object type procedure for validate
284: --Added : PRASJAIN : Bug# 6268782
285: PROCEDURE create_txl_extension(
286: p_api_version IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
288: ,x_return_status OUT NOCOPY VARCHAR2
289: ,x_msg_count OUT NOCOPY NUMBER
290: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_tel_tbl_tbl IN tel_tbl_tbl_type