eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_CONTRACT_PUB dependencies on OKE_API

Line 16: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;

12: subtype clev_rec_type is okc_contract_pub.clev_rec_type;
13: subtype clev_tbl_type is okc_contract_pub.clev_tbl_type;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_CONTRACT_PUB';
16: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
17:
18: PROCEDURE Assign_Doc_Number
19: ( X_K_Type_Code IN VARCHAR2
20: , X_Buy_Or_Sell IN VARCHAR2

Line 28: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

24: );
25:
26: PROCEDURE create_contract_header(
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_chr_rec IN oke_chr_pvt.chr_rec_type,

Line 40: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

36:
37: PROCEDURE create_contract_header(
38:
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44:

Line 52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

48: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
49:
50: PROCEDURE update_contract_header(
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 56: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
57: p_chr_rec IN oke_chr_pvt.chr_rec_type,
58: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
59:
60: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

61: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type);
62:
63: PROCEDURE update_contract_header(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 69: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

65: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
70: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
71: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
72:
73: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

74: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type);
75:
76: PROCEDURE delete_contract_header(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_chr_rec IN oke_chr_pvt.chr_rec_type,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

83: p_chrv_rec IN okc_contract_pub.chrv_rec_type);
84:
85: PROCEDURE delete_contract_header(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

94:
95:
96: PROCEDURE validate_contract_header(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_chr_rec IN oke_chr_pvt.chr_rec_type,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

103: p_chrv_rec IN okc_contract_pub.chrv_rec_type);
104:
105: PROCEDURE validate_contract_header(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_chr_tbl IN oke_chr_pvt.chr_tbl_type,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

113:
114: PROCEDURE create_contract_line(
115:
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 121: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
122: p_cle_rec IN oke_cle_pvt.cle_rec_type,
123: p_clev_rec IN okc_contract_pub.clev_rec_type,
124: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
125: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

125: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
126:
127: PROCEDURE create_contract_line(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 133: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

129: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
134: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
135: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
136: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
137: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

137: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
138:
139: PROCEDURE update_contract_line(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 145: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

141: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
146: p_cle_rec IN oke_cle_pvt.cle_rec_type,
147: p_clev_rec IN okc_contract_pub.clev_rec_type,
148:
149: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

150: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type);
151:
152: PROCEDURE update_contract_line(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

Line 158: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,

154: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
159: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
160: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
161:
162: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

163: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type);
164:
165: PROCEDURE delete_contract_line(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_cle_rec IN oke_cle_pvt.cle_rec_type,

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

172: p_clev_rec IN okc_contract_pub.clev_rec_type);
173:
174: PROCEDURE delete_contract_line(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_tbl IN oke_cle_pvt.cle_tbl_type,

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

181: p_clev_tbl IN okc_contract_pub.clev_tbl_type);
182:
183: PROCEDURE delete_contract_line(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_line_id IN NUMBER);

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

190:
191:
192: PROCEDURE validate_contract_line(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cle_rec IN oke_cle_pvt.cle_rec_type,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

199: p_clev_rec IN okc_contract_pub.clev_rec_type);
200:
201: PROCEDURE validate_contract_line(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

208: p_clev_tbl IN okc_contract_pub.clev_tbl_type);
209:
210: PROCEDURE create_deliverable(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

218:
219:
220: PROCEDURE create_deliverable(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

227: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
228:
229: PROCEDURE update_deliverable(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type,

Line 240: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

236: x_del_rec OUT NOCOPY OKE_DELIVERABLE_PVT.del_rec_type);
237:
238: PROCEDURE update_deliverable(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type,

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

245: x_del_tbl OUT NOCOPY OKE_DELIVERABLE_PVT.del_tbl_type);
246:
247: PROCEDURE delete_deliverable(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

253: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
254:
255: PROCEDURE delete_deliverable(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);

Line 266: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

262:
263:
264: PROCEDURE delete_deliverable(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_deliverable_id IN NUMBER);

Line 275: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

271:
272:
273: PROCEDURE validate_deliverable(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);

Line 283: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

279: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
280:
281: PROCEDURE validate_deliverable(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);

Line 291: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

287: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
288:
289: PROCEDURE lock_deliverable(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);

Line 299: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

295: p_del_rec IN OKE_DELIVERABLE_PVT.del_rec_type);
296:
297: PROCEDURE lock_deliverable(
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);

Line 307: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

303: p_del_tbl IN OKE_DELIVERABLE_PVT.del_tbl_type);
304:
305: PROCEDURE default_deliverable (
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_header_id IN NUMBER,

Line 320: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

316:
317:
318: PROCEDURE Check_Delete_Contract(
319: p_api_version IN NUMBER,
320: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2,
324: p_chr_id IN NUMBER,

Line 330: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

326:
327:
328: PROCEDURE delete_contract (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2,
334: p_chr_id IN NUMBER,