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_CAT_PVT dependencies on OKC_CAT_PVT

Line 1: PACKAGE BODY OKC_CAT_PVT AS

1: PACKAGE BODY OKC_CAT_PVT AS
2: /* $Header: OKCSCATB.pls 120.0 2005/05/26 09:32:19 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: /*+++++++++++++Start of hand code +++++++++++++++++*/

Line 58: okc_debug.Set_Indentation('OKC_CAT_PVT');

54: PROCEDURE add_language IS
55: BEGIN
56:
57: IF (l_debug = 'Y') THEN
58: okc_debug.Set_Indentation('OKC_CAT_PVT');
59: okc_debug.log('500: Entered add_language', 2);
60: END IF;
61:
62: DELETE FROM OKC_K_ARTICLES_TL T

Line 308: okc_debug.Set_Indentation('OKC_CAT_PVT');

304: l_cat_rec cat_rec_type;
305: BEGIN
306:
307: IF (l_debug = 'Y') THEN
308: okc_debug.Set_Indentation('OKC_CAT_PVT');
309: okc_debug.log('700: Entered get_rec', 2);
310: END IF;
311:
312: x_no_data_found := TRUE;

Line 401: okc_debug.Set_Indentation('OKC_CAT_PVT');

397: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
398: BEGIN
399:
400: IF (l_debug = 'Y') THEN
401: okc_debug.Set_Indentation('OKC_CAT_PVT');
402: okc_debug.log('900: Entered get_rec', 2);
403: END IF;
404:
405: x_no_data_found := TRUE;

Line 498: okc_debug.Set_Indentation('OKC_CAT_PVT');

494: l_catv_rec catv_rec_type;
495: BEGIN
496:
497: IF (l_debug = 'Y') THEN
498: okc_debug.Set_Indentation('OKC_CAT_PVT');
499: okc_debug.log('1000: Entered get_rec', 2);
500: END IF;
501:
502: x_no_data_found := TRUE;

Line 575: okc_debug.Set_Indentation('OKC_CAT_PVT');

571: l_catv_rec catv_rec_type := p_catv_rec;
572: BEGIN
573:
574: IF (l_debug = 'Y') THEN
575: okc_debug.Set_Indentation('OKC_CAT_PVT');
576: okc_debug.log('1100: Entered null_out_defaults', 2);
577: END IF;
578:
579: IF (l_catv_rec.chr_id = OKC_API.G_MISS_NUM) THEN

Line 715: okc_debug.Set_Indentation('OKC_CAT_PVT');

711: l_dummy_var varchar2(1) := '?';
712: begin
713:
714: IF (l_debug = 'Y') THEN
715: okc_debug.Set_Indentation('OKC_CAT_PVT');
716: okc_debug.log('1300: Entered validate_sbt_code', 2);
717: END IF;
718:
719: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 765: okc_debug.Set_Indentation('OKC_CAT_PVT');

761: p_catv_rec IN catv_rec_TYPE) is
762: begin
763:
764: IF (l_debug = 'Y') THEN
765: okc_debug.Set_Indentation('OKC_CAT_PVT');
766: okc_debug.log('1600: Entered validate_cat_type', 2);
767: END IF;
768:
769: if (P_catv_rec.cat_type in ('STA','NSD',OKC_API.G_MISS_CHAR)) then

Line 801: okc_debug.Set_Indentation('OKC_CAT_PVT');

797: p_catv_rec IN catv_rec_TYPE) is
798: begin
799:
800: IF (l_debug = 'Y') THEN
801: okc_debug.Set_Indentation('OKC_CAT_PVT');
802: okc_debug.log('1800: Entered validate_fulltext_yn', 2);
803: END IF;
804:
805: if (P_catv_rec.fulltext_yn in ('Y','N',OKC_API.G_MISS_CHAR)

Line 840: okc_debug.Set_Indentation('OKC_CAT_PVT');

836: where id = p_catv_rec.dnz_chr_id;
837: begin
838:
839: IF (l_debug = 'Y') THEN
840: okc_debug.Set_Indentation('OKC_CAT_PVT');
841: okc_debug.log('2000: Entered validate_dnz_chr_id', 2);
842: END IF;
843:
844: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 906: okc_debug.Set_Indentation('OKC_CAT_PVT');

902: where id = p_catv_rec.cat_id;
903: begin
904:
905: IF (l_debug = 'Y') THEN
906: okc_debug.Set_Indentation('OKC_CAT_PVT');
907: okc_debug.log('2300: Entered validate_cat_id', 2);
908: END IF;
909:
910: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 966: okc_debug.Set_Indentation('OKC_CAT_PVT');

962: where id = p_catv_rec.cle_id;
963: begin
964:
965: IF (l_debug = 'Y') THEN
966: okc_debug.Set_Indentation('OKC_CAT_PVT');
967: okc_debug.log('2600: Entered validate_cle_id', 2);
968: END IF;
969:
970: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1026: okc_debug.Set_Indentation('OKC_CAT_PVT');

1022: where id = p_catv_rec.chr_id;
1023: begin
1024:
1025: IF (l_debug = 'Y') THEN
1026: okc_debug.Set_Indentation('OKC_CAT_PVT');
1027: okc_debug.log('2900: Entered validate_chr_id', 2);
1028: END IF;
1029:
1030: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1080: okc_debug.Set_Indentation('OKC_CAT_PVT');

1076: /*-------------Commented in favor of hand code------
1077: BEGIN
1078:
1079: IF (l_debug = 'Y') THEN
1080: okc_debug.Set_Indentation('OKC_CAT_PVT');
1081: okc_debug.log('3200: Entered Validate_Attributes', 2);
1082: END IF;
1083:
1084: IF p_catv_rec.id = OKC_API.G_MISS_NUM OR

Line 1222: okc_debug.Set_Indentation('OKC_CAT_PVT');

1218: l_dummy_var VARCHAR2(1) := '?';
1219: BEGIN
1220:
1221: IF (l_debug = 'Y') THEN
1222: okc_debug.Set_Indentation('OKC_CAT_PVT');
1223: okc_debug.log('3500: Entered Validate_Record', 2);
1224: END IF;
1225:
1226: if (p_catv_rec.CAT_TYPE) = 'STA' then

Line 1469: okc_debug.Set_Indentation('OKC_CAT_PVT');

1465: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
1466: BEGIN
1467:
1468: IF (l_debug = 'Y') THEN
1469: okc_debug.Set_Indentation('OKC_CAT_PVT');
1470: okc_debug.log('3800: Entered validate_row', 2);
1471: END IF;
1472:
1473: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1575: okc_debug.Set_Indentation('OKC_CAT_PVT');

1571: i NUMBER := 0;
1572: BEGIN
1573:
1574: IF (l_debug = 'Y') THEN
1575: okc_debug.Set_Indentation('OKC_CAT_PVT');
1576: okc_debug.log('4300: Entered validate_row', 2);
1577: END IF;
1578:
1579: OKC_API.init_msg_list(p_init_msg_list);

Line 1689: okc_debug.Set_Indentation('OKC_CAT_PVT');

1685: END Set_Attributes;
1686: BEGIN
1687:
1688: IF (l_debug = 'Y') THEN
1689: okc_debug.Set_Indentation('OKC_CAT_PVT');
1690: okc_debug.log('4800: Entered insert_row', 2);
1691: END IF;
1692:
1693: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1875: okc_debug.Set_Indentation('OKC_CAT_PVT');

1871: END Set_Attributes;
1872: BEGIN
1873:
1874: IF (l_debug = 'Y') THEN
1875: okc_debug.Set_Indentation('OKC_CAT_PVT');
1876: okc_debug.log('5300: Entered insert_row', 2);
1877: END IF;
1878:
1879: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2024: okc_debug.Set_Indentation('OKC_CAT_PVT');

2020: l_catv_rec catv_rec_type := p_catv_rec;
2021: BEGIN
2022:
2023: IF (l_debug = 'Y') THEN
2024: okc_debug.Set_Indentation('OKC_CAT_PVT');
2025: okc_debug.log('5800: Entered fill_who_columns', 2);
2026: END IF;
2027:
2028: l_catv_rec.CREATION_DATE := SYSDATE;

Line 2066: okc_debug.Set_Indentation('OKC_CAT_PVT');

2062: END Set_Attributes;
2063: BEGIN
2064:
2065: IF (l_debug = 'Y') THEN
2066: okc_debug.Set_Indentation('OKC_CAT_PVT');
2067: okc_debug.log('6000: Entered insert_row', 2);
2068: END IF;
2069:
2070: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2225: okc_debug.Set_Indentation('OKC_CAT_PVT');

2221: i NUMBER := 0;
2222: BEGIN
2223:
2224: IF (l_debug = 'Y') THEN
2225: okc_debug.Set_Indentation('OKC_CAT_PVT');
2226: okc_debug.log('6500: Entered insert_row', 2);
2227: END IF;
2228:
2229: OKC_API.init_msg_list(p_init_msg_list);

Line 2340: okc_debug.Set_Indentation('OKC_CAT_PVT');

2336: lc_row_notfound BOOLEAN := FALSE;
2337: BEGIN
2338:
2339: IF (l_debug = 'Y') THEN
2340: okc_debug.Set_Indentation('OKC_CAT_PVT');
2341: okc_debug.log('7000: Entered lock_row', 2);
2342: END IF;
2343:
2344: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2479: okc_debug.Set_Indentation('OKC_CAT_PVT');

2475: lc_row_notfound BOOLEAN := FALSE;
2476: BEGIN
2477:
2478: IF (l_debug = 'Y') THEN
2479: okc_debug.Set_Indentation('OKC_CAT_PVT');
2480: okc_debug.log('8000: Entered lock_row', 2);
2481: END IF;
2482:
2483: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2600: okc_debug.Set_Indentation('OKC_CAT_PVT');

2596: l_okc_k_articles_tl_rec okc_k_articles_tl_rec_type;
2597: BEGIN
2598:
2599: IF (l_debug = 'Y') THEN
2600: okc_debug.Set_Indentation('OKC_CAT_PVT');
2601: okc_debug.log('8700: Entered lock_row', 2);
2602: END IF;
2603:
2604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2724: okc_debug.Set_Indentation('OKC_CAT_PVT');

2720: i NUMBER := 0;
2721: BEGIN
2722:
2723: IF (l_debug = 'Y') THEN
2724: okc_debug.Set_Indentation('OKC_CAT_PVT');
2725: okc_debug.log('9400: Entered lock_row', 2);
2726: END IF;
2727:
2728: OKC_API.init_msg_list(p_init_msg_list);

Line 2835: okc_debug.Set_Indentation('OKC_CAT_PVT');

2831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2832: BEGIN
2833:
2834: IF (l_debug = 'Y') THEN
2835: okc_debug.Set_Indentation('OKC_CAT_PVT');
2836: okc_debug.log('9900: Entered populate_new_record', 2);
2837: END IF;
2838:
2839: x_cat_rec := p_cat_rec;

Line 2995: okc_debug.Set_Indentation('OKC_CAT_PVT');

2991: END Set_Attributes;
2992: BEGIN
2993:
2994: IF (l_debug = 'Y') THEN
2995: okc_debug.Set_Indentation('OKC_CAT_PVT');
2996: okc_debug.log('10100: Entered update_row', 2);
2997: END IF;
2998:
2999: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3146: okc_debug.Set_Indentation('OKC_CAT_PVT');

3142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3143: BEGIN
3144:
3145: IF (l_debug = 'Y') THEN
3146: okc_debug.Set_Indentation('OKC_CAT_PVT');
3147: okc_debug.log('10500: Entered populate_new_record', 2);
3148: END IF;
3149:
3150: x_okc_k_articles_tl_rec := p_okc_k_articles_tl_rec;

Line 3248: okc_debug.Set_Indentation('OKC_CAT_PVT');

3244: END Set_Attributes;
3245: BEGIN
3246:
3247: IF (l_debug = 'Y') THEN
3248: okc_debug.Set_Indentation('OKC_CAT_PVT');
3249: okc_debug.log('10700: Entered update_row', 2);
3250: END IF;
3251:
3252: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3411: okc_debug.Set_Indentation('OKC_CAT_PVT');

3407: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3408: BEGIN
3409:
3410: IF (l_debug = 'Y') THEN
3411: okc_debug.Set_Indentation('OKC_CAT_PVT');
3412: okc_debug.log('11300: Entered populate_new_record', 2);
3413: END IF;
3414:
3415: x_catv_rec := p_catv_rec;

Line 3600: okc_debug.Set_Indentation('OKC_CAT_PVT');

3596: END Set_Attributes;
3597: BEGIN
3598:
3599: IF (l_debug = 'Y') THEN
3600: okc_debug.Set_Indentation('OKC_CAT_PVT');
3601: okc_debug.log('11500: Entered update_row', 2);
3602: END IF;
3603:
3604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3762: okc_debug.Set_Indentation('OKC_CAT_PVT');

3758: i NUMBER := 0;
3759: BEGIN
3760:
3761: IF (l_debug = 'Y') THEN
3762: okc_debug.Set_Indentation('OKC_CAT_PVT');
3763: okc_debug.log('12000: Entered update_row', 2);
3764: END IF;
3765:
3766: OKC_API.init_msg_list(p_init_msg_list);

Line 3862: okc_debug.Set_Indentation('OKC_CAT_PVT');

3858: l_row_notfound BOOLEAN := TRUE;
3859: BEGIN
3860:
3861: IF (l_debug = 'Y') THEN
3862: okc_debug.Set_Indentation('OKC_CAT_PVT');
3863: okc_debug.log('12500: Entered delete_row', 2);
3864: END IF;
3865:
3866: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3969: okc_debug.Set_Indentation('OKC_CAT_PVT');

3965: END Set_Attributes;
3966: BEGIN
3967:
3968: IF (l_debug = 'Y') THEN
3969: okc_debug.Set_Indentation('OKC_CAT_PVT');
3970: okc_debug.log('13100: Entered delete_row', 2);
3971: END IF;
3972:
3973: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4073: okc_debug.Set_Indentation('OKC_CAT_PVT');

4069: l_cat_rec cat_rec_type;
4070: BEGIN
4071:
4072: IF (l_debug = 'Y') THEN
4073: okc_debug.Set_Indentation('OKC_CAT_PVT');
4074: okc_debug.log('13600: Entered delete_row', 2);
4075: END IF;
4076:
4077: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4197: okc_debug.Set_Indentation('OKC_CAT_PVT');

4193: i NUMBER := 0;
4194: BEGIN
4195:
4196: IF (l_debug = 'Y') THEN
4197: okc_debug.Set_Indentation('OKC_CAT_PVT');
4198: okc_debug.log('14100: Entered delete_row', 2);
4199: END IF;
4200:
4201: OKC_API.init_msg_list(p_init_msg_list);

Line 4325: okc_debug.Set_Indentation('OKC_CAT_PVT');

4321: BEGIN
4322: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4323: -- Initializing Return status
4324: IF (l_debug = 'Y') THEN
4325: okc_debug.Set_Indentation('OKC_CAT_PVT');
4326: okc_debug.log('14600: Entered INSERT_ROW_UPG', 2);
4327: END IF;
4328:
4329: i := p_catv_tbl.FIRST; j:=0;

Line 4526: okc_debug.Set_Indentation('OKC_CAT_PVT');

4522:
4523: BEGIN
4524:
4525: IF (l_debug = 'Y') THEN
4526: okc_debug.Set_Indentation('OKC_CAT_PVT');
4527: okc_debug.log('14900: Entered create_version', 2);
4528: END IF;
4529:
4530: INSERT INTO okc_k_articles_bh

Line 4689: okc_debug.Set_Indentation('OKC_CAT_PVT');

4685:
4686: BEGIN
4687:
4688: IF (l_debug = 'Y') THEN
4689: okc_debug.Set_Indentation('OKC_CAT_PVT');
4690: okc_debug.log('15200: Entered restore_version', 2);
4691: END IF;
4692:
4693: INSERT INTO okc_k_articles_tl

Line 4837: END OKC_CAT_PVT;

4833: return l_return_status;
4834:
4835: END restore_version;
4836:
4837: END OKC_CAT_PVT;