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_PAA_PVT dependencies on OKC_PAA_PVT

Line 1: PACKAGE BODY OKC_PAA_PVT AS

1: PACKAGE BODY OKC_PAA_PVT AS
2: /* $Header: OKCSPAAB.pls 120.0 2005/05/27 05:17:12 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 79: okc_debug.Set_Indentation('OKC_PAA_PVT');

75: l_paa_rec paa_rec_type;
76: BEGIN
77:
78: IF (l_debug = 'Y') THEN
79: okc_debug.Set_Indentation('OKC_PAA_PVT');
80: okc_debug.log('500: Entered get_rec', 2);
81: END IF;
82:
83: x_no_data_found := TRUE;

Line 160: okc_debug.Set_Indentation('OKC_PAA_PVT');

156: l_paav_rec paav_rec_type;
157: BEGIN
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.Set_Indentation('OKC_PAA_PVT');
161: okc_debug.log('700: Entered get_rec', 2);
162: END IF;
163:
164: x_no_data_found := TRUE;

Line 218: okc_debug.Set_Indentation('OKC_PAA_PVT');

214: l_paav_rec paav_rec_type := p_paav_rec;
215: BEGIN
216:
217: IF (l_debug = 'Y') THEN
218: okc_debug.Set_Indentation('OKC_PAA_PVT');
219: okc_debug.log('900: Entered null_out_defaults', 2);
220: END IF;
221:
222: IF (l_paav_rec.pat_id = OKC_API.G_MISS_NUM) THEN

Line 298: okc_debug.Set_Indentation('OKC_PAA_PVT');

294: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
295: BEGIN
296:
297: IF (l_debug = 'Y') THEN
298: okc_debug.Set_Indentation('OKC_PAA_PVT');
299: okc_debug.log('1000: Entered validate_id', 2);
300: END IF;
301:
302: IF p_paav_rec.id = OKC_API.G_MISS_NUM OR

Line 339: okc_debug.Set_Indentation('OKC_PAA_PVT');

335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337:
338: IF (l_debug = 'Y') THEN
339: okc_debug.Set_Indentation('OKC_PAA_PVT');
340: okc_debug.log('1300: Entered validate_pat_id', 2);
341: END IF;
342:
343: IF p_paav_rec.pat_id = OKC_API.G_MISS_NUM OR

Line 380: okc_debug.Set_Indentation('OKC_PAA_PVT');

376: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
377: BEGIN
378:
379: IF (l_debug = 'Y') THEN
380: okc_debug.Set_Indentation('OKC_PAA_PVT');
381: okc_debug.log('1600: Entered validate_flex_title', 2);
382: END IF;
383:
384: IF p_paav_rec.flex_title = OKC_API.G_MISS_CHAR OR

Line 433: okc_debug.Set_Indentation('OKC_PAA_PVT');

429: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
430: BEGIN
431:
432: IF (l_debug = 'Y') THEN
433: okc_debug.Set_Indentation('OKC_PAA_PVT');
434: okc_debug.log('2000: Entered validate_pricing_context', 2);
435: END IF;
436:
437: IF p_paav_rec.pricing_context = OKC_API.G_MISS_CHAR OR

Line 487: okc_debug.Set_Indentation('OKC_PAA_PVT');

483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
484: BEGIN
485:
486: IF (l_debug = 'Y') THEN
487: okc_debug.Set_Indentation('OKC_PAA_PVT');
488: okc_debug.log('2400: Entered validate_pricing_attribute', 2);
489: END IF;
490:
491: IF p_paav_rec.pricing_attribute = OKC_API.G_MISS_CHAR OR

Line 544: okc_debug.Set_Indentation('OKC_PAA_PVT');

540: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
541: BEGIN
542:
543: IF (l_debug = 'Y') THEN
544: okc_debug.Set_Indentation('OKC_PAA_PVT');
545: okc_debug.log('2800: Entered Validate_Attributes', 2);
546: END IF;
547:
548: ---------------------------------------------------------------------------------------

Line 664: okc_debug.Set_Indentation('OKC_PAA_PVT');

660: l_row_notfound BOOLEAN := TRUE;
661: BEGIN
662:
663: IF (l_debug = 'Y') THEN
664: okc_debug.Set_Indentation('OKC_PAA_PVT');
665: okc_debug.log('3200: Entered validate_foreign_keys', 2);
666: END IF;
667:
668: IF (p_paav_rec.PAT_ID IS NOT NULL)

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

781: l_paa_rec paa_rec_type;
782: BEGIN
783:
784: IF (l_debug = 'Y') THEN
785: okc_debug.Set_Indentation('OKC_PAA_PVT');
786: okc_debug.log('3800: Entered validate_row', 2);
787: END IF;
788:
789: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 891: okc_debug.Set_Indentation('OKC_PAA_PVT');

887: i NUMBER := 0;
888: BEGIN
889:
890: IF (l_debug = 'Y') THEN
891: okc_debug.Set_Indentation('OKC_PAA_PVT');
892: okc_debug.log('4300: Entered validate_row', 2);
893: END IF;
894:
895: OKC_API.init_msg_list(p_init_msg_list);

Line 1005: okc_debug.Set_Indentation('OKC_PAA_PVT');

1001: END Set_Attributes;
1002: BEGIN
1003:
1004: IF (l_debug = 'Y') THEN
1005: okc_debug.Set_Indentation('OKC_PAA_PVT');
1006: okc_debug.log('4900: Entered insert_row', 2);
1007: END IF;
1008:
1009: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1181: okc_debug.Set_Indentation('OKC_PAA_PVT');

1177: END Set_Attributes;
1178: BEGIN
1179:
1180: IF (l_debug = 'Y') THEN
1181: okc_debug.Set_Indentation('OKC_PAA_PVT');
1182: okc_debug.log('5600: Entered insert_row', 2);
1183: END IF;
1184:
1185: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1325: okc_debug.Set_Indentation('OKC_PAA_PVT');

1321: i NUMBER := 0;
1322: BEGIN
1323:
1324: IF (l_debug = 'Y') THEN
1325: okc_debug.Set_Indentation('OKC_PAA_PVT');
1326: okc_debug.log('6100: Entered insert_row', 2);
1327: END IF;
1328:
1329: OKC_API.init_msg_list(p_init_msg_list);

Line 1434: okc_debug.Set_Indentation('OKC_PAA_PVT');

1430: lc_row_notfound BOOLEAN := FALSE;
1431: BEGIN
1432:
1433: IF (l_debug = 'Y') THEN
1434: okc_debug.Set_Indentation('OKC_PAA_PVT');
1435: okc_debug.log('6600: Entered lock_row', 2);
1436: END IF;
1437:
1438: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1450: okc_debug.Set_Indentation('OKC_PAA_PVT');

1446: END IF;
1447: BEGIN
1448:
1449: IF (l_debug = 'Y') THEN
1450: okc_debug.Set_Indentation('OKC_PAA_PVT');
1451: okc_debug.log('6700: Entered lock_row', 2);
1452: END IF;
1453:
1454: OPEN lock_csr(p_paa_rec);

Line 1632: okc_debug.Set_Indentation('OKC_PAA_PVT');

1628: l_paa_rec paa_rec_type;
1629: BEGIN
1630:
1631: IF (l_debug = 'Y') THEN
1632: okc_debug.Set_Indentation('OKC_PAA_PVT');
1633: okc_debug.log('7400: Entered lock_row', 2);
1634: END IF;
1635:
1636: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1743: okc_debug.Set_Indentation('OKC_PAA_PVT');

1739: i NUMBER := 0;
1740: BEGIN
1741:
1742: IF (l_debug = 'Y') THEN
1743: okc_debug.Set_Indentation('OKC_PAA_PVT');
1744: okc_debug.log('7900: Entered lock_row', 2);
1745: END IF;
1746:
1747: OKC_API.init_msg_list(p_init_msg_list);

Line 1854: okc_debug.Set_Indentation('OKC_PAA_PVT');

1850: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1851: BEGIN
1852:
1853: IF (l_debug = 'Y') THEN
1854: okc_debug.Set_Indentation('OKC_PAA_PVT');
1855: okc_debug.log('8400: Entered populate_new_record', 2);
1856: END IF;
1857:
1858: x_paa_rec := p_paa_rec;

Line 1962: okc_debug.Set_Indentation('OKC_PAA_PVT');

1958: END Set_Attributes;
1959: BEGIN
1960:
1961: IF (l_debug = 'Y') THEN
1962: okc_debug.Set_Indentation('OKC_PAA_PVT');
1963: okc_debug.log('8600: Entered update_row', 2);
1964: END IF;
1965:
1966: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2117: okc_debug.Set_Indentation('OKC_PAA_PVT');

2113: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2114: BEGIN
2115:
2116: IF (l_debug = 'Y') THEN
2117: okc_debug.Set_Indentation('OKC_PAA_PVT');
2118: okc_debug.log('9200: Entered populate_new_record', 2);
2119: END IF;
2120:
2121: x_paav_rec := p_paav_rec;

Line 2226: okc_debug.Set_Indentation('OKC_PAA_PVT');

2222: END Set_Attributes;
2223: BEGIN
2224:
2225: IF (l_debug = 'Y') THEN
2226: okc_debug.Set_Indentation('OKC_PAA_PVT');
2227: okc_debug.log('9400: Entered update_row', 2);
2228: END IF;
2229:
2230: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2373: okc_debug.Set_Indentation('OKC_PAA_PVT');

2369: i NUMBER := 0;
2370: BEGIN
2371:
2372: IF (l_debug = 'Y') THEN
2373: okc_debug.Set_Indentation('OKC_PAA_PVT');
2374: okc_debug.log('9900: Entered update_row', 2);
2375: END IF;
2376:
2377: OKC_API.init_msg_list(p_init_msg_list);

Line 2473: okc_debug.Set_Indentation('OKC_PAA_PVT');

2469: l_row_notfound BOOLEAN := TRUE;
2470: BEGIN
2471:
2472: IF (l_debug = 'Y') THEN
2473: okc_debug.Set_Indentation('OKC_PAA_PVT');
2474: okc_debug.log('10400: Entered delete_row', 2);
2475: END IF;
2476:
2477: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2566: okc_debug.Set_Indentation('OKC_PAA_PVT');

2562: l_paa_rec paa_rec_type;
2563: BEGIN
2564:
2565: IF (l_debug = 'Y') THEN
2566: okc_debug.Set_Indentation('OKC_PAA_PVT');
2567: okc_debug.log('10900: Entered delete_row', 2);
2568: END IF;
2569:
2570: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2677: okc_debug.Set_Indentation('OKC_PAA_PVT');

2673: i NUMBER := 0;
2674: BEGIN
2675:
2676: IF (l_debug = 'Y') THEN
2677: okc_debug.Set_Indentation('OKC_PAA_PVT');
2678: okc_debug.log('11400: Entered delete_row', 2);
2679: END IF;
2680:
2681: OKC_API.init_msg_list(p_init_msg_list);

Line 2765: okc_debug.Set_Indentation('OKC_PAA_PVT');

2761:
2762: BEGIN
2763:
2764: IF (l_debug = 'Y') THEN
2765: okc_debug.Set_Indentation('OKC_PAA_PVT');
2766: okc_debug.log('11900: Entered create_version', 2);
2767: END IF;
2768:
2769: INSERT INTO okc_price_adj_attribs_h

Line 2858: okc_debug.Set_Indentation('OKC_PAA_PVT');

2854:
2855: BEGIN
2856:
2857: IF (l_debug = 'Y') THEN
2858: okc_debug.Set_Indentation('OKC_PAA_PVT');
2859: okc_debug.log('12200: Entered restore_version', 2);
2860: END IF;
2861:
2862: INSERT INTO okc_price_adj_attribs

Line 2940: END OKC_PAA_PVT;

2936: return l_return_status;
2937:
2938: END restore_version;
2939:
2940: END OKC_PAA_PVT;