59: BEGIN
60: --initialize local variables
61: l_api_name := 'okc_rep_con_md';
62:
63: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(
65: FND_LOG.LEVEL_PROCEDURE,
66: G_MODULE||l_api_name,
67: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
60: --initialize local variables
61: l_api_name := 'okc_rep_con_md';
62:
63: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(
65: FND_LOG.LEVEL_PROCEDURE,
66: G_MODULE||l_api_name,
67: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
68: END IF;
61: l_api_name := 'okc_rep_con_md';
62:
63: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(
65: FND_LOG.LEVEL_PROCEDURE,
66: G_MODULE||l_api_name,
67: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
68: END IF;
69:
100: END IF;
101:
102: CLOSE con_cur;
103:
104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(
106: FND_LOG.LEVEL_PROCEDURE,
107: G_MODULE||l_api_name,
108: 'Added contract metadata');
101:
102: CLOSE con_cur;
103:
104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(
106: FND_LOG.LEVEL_PROCEDURE,
107: G_MODULE||l_api_name,
108: 'Added contract metadata');
109: END IF;
102: CLOSE con_cur;
103:
104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(
106: FND_LOG.LEVEL_PROCEDURE,
107: G_MODULE||l_api_name,
108: 'Added contract metadata');
109: END IF;
110:
134: END IF;
135:
136: CLOSE con_cur;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING(
140: FND_LOG.LEVEL_PROCEDURE,
141: G_MODULE||l_api_name,
142: 'Added internal party metadata');
135:
136: CLOSE con_cur;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING(
140: FND_LOG.LEVEL_PROCEDURE,
141: G_MODULE||l_api_name,
142: 'Added internal party metadata');
143: END IF;
136: CLOSE con_cur;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING(
140: FND_LOG.LEVEL_PROCEDURE,
141: G_MODULE||l_api_name,
142: 'Added internal party metadata');
143: END IF;
144:
165: END IF;
166:
167: CLOSE con_cur;
168:
169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(
171: FND_LOG.LEVEL_PROCEDURE,
172: G_MODULE||l_api_name,
173: 'Added supplier party metadata');
166:
167: CLOSE con_cur;
168:
169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(
171: FND_LOG.LEVEL_PROCEDURE,
172: G_MODULE||l_api_name,
173: 'Added supplier party metadata');
174: END IF;
167: CLOSE con_cur;
168:
169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(
171: FND_LOG.LEVEL_PROCEDURE,
172: G_MODULE||l_api_name,
173: 'Added supplier party metadata');
174: END IF;
175:
196:
197:
198: CLOSE con_cur;
199:
200: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(
202: FND_LOG.LEVEL_PROCEDURE,
203: G_MODULE||l_api_name,
204: 'Added partner party metadata');
197:
198: CLOSE con_cur;
199:
200: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(
202: FND_LOG.LEVEL_PROCEDURE,
203: G_MODULE||l_api_name,
204: 'Added partner party metadata');
205: END IF;
198: CLOSE con_cur;
199:
200: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(
202: FND_LOG.LEVEL_PROCEDURE,
203: G_MODULE||l_api_name,
204: 'Added partner party metadata');
205: END IF;
206:
230: END IF;
231:
232: CLOSE con_cur;
233:
234: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(
236: FND_LOG.LEVEL_PROCEDURE,
237: G_MODULE||l_api_name,
238: 'Added internal party contact metadata');
231:
232: CLOSE con_cur;
233:
234: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(
236: FND_LOG.LEVEL_PROCEDURE,
237: G_MODULE||l_api_name,
238: 'Added internal party contact metadata');
239: END IF;
232: CLOSE con_cur;
233:
234: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(
236: FND_LOG.LEVEL_PROCEDURE,
237: G_MODULE||l_api_name,
238: 'Added internal party contact metadata');
239: END IF;
240:
260: END IF;
261:
262: CLOSE con_cur;
263:
264: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(
266: FND_LOG.LEVEL_PROCEDURE,
267: G_MODULE||l_api_name,
268: 'Added supplier party contact metadata');
261:
262: CLOSE con_cur;
263:
264: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(
266: FND_LOG.LEVEL_PROCEDURE,
267: G_MODULE||l_api_name,
268: 'Added supplier party contact metadata');
269: END IF;
262: CLOSE con_cur;
263:
264: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(
266: FND_LOG.LEVEL_PROCEDURE,
267: G_MODULE||l_api_name,
268: 'Added supplier party contact metadata');
269: END IF;
270:
290: END IF;
291:
292: CLOSE con_cur;
293:
294: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(
296: FND_LOG.LEVEL_PROCEDURE,
297: G_MODULE||l_api_name,
298: 'Added customer and partner party contact metadata');
291:
292: CLOSE con_cur;
293:
294: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(
296: FND_LOG.LEVEL_PROCEDURE,
297: G_MODULE||l_api_name,
298: 'Added customer and partner party contact metadata');
299: END IF;
292: CLOSE con_cur;
293:
294: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(
296: FND_LOG.LEVEL_PROCEDURE,
297: G_MODULE||l_api_name,
298: 'Added customer and partner party contact metadata');
299: END IF;
300:
297: G_MODULE||l_api_name,
298: 'Added customer and partner party contact metadata');
299: END IF;
300:
301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING(
303: FND_LOG.LEVEL_PROCEDURE,
304: G_MODULE||l_api_name,
305: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
298: 'Added customer and partner party contact metadata');
299: END IF;
300:
301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING(
303: FND_LOG.LEVEL_PROCEDURE,
304: G_MODULE||l_api_name,
305: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
306: END IF;
299: END IF;
300:
301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.STRING(
303: FND_LOG.LEVEL_PROCEDURE,
304: G_MODULE||l_api_name,
305: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
306: END IF;
307: END;
348: BEGIN
349: --initialize local variables
350: l_api_name := 'okc_rep_ver_md';
351:
352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.STRING(
354: FND_LOG.LEVEL_PROCEDURE,
355: G_MODULE||l_api_name,
356: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
349: --initialize local variables
350: l_api_name := 'okc_rep_ver_md';
351:
352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.STRING(
354: FND_LOG.LEVEL_PROCEDURE,
355: G_MODULE||l_api_name,
356: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
357: END IF;
350: l_api_name := 'okc_rep_ver_md';
351:
352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.STRING(
354: FND_LOG.LEVEL_PROCEDURE,
355: G_MODULE||l_api_name,
356: 'Entering APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
357: END IF;
358:
389: END IF;
390:
391: CLOSE con_cur;
392:
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_PROCEDURE,
396: G_MODULE||l_api_name,
397: 'Added contract metadata');
390:
391: CLOSE con_cur;
392:
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_PROCEDURE,
396: G_MODULE||l_api_name,
397: 'Added contract metadata');
398: END IF;
391: CLOSE con_cur;
392:
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_PROCEDURE,
396: G_MODULE||l_api_name,
397: 'Added contract metadata');
398: END IF;
399:
423: END IF;
424:
425: CLOSE con_cur;
426:
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FND_LOG.STRING(
429: FND_LOG.LEVEL_PROCEDURE,
430: G_MODULE||l_api_name,
431: 'Added internal party metadata');
424:
425: CLOSE con_cur;
426:
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FND_LOG.STRING(
429: FND_LOG.LEVEL_PROCEDURE,
430: G_MODULE||l_api_name,
431: 'Added internal party metadata');
432: END IF;
425: CLOSE con_cur;
426:
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FND_LOG.STRING(
429: FND_LOG.LEVEL_PROCEDURE,
430: G_MODULE||l_api_name,
431: 'Added internal party metadata');
432: END IF;
433:
454: END IF;
455:
456: CLOSE con_cur;
457:
458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(
460: FND_LOG.LEVEL_PROCEDURE,
461: G_MODULE||l_api_name,
462: 'Added supplier party metadata');
455:
456: CLOSE con_cur;
457:
458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(
460: FND_LOG.LEVEL_PROCEDURE,
461: G_MODULE||l_api_name,
462: 'Added supplier party metadata');
463: END IF;
456: CLOSE con_cur;
457:
458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(
460: FND_LOG.LEVEL_PROCEDURE,
461: G_MODULE||l_api_name,
462: 'Added supplier party metadata');
463: END IF;
464:
485:
486:
487: CLOSE con_cur;
488:
489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(
491: FND_LOG.LEVEL_PROCEDURE,
492: G_MODULE||l_api_name,
493: 'Added partner party metadata');
486:
487: CLOSE con_cur;
488:
489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(
491: FND_LOG.LEVEL_PROCEDURE,
492: G_MODULE||l_api_name,
493: 'Added partner party metadata');
494: END IF;
487: CLOSE con_cur;
488:
489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(
491: FND_LOG.LEVEL_PROCEDURE,
492: G_MODULE||l_api_name,
493: 'Added partner party metadata');
494: END IF;
495:
519: END IF;
520:
521: CLOSE con_cur;
522:
523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(
525: FND_LOG.LEVEL_PROCEDURE,
526: G_MODULE||l_api_name,
527: 'Added internal party contact metadata');
520:
521: CLOSE con_cur;
522:
523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(
525: FND_LOG.LEVEL_PROCEDURE,
526: G_MODULE||l_api_name,
527: 'Added internal party contact metadata');
528: END IF;
521: CLOSE con_cur;
522:
523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(
525: FND_LOG.LEVEL_PROCEDURE,
526: G_MODULE||l_api_name,
527: 'Added internal party contact metadata');
528: END IF;
529:
549: END IF;
550:
551: CLOSE con_cur;
552:
553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(
555: FND_LOG.LEVEL_PROCEDURE,
556: G_MODULE||l_api_name,
557: 'Added supplier party contact metadata');
550:
551: CLOSE con_cur;
552:
553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(
555: FND_LOG.LEVEL_PROCEDURE,
556: G_MODULE||l_api_name,
557: 'Added supplier party contact metadata');
558: END IF;
551: CLOSE con_cur;
552:
553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(
555: FND_LOG.LEVEL_PROCEDURE,
556: G_MODULE||l_api_name,
557: 'Added supplier party contact metadata');
558: END IF;
559:
579: END IF;
580:
581: CLOSE con_cur;
582:
583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
584: FND_LOG.STRING(
585: FND_LOG.LEVEL_PROCEDURE,
586: G_MODULE||l_api_name,
587: 'Added customer and partner party contact metadata');
580:
581: CLOSE con_cur;
582:
583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
584: FND_LOG.STRING(
585: FND_LOG.LEVEL_PROCEDURE,
586: G_MODULE||l_api_name,
587: 'Added customer and partner party contact metadata');
588: END IF;
581: CLOSE con_cur;
582:
583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
584: FND_LOG.STRING(
585: FND_LOG.LEVEL_PROCEDURE,
586: G_MODULE||l_api_name,
587: 'Added customer and partner party contact metadata');
588: END IF;
589:
586: G_MODULE||l_api_name,
587: 'Added customer and partner party contact metadata');
588: END IF;
589:
590: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: FND_LOG.STRING(
592: FND_LOG.LEVEL_PROCEDURE,
593: G_MODULE||l_api_name,
594: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
587: 'Added customer and partner party contact metadata');
588: END IF;
589:
590: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: FND_LOG.STRING(
592: FND_LOG.LEVEL_PROCEDURE,
593: G_MODULE||l_api_name,
594: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
595: END IF;
588: END IF;
589:
590: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
591: FND_LOG.STRING(
592: FND_LOG.LEVEL_PROCEDURE,
593: G_MODULE||l_api_name,
594: 'Leaving APPS.OKC_REP_CONTRACT_TEXT_IDX_PVT.okc_rep_ver_md');
595: END IF;
596: END;