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_CAC_PVT dependencies on OKC_CAC_PVT

Line 1: PACKAGE BODY OKC_CAC_PVT AS

1: PACKAGE BODY OKC_CAC_PVT AS
2: /* $Header: OKCSCACB.pls 120.0 2005/05/25 23:07:06 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 35: okc_debug.Set_Indentation('OKC_CAC_PVT');

31: where GROUP_ID = p_cacv_rec.group_id;
32: Begin
33:
34: IF (l_debug = 'Y') THEN
35: okc_debug.Set_Indentation('OKC_CAC_PVT');
36: okc_debug.log('100: Entered validate_group_id', 2);
37: END IF;
38:
39: -- initialize return status

Line 111: okc_debug.Set_Indentation('OKC_CAC_PVT');

107: where ID = p_cacv_rec.chr_id;
108: Begin
109:
110: IF (l_debug = 'Y') THEN
111: okc_debug.Set_Indentation('OKC_CAC_PVT');
112: okc_debug.log('400: Entered validate_chr_id', 2);
113: END IF;
114:
115: -- initialize return status

Line 204: okc_debug.Set_Indentation('OKC_CAC_PVT');

200: where RESOURCE_ID = p_cacv_rec.resource_id;
201: Begin
202:
203: IF (l_debug = 'Y') THEN
204: okc_debug.Set_Indentation('OKC_CAC_PVT');
205: okc_debug.log('800: Entered validate_resource_id', 2);
206: END IF;
207:
208: -- initialize return status

Line 276: okc_debug.Set_Indentation('OKC_CAC_PVT');

272: p_cacv_rec IN cacv_rec_type) is
273: Begin
274:
275: IF (l_debug = 'Y') THEN
276: okc_debug.Set_Indentation('OKC_CAC_PVT');
277: okc_debug.log('1000: Entered validate_access_level', 2);
278: END IF;
279:
280: -- initialize return status

Line 411: okc_debug.Set_Indentation('OKC_CAC_PVT');

407: l_cac_rec cac_rec_type;
408: BEGIN
409:
410: IF (l_debug = 'Y') THEN
411: okc_debug.Set_Indentation('OKC_CAC_PVT');
412: okc_debug.log('1500: Entered get_rec', 2);
413: END IF;
414:
415: x_no_data_found := TRUE;

Line 478: okc_debug.Set_Indentation('OKC_CAC_PVT');

474: l_cacv_rec cacv_rec_type;
475: BEGIN
476:
477: IF (l_debug = 'Y') THEN
478: okc_debug.Set_Indentation('OKC_CAC_PVT');
479: okc_debug.log('1700: Entered get_rec', 2);
480: END IF;
481:
482: x_no_data_found := TRUE;

Line 529: okc_debug.Set_Indentation('OKC_CAC_PVT');

525: l_cacv_rec cacv_rec_type := p_cacv_rec;
526: BEGIN
527:
528: IF (l_debug = 'Y') THEN
529: okc_debug.Set_Indentation('OKC_CAC_PVT');
530: okc_debug.log('1900: Entered null_out_defaults', 2);
531: END IF;
532:
533: IF (l_cacv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 586: okc_debug.Set_Indentation('OKC_CAC_PVT');

582: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
583: BEGIN
584:
585: IF (l_debug = 'Y') THEN
586: okc_debug.Set_Indentation('OKC_CAC_PVT');
587: okc_debug.log('2100: Entered Validate_Attributes', 2);
588: END IF;
589:
590: /************************ HAND-CODED *********************************/

Line 726: okc_debug.Set_Indentation('OKC_CAC_PVT');

722:
723: BEGIN
724:
725: IF (l_debug = 'Y') THEN
726: okc_debug.Set_Indentation('OKC_CAC_PVT');
727: okc_debug.log('2400: Entered Validate_Record', 2);
728: END IF;
729:
730: /************************ HAND-CODED ****************************/

Line 882: okc_debug.Set_Indentation('OKC_CAC_PVT');

878: l_cac_rec cac_rec_type;
879: BEGIN
880:
881: IF (l_debug = 'Y') THEN
882: okc_debug.Set_Indentation('OKC_CAC_PVT');
883: okc_debug.log('2700: Entered validate_row', 2);
884: END IF;
885:
886: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 989: okc_debug.Set_Indentation('OKC_CAC_PVT');

985: i NUMBER := 0;
986: BEGIN
987:
988: IF (l_debug = 'Y') THEN
989: okc_debug.Set_Indentation('OKC_CAC_PVT');
990: okc_debug.log('3200: Entered validate_row', 2);
991: END IF;
992:
993: OKC_API.init_msg_list(p_init_msg_list);

Line 1113: okc_debug.Set_Indentation('OKC_CAC_PVT');

1109: END Set_Attributes;
1110: BEGIN
1111:
1112: IF (l_debug = 'Y') THEN
1113: okc_debug.Set_Indentation('OKC_CAC_PVT');
1114: okc_debug.log('3800: Entered insert_row', 2);
1115: END IF;
1116:
1117: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1249: okc_debug.Set_Indentation('OKC_CAC_PVT');

1245: l_cacv_rec cacv_rec_type := p_cacv_rec;
1246: BEGIN
1247:
1248: IF (l_debug = 'Y') THEN
1249: okc_debug.Set_Indentation('OKC_CAC_PVT');
1250: okc_debug.log('4400: Entered fill_who_columns', 2);
1251: END IF;
1252:
1253: l_cacv_rec.CREATION_DATE := SYSDATE;

Line 1278: okc_debug.Set_Indentation('OKC_CAC_PVT');

1274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1275: BEGIN
1276:
1277: IF (l_debug = 'Y') THEN
1278: okc_debug.Set_Indentation('OKC_CAC_PVT');
1279: okc_debug.log('4600: Entered Set_Attributes', 2);
1280: END IF;
1281:
1282: x_cacv_rec := p_cacv_rec;

Line 1299: okc_debug.Set_Indentation('OKC_CAC_PVT');

1295:
1296: BEGIN
1297:
1298: IF (l_debug = 'Y') THEN
1299: okc_debug.Set_Indentation('OKC_CAC_PVT');
1300: okc_debug.log('4800: Entered insert_row', 2);
1301: END IF;
1302:
1303: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1444: okc_debug.Set_Indentation('OKC_CAC_PVT');

1440: i NUMBER := 0;
1441: BEGIN
1442:
1443: IF (l_debug = 'Y') THEN
1444: okc_debug.Set_Indentation('OKC_CAC_PVT');
1445: okc_debug.log('5300: Entered insert_row', 2);
1446: END IF;
1447:
1448: OKC_API.init_msg_list(p_init_msg_list);

Line 1569: okc_debug.Set_Indentation('OKC_CAC_PVT');

1565: lc_row_notfound BOOLEAN := FALSE;
1566: BEGIN
1567:
1568: IF (l_debug = 'Y') THEN
1569: okc_debug.Set_Indentation('OKC_CAC_PVT');
1570: okc_debug.log('5800: Entered lock_row', 2);
1571: END IF;
1572:
1573: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1585: okc_debug.Set_Indentation('OKC_CAC_PVT');

1581: END IF;
1582: BEGIN
1583:
1584: IF (l_debug = 'Y') THEN
1585: okc_debug.Set_Indentation('OKC_CAC_PVT');
1586: okc_debug.log('5810: Entered lock_row', 2);
1587: END IF;
1588:
1589: OPEN lock_csr(p_cac_rec);

Line 1709: okc_debug.Set_Indentation('OKC_CAC_PVT');

1705: l_cac_rec cac_rec_type;
1706: BEGIN
1707:
1708: IF (l_debug = 'Y') THEN
1709: okc_debug.Set_Indentation('OKC_CAC_PVT');
1710: okc_debug.log('6500: Entered lock_row', 2);
1711: END IF;
1712:
1713: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1821: okc_debug.Set_Indentation('OKC_CAC_PVT');

1817: i NUMBER := 0;
1818: BEGIN
1819:
1820: IF (l_debug = 'Y') THEN
1821: okc_debug.Set_Indentation('OKC_CAC_PVT');
1822: okc_debug.log('7000: Entered lock_row', 2);
1823: END IF;
1824:
1825: OKC_API.init_msg_list(p_init_msg_list);

Line 1942: okc_debug.Set_Indentation('OKC_CAC_PVT');

1938: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1939: BEGIN
1940:
1941: IF (l_debug = 'Y') THEN
1942: okc_debug.Set_Indentation('OKC_CAC_PVT');
1943: okc_debug.log('7500: Entered populate_new_record', 2);
1944: END IF;
1945:
1946: x_cac_rec := p_cac_rec;

Line 2021: okc_debug.Set_Indentation('OKC_CAC_PVT');

2017: END Set_Attributes;
2018: BEGIN
2019:
2020: IF (l_debug = 'Y') THEN
2021: okc_debug.Set_Indentation('OKC_CAC_PVT');
2022: okc_debug.log('7700: Entered update_row', 2);
2023: END IF;
2024:
2025: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2169: okc_debug.Set_Indentation('OKC_CAC_PVT');

2165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2166: BEGIN
2167:
2168: IF (l_debug = 'Y') THEN
2169: okc_debug.Set_Indentation('OKC_CAC_PVT');
2170: okc_debug.log('8200: Entered populate_new_record', 2);
2171: END IF;
2172:
2173: x_cacv_rec := p_cacv_rec;

Line 2253: okc_debug.Set_Indentation('OKC_CAC_PVT');

2249: END Set_Attributes;
2250: BEGIN
2251:
2252: IF (l_debug = 'Y') THEN
2253: okc_debug.Set_Indentation('OKC_CAC_PVT');
2254: okc_debug.log('8400: Entered update_row', 2);
2255: END IF;
2256:
2257: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2401: okc_debug.Set_Indentation('OKC_CAC_PVT');

2397: i NUMBER := 0;
2398: BEGIN
2399:
2400: IF (l_debug = 'Y') THEN
2401: okc_debug.Set_Indentation('OKC_CAC_PVT');
2402: okc_debug.log('8900: Entered update_row', 2);
2403: END IF;
2404:
2405: OKC_API.init_msg_list(p_init_msg_list);

Line 2511: okc_debug.Set_Indentation('OKC_CAC_PVT');

2507: l_row_notfound BOOLEAN := TRUE;
2508: BEGIN
2509:
2510: IF (l_debug = 'Y') THEN
2511: okc_debug.Set_Indentation('OKC_CAC_PVT');
2512: okc_debug.log('9400: Entered delete_row', 2);
2513: END IF;
2514:
2515: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2604: okc_debug.Set_Indentation('OKC_CAC_PVT');

2600: l_cac_rec cac_rec_type;
2601: BEGIN
2602:
2603: IF (l_debug = 'Y') THEN
2604: okc_debug.Set_Indentation('OKC_CAC_PVT');
2605: okc_debug.log('9900: Entered delete_row', 2);
2606: END IF;
2607:
2608: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2716: okc_debug.Set_Indentation('OKC_CAC_PVT');

2712: i NUMBER := 0;
2713: BEGIN
2714:
2715: IF (l_debug = 'Y') THEN
2716: okc_debug.Set_Indentation('OKC_CAC_PVT');
2717: okc_debug.log('10400: Entered delete_row', 2);
2718: END IF;
2719:
2720: OKC_API.init_msg_list(p_init_msg_list);

Line 2818: okc_debug.Set_Indentation('OKC_CAC_PVT');

2814:
2815: BEGIN
2816:
2817: IF (l_debug = 'Y') THEN
2818: okc_debug.Set_Indentation('OKC_CAC_PVT');
2819: okc_debug.log('10900: Entered create_version', 2);
2820: END IF;
2821:
2822: INSERT INTO okc_k_accesses_h

Line 2897: okc_debug.Set_Indentation('OKC_CAC_PVT');

2893:
2894: BEGIN
2895:
2896: IF (l_debug = 'Y') THEN
2897: okc_debug.Set_Indentation('OKC_CAC_PVT');
2898: okc_debug.log('11300: Entered restore_version', 2);
2899: END IF;
2900:
2901: INSERT INTO okc_k_accesses

Line 2962: END OKC_CAC_PVT;

2958:
2959: END restore_version;
2960: --
2961:
2962: END OKC_CAC_PVT;