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_SAE_PVT dependencies on OKC_SAE_PVT

Line 1: PACKAGE BODY OKC_SAE_PVT AS

1: PACKAGE BODY OKC_SAE_PVT AS
2: /* $Header: OKCSSAEB.pls 120.2 2006/02/28 17:04:55 smallya noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 52: okc_debug.Set_Indentation('OKC_SAE_PVT');

48: PROCEDURE add_language IS
49: BEGIN
50:
51: IF (l_debug = 'Y') THEN
52: okc_debug.Set_Indentation('OKC_SAE_PVT');
53: okc_debug.log('500: Entered add_language', 2);
54: END IF;
55:
56: /* Mar/19/03 requested by Ric Ginsberg */

Line 167: okc_debug.Set_Indentation('OKC_SAE_PVT');

163: l_sae_rec sae_rec_type;
164: BEGIN
165:
166: IF (l_debug = 'Y') THEN
167: okc_debug.Set_Indentation('OKC_SAE_PVT');
168: okc_debug.log('600: Entered get_rec', 2);
169: END IF;
170:
171: x_no_data_found := TRUE;

Line 248: okc_debug.Set_Indentation('OKC_SAE_PVT');

244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
245: BEGIN
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.Set_Indentation('OKC_SAE_PVT');
249: okc_debug.log('800: Entered get_rec', 2);
250: END IF;
251:
252: x_no_data_found := TRUE;

Line 330: okc_debug.Set_Indentation('OKC_SAE_PVT');

326: l_saev_rec saev_rec_type;
327: BEGIN
328:
329: IF (l_debug = 'Y') THEN
330: okc_debug.Set_Indentation('OKC_SAE_PVT');
331: okc_debug.log('1000: Entered get_rec', 2);
332: END IF;
333:
334: x_no_data_found := TRUE;

Line 395: okc_debug.Set_Indentation('OKC_SAE_PVT');

391: l_saev_rec saev_rec_type := p_saev_rec;
392: BEGIN
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.Set_Indentation('OKC_SAE_PVT');
396: okc_debug.log('1200: Entered null_out_defaults', 2);
397: END IF;
398:
399: IF (l_saev_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 508: okc_debug.Set_Indentation('OKC_SAE_PVT');

504:
505: BEGIN
506:
507: IF (l_debug = 'Y') THEN
508: okc_debug.Set_Indentation('OKC_SAE_PVT');
509: okc_debug.log('1300: Entered validate_no_k_attached', 2);
510: END IF;
511:
512: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 561: okc_debug.Set_Indentation('OKC_SAE_PVT');

557:
558: BEGIN
559:
560: IF (l_debug = 'Y') THEN
561: okc_debug.Set_Indentation('OKC_SAE_PVT');
562: okc_debug.log('1600: Entered validate_id', 2);
563: END IF;
564:
565: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 626: okc_debug.Set_Indentation('OKC_SAE_PVT');

622:
623: BEGIN
624:
625: IF (l_debug = 'Y') THEN
626: okc_debug.Set_Indentation('OKC_SAE_PVT');
627: okc_debug.log('2000: Entered validate_Object_Version_Number', 2);
628: END IF;
629:
630: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 693: okc_debug.Set_Indentation('OKC_SAE_PVT');

689: x_return_status OUT NOCOPY VARCHAR2) is
690: BEGIN
691:
692: IF (l_debug = 'Y') THEN
693: okc_debug.Set_Indentation('OKC_SAE_PVT');
694: okc_debug.log('2400: Entered validate_sfwt_flag', 2);
695: END IF;
696:
697: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 785: okc_debug.Set_Indentation('OKC_SAE_PVT');

781:
782: BEGIN
783:
784: IF (l_debug = 'Y') THEN
785: okc_debug.Set_Indentation('OKC_SAE_PVT');
786: okc_debug.log('2800: Entered validate_sbt_code', 2);
787: END IF;
788:
789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 878: okc_debug.Set_Indentation('OKC_SAE_PVT');

874: l_id number:=OKC_API.G_MISS_NUM;
875: BEGIN
876:
877: IF (l_debug = 'Y') THEN
878: okc_debug.Set_Indentation('OKC_SAE_PVT');
879: okc_debug.log('3200: Entered validate_name', 2);
880: END IF;
881:
882: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 954: okc_debug.Set_Indentation('OKC_SAE_PVT');

950: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
951: BEGIN
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.Set_Indentation('OKC_SAE_PVT');
955: okc_debug.log('3600: Entered Validate_Attributes', 2);
956: END IF;
957:
958: validate_id(p_saev_rec,l_return_status);

Line 1190: okc_debug.Set_Indentation('OKC_SAE_PVT');

1186: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1187: BEGIN
1188:
1189: IF (l_debug = 'Y') THEN
1190: okc_debug.Set_Indentation('OKC_SAE_PVT');
1191: okc_debug.log('4500: Entered validate_row', 2);
1192: END IF;
1193:
1194: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1296: okc_debug.Set_Indentation('OKC_SAE_PVT');

1292: i NUMBER := 0;
1293: BEGIN
1294:
1295: IF (l_debug = 'Y') THEN
1296: okc_debug.Set_Indentation('OKC_SAE_PVT');
1297: okc_debug.log('5000: Entered validate_row', 2);
1298: END IF;
1299:
1300: -- Make sure PL/SQL table has records in it before passing

Line 1409: okc_debug.Set_Indentation('OKC_SAE_PVT');

1405: END Set_Attributes;
1406: BEGIN
1407:
1408: IF (l_debug = 'Y') THEN
1409: okc_debug.Set_Indentation('OKC_SAE_PVT');
1410: okc_debug.log('5600: Entered insert_row', 2);
1411: END IF;
1412:
1413: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1583: okc_debug.Set_Indentation('OKC_SAE_PVT');

1579: END Set_Attributes;
1580: BEGIN
1581:
1582: IF (l_debug = 'Y') THEN
1583: okc_debug.Set_Indentation('OKC_SAE_PVT');
1584: okc_debug.log('6200: Entered insert_row', 2);
1585: END IF;
1586:
1587: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1755: okc_debug.Set_Indentation('OKC_SAE_PVT');

1751: END Set_Attributes;
1752: BEGIN
1753:
1754: IF (l_debug = 'Y') THEN
1755: okc_debug.Set_Indentation('OKC_SAE_PVT');
1756: okc_debug.log('6900: Entered insert_row', 2);
1757: END IF;
1758:
1759: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1915: okc_debug.Set_Indentation('OKC_SAE_PVT');

1911: i NUMBER := 0;
1912: BEGIN
1913:
1914: IF (l_debug = 'Y') THEN
1915: okc_debug.Set_Indentation('OKC_SAE_PVT');
1916: okc_debug.log('7400: Entered insert_row', 2);
1917: END IF;
1918:
1919: -- Make sure PL/SQL table has records in it before passing

Line 2029: okc_debug.Set_Indentation('OKC_SAE_PVT');

2025: lc_row_notfound BOOLEAN := FALSE;
2026: BEGIN
2027:
2028: IF (l_debug = 'Y') THEN
2029: okc_debug.Set_Indentation('OKC_SAE_PVT');
2030: okc_debug.log('7900: Entered lock_row', 2);
2031: END IF;
2032:
2033: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2045: okc_debug.Set_Indentation('OKC_SAE_PVT');

2041: END IF;
2042: BEGIN
2043:
2044: IF (l_debug = 'Y') THEN
2045: okc_debug.Set_Indentation('OKC_SAE_PVT');
2046: okc_debug.log('8000: Entered lock_row', 2);
2047: END IF;
2048:
2049: OPEN lock_csr(p_sae_rec);

Line 2178: okc_debug.Set_Indentation('OKC_SAE_PVT');

2174: lc_row_notfound BOOLEAN := FALSE;
2175: BEGIN
2176:
2177: IF (l_debug = 'Y') THEN
2178: okc_debug.Set_Indentation('OKC_SAE_PVT');
2179: okc_debug.log('8700: Entered lock_row', 2);
2180: END IF;
2181:
2182: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2194: okc_debug.Set_Indentation('OKC_SAE_PVT');

2190: END IF;
2191: BEGIN
2192:
2193: IF (l_debug = 'Y') THEN
2194: okc_debug.Set_Indentation('OKC_SAE_PVT');
2195: okc_debug.log('8800: Entered lock_row', 2);
2196: END IF;
2197:
2198: OPEN lock_csr(p_okc_std_articles_tl_rec);

Line 2304: okc_debug.Set_Indentation('OKC_SAE_PVT');

2300: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2301: BEGIN
2302:
2303: IF (l_debug = 'Y') THEN
2304: okc_debug.Set_Indentation('OKC_SAE_PVT');
2305: okc_debug.log('9500: Entered lock_row', 2);
2306: END IF;
2307:
2308: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2428: okc_debug.Set_Indentation('OKC_SAE_PVT');

2424: i NUMBER := 0;
2425: BEGIN
2426:
2427: IF (l_debug = 'Y') THEN
2428: okc_debug.Set_Indentation('OKC_SAE_PVT');
2429: okc_debug.log('10000: Entered lock_row', 2);
2430: END IF;
2431:
2432: -- Make sure PL/SQL table has records in it before passing

Line 2538: okc_debug.Set_Indentation('OKC_SAE_PVT');

2534: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2535: BEGIN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.Set_Indentation('OKC_SAE_PVT');
2539: okc_debug.log('10500: Entered populate_new_record', 2);
2540: END IF;
2541:
2542: x_sae_rec := p_sae_rec;

Line 2670: okc_debug.Set_Indentation('OKC_SAE_PVT');

2666: END Set_Attributes;
2667: BEGIN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.Set_Indentation('OKC_SAE_PVT');
2671: okc_debug.log('10700: Entered update_row', 2);
2672: END IF;
2673:
2674: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2815: okc_debug.Set_Indentation('OKC_SAE_PVT');

2811: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2812: BEGIN
2813:
2814: IF (l_debug = 'Y') THEN
2815: okc_debug.Set_Indentation('OKC_SAE_PVT');
2816: okc_debug.log('11200: Entered populate_new_record', 2);
2817: END IF;
2818:
2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

Line 2895: okc_debug.Set_Indentation('OKC_SAE_PVT');

2891: END Set_Attributes;
2892: BEGIN
2893:
2894: IF (l_debug = 'Y') THEN
2895: okc_debug.Set_Indentation('OKC_SAE_PVT');
2896: okc_debug.log('11400: Entered update_row', 2);
2897: END IF;
2898:
2899: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3053: okc_debug.Set_Indentation('OKC_SAE_PVT');

3049: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3050: BEGIN
3051:
3052: IF (l_debug = 'Y') THEN
3053: okc_debug.Set_Indentation('OKC_SAE_PVT');
3054: okc_debug.log('12000: Entered populate_new_record', 2);
3055: END IF;
3056:
3057: x_saev_rec := p_saev_rec;

Line 3200: okc_debug.Set_Indentation('OKC_SAE_PVT');

3196: END Set_Attributes;
3197: BEGIN
3198:
3199: IF (l_debug = 'Y') THEN
3200: okc_debug.Set_Indentation('OKC_SAE_PVT');
3201: okc_debug.log('12200: Entered update_row', 2);
3202: END IF;
3203:
3204: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3363: okc_debug.Set_Indentation('OKC_SAE_PVT');

3359: i NUMBER := 0;
3360: BEGIN
3361:
3362: IF (l_debug = 'Y') THEN
3363: okc_debug.Set_Indentation('OKC_SAE_PVT');
3364: okc_debug.log('12700: Entered update_row', 2);
3365: END IF;
3366:
3367: -- Make sure PL/SQL table has records in it before passing

Line 3462: okc_debug.Set_Indentation('OKC_SAE_PVT');

3458: l_row_notfound BOOLEAN := TRUE;
3459: BEGIN
3460:
3461: IF (l_debug = 'Y') THEN
3462: okc_debug.Set_Indentation('OKC_SAE_PVT');
3463: okc_debug.log('13200: Entered delete_row', 2);
3464: END IF;
3465:
3466: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3562: okc_debug.Set_Indentation('OKC_SAE_PVT');

3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3559: BEGIN
3560:
3561: IF (l_debug = 'Y') THEN
3562: okc_debug.Set_Indentation('OKC_SAE_PVT');
3563: okc_debug.log('13700: Entered Set_Attributes', 2);
3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

Line 3575: okc_debug.Set_Indentation('OKC_SAE_PVT');

3571: END Set_Attributes;
3572: BEGIN
3573:
3574: IF (l_debug = 'Y') THEN
3575: okc_debug.Set_Indentation('OKC_SAE_PVT');
3576: okc_debug.log('13800: Entered delete_row', 2);
3577: END IF;
3578:
3579: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3679: okc_debug.Set_Indentation('OKC_SAE_PVT');

3675: l_sae_rec sae_rec_type;
3676: BEGIN
3677:
3678: IF (l_debug = 'Y') THEN
3679: okc_debug.Set_Indentation('OKC_SAE_PVT');
3680: okc_debug.log('14300: Entered delete_row', 2);
3681: END IF;
3682:
3683: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3803: okc_debug.Set_Indentation('OKC_SAE_PVT');

3799: i NUMBER := 0;
3800: BEGIN
3801:
3802: IF (l_debug = 'Y') THEN
3803: okc_debug.Set_Indentation('OKC_SAE_PVT');
3804: okc_debug.log('14800: Entered delete_row', 2);
3805: END IF;
3806:
3807: -- Make sure PL/SQL table has records in it before passing

Line 3880: END OKC_SAE_PVT;

3876: );
3877:
3878: END delete_row;
3879:
3880: END OKC_SAE_PVT;