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_SCC_PVT dependencies on OKC_SCC_PVT

Line 1: PACKAGE BODY OKC_SCC_PVT AS

1: PACKAGE BODY OKC_SCC_PVT AS
2: /* $Header: OKCSSCCB.pls 120.0 2005/05/25 19:27:42 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 30: okc_debug.Set_Indentation('OKC_SCC_PVT');

26:
27: Begin
28:
29: IF (l_debug = 'Y') THEN
30: okc_debug.Set_Indentation('OKC_SCC_PVT');
31: okc_debug.log('100: Entered validate_scn_id', 2);
32: END IF;
33:
34: -- initialize return status

Line 122: okc_debug.Set_Indentation('OKC_SCC_PVT');

118:
119: Begin
120:
121: IF (l_debug = 'Y') THEN
122: okc_debug.Set_Indentation('OKC_SCC_PVT');
123: okc_debug.log('400: Entered validate_cat_id', 2);
124: END IF;
125:
126: -- initialize return status

Line 201: okc_debug.Set_Indentation('OKC_SCC_PVT');

197:
198: Begin
199:
200: IF (l_debug = 'Y') THEN
201: okc_debug.Set_Indentation('OKC_SCC_PVT');
202: okc_debug.log('700: Entered validate_cle_id', 2);
203: END IF;
204:
205: -- initialize return status

Line 280: okc_debug.Set_Indentation('OKC_SCC_PVT');

276:
277: Begin
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.Set_Indentation('OKC_SCC_PVT');
281: okc_debug.log('1000: Entered validate_sae_id', 2);
282: END IF;
283:
284: -- initialize return status

Line 371: okc_debug.Set_Indentation('OKC_SCC_PVT');

367:
368: BEGIN
369:
370: IF (l_debug = 'Y') THEN
371: okc_debug.Set_Indentation('OKC_SCC_PVT');
372: okc_debug.log('1300: Entered validate_content_sequence', 2);
373: END IF;
374:
375: -- initialize return status

Line 501: okc_debug.Set_Indentation('OKC_SCC_PVT');

497: l_scc_rec scc_rec_type;
498: BEGIN
499:
500: IF (l_debug = 'Y') THEN
501: okc_debug.Set_Indentation('OKC_SCC_PVT');
502: okc_debug.log('1700: Entered get_rec', 2);
503: END IF;
504:
505: x_no_data_found := TRUE;

Line 610: okc_debug.Set_Indentation('OKC_SCC_PVT');

606: l_sccv_rec sccv_rec_type;
607: BEGIN
608:
609: IF (l_debug = 'Y') THEN
610: okc_debug.Set_Indentation('OKC_SCC_PVT');
611: okc_debug.log('1900: Entered get_rec', 2);
612: END IF;
613:
614: x_no_data_found := TRUE;

Line 685: okc_debug.Set_Indentation('OKC_SCC_PVT');

681: l_sccv_rec sccv_rec_type := p_sccv_rec;
682: BEGIN
683:
684: IF (l_debug = 'Y') THEN
685: okc_debug.Set_Indentation('OKC_SCC_PVT');
686: okc_debug.log('2100: Entered null_out_defaults', 2);
687: END IF;
688:
689: IF (l_sccv_rec.id = OKC_API.G_MISS_NUM) THEN

Line 799: okc_debug.Set_Indentation('OKC_SCC_PVT');

795: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
796: BEGIN
797:
798: IF (l_debug = 'Y') THEN
799: okc_debug.Set_Indentation('OKC_SCC_PVT');
800: okc_debug.log('2200: Entered Validate_Attributes', 2);
801: END IF;
802:
803: /************************ HAND-CODED *********************************/

Line 917: okc_debug.Set_Indentation('OKC_SCC_PVT');

913: AND id <> p_sccv_rec.id;
914: BEGIN
915:
916: IF (l_debug = 'Y') THEN
917: okc_debug.Set_Indentation('OKC_SCC_PVT');
918: okc_debug.log('2500: Entered Validate_Record', 2);
919: END IF;
920:
921: Open l_sccv_csr;

Line 1044: okc_debug.Set_Indentation('OKC_SCC_PVT');

1040: l_scc_rec scc_rec_type;
1041: BEGIN
1042:
1043: IF (l_debug = 'Y') THEN
1044: okc_debug.Set_Indentation('OKC_SCC_PVT');
1045: okc_debug.log('2800: Entered validate_row', 2);
1046: END IF;
1047:
1048: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1150: okc_debug.Set_Indentation('OKC_SCC_PVT');

1146: i NUMBER := 0;
1147: BEGIN
1148:
1149: IF (l_debug = 'Y') THEN
1150: okc_debug.Set_Indentation('OKC_SCC_PVT');
1151: okc_debug.log('3300: Entered validate_row', 2);
1152: END IF;
1153:
1154: OKC_API.init_msg_list(p_init_msg_list);

Line 1264: okc_debug.Set_Indentation('OKC_SCC_PVT');

1260: END Set_Attributes;
1261: BEGIN
1262:
1263: IF (l_debug = 'Y') THEN
1264: okc_debug.Set_Indentation('OKC_SCC_PVT');
1265: okc_debug.log('3900: Entered insert_row', 2);
1266: END IF;
1267:
1268: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1461: okc_debug.Set_Indentation('OKC_SCC_PVT');

1457: END Set_Attributes;
1458: BEGIN
1459:
1460: IF (l_debug = 'Y') THEN
1461: okc_debug.Set_Indentation('OKC_SCC_PVT');
1462: okc_debug.log('4600: Entered insert_row', 2);
1463: END IF;
1464:
1465: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1605: okc_debug.Set_Indentation('OKC_SCC_PVT');

1601: i NUMBER := 0;
1602: BEGIN
1603:
1604: IF (l_debug = 'Y') THEN
1605: okc_debug.Set_Indentation('OKC_SCC_PVT');
1606: okc_debug.log('5100: Entered insert_row', 2);
1607: END IF;
1608:
1609: OKC_API.init_msg_list(p_init_msg_list);

Line 1720: okc_debug.Set_Indentation('OKC_SCC_PVT');

1716: lc_row_notfound BOOLEAN := FALSE;
1717: BEGIN
1718:
1719: IF (l_debug = 'Y') THEN
1720: okc_debug.Set_Indentation('OKC_SCC_PVT');
1721: okc_debug.log('5600: Entered lock_row', 2);
1722: END IF;
1723:
1724: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1738: okc_debug.Set_Indentation('OKC_SCC_PVT');

1734: -->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1735: BEGIN
1736:
1737: IF (l_debug = 'Y') THEN
1738: okc_debug.Set_Indentation('OKC_SCC_PVT');
1739: okc_debug.log('5700: Entered lock_row', 2);
1740: END IF;
1741:
1742: OPEN lock_csr(p_scc_rec);

Line 1864: okc_debug.Set_Indentation('OKC_SCC_PVT');

1860: l_scc_rec scc_rec_type;
1861: BEGIN
1862:
1863: IF (l_debug = 'Y') THEN
1864: okc_debug.Set_Indentation('OKC_SCC_PVT');
1865: okc_debug.log('6400: Entered lock_row', 2);
1866: END IF;
1867:
1868: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1975: okc_debug.Set_Indentation('OKC_SCC_PVT');

1971: i NUMBER := 0;
1972: BEGIN
1973:
1974: IF (l_debug = 'Y') THEN
1975: okc_debug.Set_Indentation('OKC_SCC_PVT');
1976: okc_debug.log('6900: Entered lock_row', 2);
1977: END IF;
1978:
1979: OKC_API.init_msg_list(p_init_msg_list);

Line 2086: okc_debug.Set_Indentation('OKC_SCC_PVT');

2082: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2083: BEGIN
2084:
2085: IF (l_debug = 'Y') THEN
2086: okc_debug.Set_Indentation('OKC_SCC_PVT');
2087: okc_debug.log('7400: Entered populate_new_record', 2);
2088: END IF;
2089:
2090: x_scc_rec := p_scc_rec;

Line 2238: okc_debug.Set_Indentation('OKC_SCC_PVT');

2234: END Set_Attributes;
2235: BEGIN
2236:
2237: IF (l_debug = 'Y') THEN
2238: okc_debug.Set_Indentation('OKC_SCC_PVT');
2239: okc_debug.log('7600: Entered update_row', 2);
2240: END IF;
2241:
2242: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2404: okc_debug.Set_Indentation('OKC_SCC_PVT');

2400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2401: BEGIN
2402:
2403: IF (l_debug = 'Y') THEN
2404: okc_debug.Set_Indentation('OKC_SCC_PVT');
2405: okc_debug.log('8200: Entered populate_new_record', 2);
2406: END IF;
2407:
2408: x_sccv_rec := p_sccv_rec;

Line 2557: okc_debug.Set_Indentation('OKC_SCC_PVT');

2553: END Set_Attributes;
2554: BEGIN
2555:
2556: IF (l_debug = 'Y') THEN
2557: okc_debug.Set_Indentation('OKC_SCC_PVT');
2558: okc_debug.log('8400: Entered update_row', 2);
2559: END IF;
2560:
2561: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2705: okc_debug.Set_Indentation('OKC_SCC_PVT');

2701: i NUMBER := 0;
2702: BEGIN
2703:
2704: IF (l_debug = 'Y') THEN
2705: okc_debug.Set_Indentation('OKC_SCC_PVT');
2706: okc_debug.log('8900: Entered update_row', 2);
2707: END IF;
2708:
2709: OKC_API.init_msg_list(p_init_msg_list);

Line 2805: okc_debug.Set_Indentation('OKC_SCC_PVT');

2801: l_row_notfound BOOLEAN := TRUE;
2802: BEGIN
2803:
2804: IF (l_debug = 'Y') THEN
2805: okc_debug.Set_Indentation('OKC_SCC_PVT');
2806: okc_debug.log('9400: Entered delete_row', 2);
2807: END IF;
2808:
2809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2898: okc_debug.Set_Indentation('OKC_SCC_PVT');

2894: l_scc_rec scc_rec_type;
2895: BEGIN
2896:
2897: IF (l_debug = 'Y') THEN
2898: okc_debug.Set_Indentation('OKC_SCC_PVT');
2899: okc_debug.log('9900: Entered delete_row', 2);
2900: END IF;
2901:
2902: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3009: okc_debug.Set_Indentation('OKC_SCC_PVT');

3005: i NUMBER := 0;
3006: BEGIN
3007:
3008: IF (l_debug = 'Y') THEN
3009: okc_debug.Set_Indentation('OKC_SCC_PVT');
3010: okc_debug.log('10400: Entered delete_row', 2);
3011: END IF;
3012:
3013: OKC_API.init_msg_list(p_init_msg_list);

Line 3101: okc_debug.Set_Indentation('OKC_SCC_PVT');

3097:
3098: BEGIN
3099:
3100: IF (l_debug = 'Y') THEN
3101: okc_debug.Set_Indentation('OKC_SCC_PVT');
3102: okc_debug.log('10900: Entered create_version', 2);
3103: END IF;
3104:
3105: INSERT INTO okc_section_contents_h

Line 3227: okc_debug.Set_Indentation('OKC_SCC_PVT');

3223:
3224: BEGIN
3225:
3226: IF (l_debug = 'Y') THEN
3227: okc_debug.Set_Indentation('OKC_SCC_PVT');
3228: okc_debug.log('11200: Entered restore_version', 2);
3229: END IF;
3230:
3231: INSERT INTO okc_section_contents

Line 3332: END OKC_SCC_PVT;

3328: okc_debug.Reset_Indentation;
3329: END IF;
3330: END restore_version;
3331:
3332: END OKC_SCC_PVT;