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.OKC_SCN_PVT dependencies on OKC_SCN_PVT

Line 1: PACKAGE BODY OKC_SCN_PVT AS

1: PACKAGE BODY OKC_SCN_PVT AS
2: /* $Header: OKCSSCNB.pls 120.0 2005/05/25 22:50:29 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 25: okc_debug.Set_Indentation('OKC_SCN_PVT');

21:
22: Begin
23:
24: IF (l_debug = 'Y') THEN
25: okc_debug.Set_Indentation('OKC_SCN_PVT');
26: okc_debug.log('100: Entered validate_scn_type', 2);
27: END IF;
28:
29: -- initialize return status

Line 113: okc_debug.Set_Indentation('OKC_SCN_PVT');

109:
110: Begin
111:
112: IF (l_debug = 'Y') THEN
113: okc_debug.Set_Indentation('OKC_SCN_PVT');
114: okc_debug.log('500: Entered validate_chr_id', 2);
115: END IF;
116:
117: -- initialize return status

Line 194: okc_debug.Set_Indentation('OKC_SCN_PVT');

190: AND satv.lookup_type = 'OKC_ARTICLE_SET';
191: BEGIN
192:
193: IF (l_debug = 'Y') THEN
194: okc_debug.Set_Indentation('OKC_SCN_PVT');
195: okc_debug.log('800: Entered validate_sat_code', 2);
196: END IF;
197:
198: -- initialize return status

Line 290: okc_debug.Set_Indentation('OKC_SCN_PVT');

286:
287: Begin
288:
289: IF (l_debug = 'Y') THEN
290: okc_debug.Set_Indentation('OKC_SCN_PVT');
291: okc_debug.log('1200: Entered validate_section_sequence', 2);
292: END IF;
293:
294: -- initialize return status

Line 349: okc_debug.Set_Indentation('OKC_SCN_PVT');

345:
346: Begin
347:
348: IF (l_debug = 'Y') THEN
349: okc_debug.Set_Indentation('OKC_SCN_PVT');
350: okc_debug.log('1500: Entered validate_sfwt_flag', 2);
351: END IF;
352:
353: -- initialize return status

Line 436: okc_debug.Set_Indentation('OKC_SCN_PVT');

432:
433: Begin
434:
435: IF (l_debug = 'Y') THEN
436: okc_debug.Set_Indentation('OKC_SCN_PVT');
437: okc_debug.log('1900: Entered validate_scn_id', 2);
438: END IF;
439:
440: -- initialize return status

Line 513: okc_debug.Set_Indentation('OKC_SCN_PVT');

509: PROCEDURE add_language IS
510: BEGIN
511:
512: IF (l_debug = 'Y') THEN
513: okc_debug.Set_Indentation('OKC_SCN_PVT');
514: okc_debug.log('2300: Entered add_language', 2);
515: END IF;
516:
517: DELETE FROM OKC_SECTIONS_TL T

Line 695: okc_debug.Set_Indentation('OKC_SCN_PVT');

691: l_scn_rec scn_rec_type;
692: BEGIN
693:
694: IF (l_debug = 'Y') THEN
695: okc_debug.Set_Indentation('OKC_SCN_PVT');
696: okc_debug.log('2400: Entered get_rec', 2);
697: END IF;
698:
699: x_no_data_found := TRUE;

Line 781: okc_debug.Set_Indentation('OKC_SCN_PVT');

777: l_okc_sections_tl_rec okc_sections_tl_rec_type;
778: BEGIN
779:
780: IF (l_debug = 'Y') THEN
781: okc_debug.Set_Indentation('OKC_SCN_PVT');
782: okc_debug.log('2600: Entered get_rec', 2);
783: END IF;
784:
785: x_no_data_found := TRUE;

Line 872: okc_debug.Set_Indentation('OKC_SCN_PVT');

868: l_scnv_rec scnv_rec_type;
869: BEGIN
870:
871: IF (l_debug = 'Y') THEN
872: okc_debug.Set_Indentation('OKC_SCN_PVT');
873: okc_debug.log('2800: Entered get_rec', 2);
874: END IF;
875:
876: x_no_data_found := TRUE;

Line 948: okc_debug.Set_Indentation('OKC_SCN_PVT');

944: l_scnv_rec scnv_rec_type := p_scnv_rec;
945: BEGIN
946:
947: IF (l_debug = 'Y') THEN
948: okc_debug.Set_Indentation('OKC_SCN_PVT');
949: okc_debug.log('3000: Entered null_out_defaults', 2);
950: END IF;
951:
952: IF (l_scnv_rec.id = OKC_API.G_MISS_NUM) THEN

Line 1068: okc_debug.Set_Indentation('OKC_SCN_PVT');

1064: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1065: BEGIN
1066:
1067: IF (l_debug = 'Y') THEN
1068: okc_debug.Set_Indentation('OKC_SCN_PVT');
1069: okc_debug.log('3100: Entered Validate_Attributes', 2);
1070: END IF;
1071:
1072: /************************ HAND-CODED *********************************/

Line 1212: okc_debug.Set_Indentation('OKC_SCN_PVT');

1208:
1209: BEGIN
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.Set_Indentation('OKC_SCN_PVT');
1213: okc_debug.log('3400: Entered Validate_Record', 2);
1214: END IF;
1215:
1216:

Line 1415: okc_debug.Set_Indentation('OKC_SCN_PVT');

1411: l_okc_sections_tl_rec okc_sections_tl_rec_type;
1412: BEGIN
1413:
1414: IF (l_debug = 'Y') THEN
1415: okc_debug.Set_Indentation('OKC_SCN_PVT');
1416: okc_debug.log('4100: Entered validate_row', 2);
1417: END IF;
1418:
1419: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1521: okc_debug.Set_Indentation('OKC_SCN_PVT');

1517: i NUMBER := 0;
1518: BEGIN
1519:
1520: IF (l_debug = 'Y') THEN
1521: okc_debug.Set_Indentation('OKC_SCN_PVT');
1522: okc_debug.log('4600: Entered validate_row', 2);
1523: END IF;
1524:
1525: OKC_API.init_msg_list(p_init_msg_list);

Line 1631: okc_debug.Set_Indentation('OKC_SCN_PVT');

1627: END Set_Attributes;
1628: BEGIN
1629:
1630: IF (l_debug = 'Y') THEN
1631: okc_debug.Set_Indentation('OKC_SCN_PVT');
1632: okc_debug.log('5200: Entered insert_row', 2);
1633: END IF;
1634:
1635: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1814: okc_debug.Set_Indentation('OKC_SCN_PVT');

1810: END Set_Attributes;
1811: BEGIN
1812:
1813: IF (l_debug = 'Y') THEN
1814: okc_debug.Set_Indentation('OKC_SCN_PVT');
1815: okc_debug.log('5800: Entered insert_row', 2);
1816: END IF;
1817:
1818: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1989: okc_debug.Set_Indentation('OKC_SCN_PVT');

1985: END Set_Attributes;
1986: BEGIN
1987:
1988: IF (l_debug = 'Y') THEN
1989: okc_debug.Set_Indentation('OKC_SCN_PVT');
1990: okc_debug.log('6500: Entered insert_row', 2);
1991: END IF;
1992:
1993: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2148: okc_debug.Set_Indentation('OKC_SCN_PVT');

2144: i NUMBER := 0;
2145: BEGIN
2146:
2147: IF (l_debug = 'Y') THEN
2148: okc_debug.Set_Indentation('OKC_SCN_PVT');
2149: okc_debug.log('7000: Entered insert_row', 2);
2150: END IF;
2151:
2152: OKC_API.init_msg_list(p_init_msg_list);

Line 2263: okc_debug.Set_Indentation('OKC_SCN_PVT');

2259: lc_row_notfound BOOLEAN := FALSE;
2260: BEGIN
2261:
2262: IF (l_debug = 'Y') THEN
2263: okc_debug.Set_Indentation('OKC_SCN_PVT');
2264: okc_debug.log('7500: Entered lock_row', 2);
2265: END IF;
2266:
2267: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2278: -- okc_debug.Set_Indentation('OKC_SCN_PVT');

2274: RAISE OKC_API.G_EXCEPTION_ERROR;
2275: END IF;
2276: BEGIN
2277:
2278: -- okc_debug.Set_Indentation('OKC_SCN_PVT');
2279: -- okc_debug.log('7600: Entered lock_row', 2);
2280:
2281: OPEN lock_csr(p_scn_rec);
2282: FETCH lock_csr INTO l_object_version_number;

Line 2405: okc_debug.Set_Indentation('OKC_SCN_PVT');

2401: lc_row_notfound BOOLEAN := FALSE;
2402: BEGIN
2403:
2404: IF (l_debug = 'Y') THEN
2405: okc_debug.Set_Indentation('OKC_SCN_PVT');
2406: okc_debug.log('8300: Entered lock_row', 2);
2407: END IF;
2408:
2409: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2420: -- okc_debug.Set_Indentation('OKC_SCN_PVT');

2416: RAISE OKC_API.G_EXCEPTION_ERROR;
2417: END IF;
2418: BEGIN
2419:
2420: -- okc_debug.Set_Indentation('OKC_SCN_PVT');
2421: -- okc_debug.log('8400: Entered lock_row', 2);
2422:
2423: OPEN lock_csr(p_okc_sections_tl_rec);
2424: FETCH lock_csr INTO l_lock_var;

Line 2524: okc_debug.Set_Indentation('OKC_SCN_PVT');

2520: l_okc_sections_tl_rec okc_sections_tl_rec_type;
2521: BEGIN
2522:
2523: IF (l_debug = 'Y') THEN
2524: okc_debug.Set_Indentation('OKC_SCN_PVT');
2525: okc_debug.log('9100: Entered lock_row', 2);
2526: END IF;
2527:
2528: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2647: okc_debug.Set_Indentation('OKC_SCN_PVT');

2643: i NUMBER := 0;
2644: BEGIN
2645:
2646: IF (l_debug = 'Y') THEN
2647: okc_debug.Set_Indentation('OKC_SCN_PVT');
2648: okc_debug.log('9600: Entered lock_row', 2);
2649: END IF;
2650:
2651: OKC_API.init_msg_list(p_init_msg_list);

Line 2758: okc_debug.Set_Indentation('OKC_SCN_PVT');

2754: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2755: BEGIN
2756:
2757: IF (l_debug = 'Y') THEN
2758: okc_debug.Set_Indentation('OKC_SCN_PVT');
2759: okc_debug.log('10100: Entered populate_new_record', 2);
2760: END IF;
2761:
2762: x_scn_rec := p_scn_rec;

Line 2909: okc_debug.Set_Indentation('OKC_SCN_PVT');

2905: END Set_Attributes;
2906: BEGIN
2907:
2908: IF (l_debug = 'Y') THEN
2909: okc_debug.Set_Indentation('OKC_SCN_PVT');
2910: okc_debug.log('10300: Entered update_row', 2);
2911: END IF;
2912:
2913: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3058: okc_debug.Set_Indentation('OKC_SCN_PVT');

3054: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3055: BEGIN
3056:
3057: IF (l_debug = 'Y') THEN
3058: okc_debug.Set_Indentation('OKC_SCN_PVT');
3059: okc_debug.log('10800: Entered populate_new_record', 2);
3060: END IF;
3061:
3062: x_okc_sections_tl_rec := p_okc_sections_tl_rec;

Line 3135: okc_debug.Set_Indentation('OKC_SCN_PVT');

3131: END Set_Attributes;
3132: BEGIN
3133:
3134: IF (l_debug = 'Y') THEN
3135: okc_debug.Set_Indentation('OKC_SCN_PVT');
3136: okc_debug.log('11000: Entered update_row', 2);
3137: END IF;
3138:
3139: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3288: okc_debug.Set_Indentation('OKC_SCN_PVT');

3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: BEGIN
3286:
3287: IF (l_debug = 'Y') THEN
3288: okc_debug.Set_Indentation('OKC_SCN_PVT');
3289: okc_debug.log('11600: Entered populate_new_record', 2);
3290: END IF;
3291:
3292: x_scnv_rec := p_scnv_rec;

Line 3449: okc_debug.Set_Indentation('OKC_SCN_PVT');

3445: END Set_Attributes;
3446: BEGIN
3447:
3448: IF (l_debug = 'Y') THEN
3449: okc_debug.Set_Indentation('OKC_SCN_PVT');
3450: okc_debug.log('11800: Entered update_row', 2);
3451: END IF;
3452:
3453: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3612: okc_debug.Set_Indentation('OKC_SCN_PVT');

3608: i NUMBER := 0;
3609: BEGIN
3610:
3611: IF (l_debug = 'Y') THEN
3612: okc_debug.Set_Indentation('OKC_SCN_PVT');
3613: okc_debug.log('12300: Entered update_row', 2);
3614: END IF;
3615:
3616: OKC_API.init_msg_list(p_init_msg_list);

Line 3712: okc_debug.Set_Indentation('OKC_SCN_PVT');

3708: l_row_notfound BOOLEAN := TRUE;
3709: BEGIN
3710:
3711: IF (l_debug = 'Y') THEN
3712: okc_debug.Set_Indentation('OKC_SCN_PVT');
3713: okc_debug.log('12800: Entered delete_row', 2);
3714: END IF;
3715:
3716: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3819: okc_debug.Set_Indentation('OKC_SCN_PVT');

3815: END Set_Attributes;
3816: BEGIN
3817:
3818: IF (l_debug = 'Y') THEN
3819: okc_debug.Set_Indentation('OKC_SCN_PVT');
3820: okc_debug.log('13400: Entered delete_row', 2);
3821: END IF;
3822:
3823: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3923: okc_debug.Set_Indentation('OKC_SCN_PVT');

3919: l_scn_rec scn_rec_type;
3920: BEGIN
3921:
3922: IF (l_debug = 'Y') THEN
3923: okc_debug.Set_Indentation('OKC_SCN_PVT');
3924: okc_debug.log('13900: Entered delete_row', 2);
3925: END IF;
3926:
3927: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4047: okc_debug.Set_Indentation('OKC_SCN_PVT');

4043: i NUMBER := 0;
4044: BEGIN
4045:
4046: IF (l_debug = 'Y') THEN
4047: okc_debug.Set_Indentation('OKC_SCN_PVT');
4048: okc_debug.log('14400: Entered delete_row', 2);
4049: END IF;
4050:
4051: OKC_API.init_msg_list(p_init_msg_list);

Line 4140: okc_debug.Set_Indentation('OKC_SCN_PVT');

4136:
4137: BEGIN
4138:
4139: IF (l_debug = 'Y') THEN
4140: okc_debug.Set_Indentation('OKC_SCN_PVT');
4141: okc_debug.log('14900: Entered create_version', 2);
4142: END IF;
4143:
4144: INSERT INTO okc_sections_bh

Line 4291: okc_debug.Set_Indentation('OKC_SCN_PVT');

4287:
4288: BEGIN
4289:
4290: IF (l_debug = 'Y') THEN
4291: okc_debug.Set_Indentation('OKC_SCN_PVT');
4292: okc_debug.log('15200: Entered restore_version', 2);
4293: END IF;
4294:
4295: INSERT INTO okc_sections_tl

Line 4426: END OKC_SCN_PVT;

4422:
4423: END restore_version;
4424: --
4425:
4426: END OKC_SCN_PVT;