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_PAC_PVT dependencies on OKC_PAC_PVT

Line 1: PACKAGE BODY OKC_PAC_PVT AS

1: PACKAGE BODY OKC_PAC_PVT AS
2: /* $Header: OKCSPACB.pls 120.0 2005/05/26 09:55:44 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 77: okc_debug.Set_Indentation('OKC_PAC_PVT');

73: l_pac_rec pac_rec_type;
74: BEGIN
75:
76: IF (l_debug = 'Y') THEN
77: okc_debug.Set_Indentation('OKC_PAC_PVT');
78: okc_debug.log('500: Entered get_rec', 2);
79: END IF;
80:
81: x_no_data_found := TRUE;

Line 154: okc_debug.Set_Indentation('OKC_PAC_PVT');

150: l_pacv_rec pacv_rec_type;
151: BEGIN
152:
153: IF (l_debug = 'Y') THEN
154: okc_debug.Set_Indentation('OKC_PAC_PVT');
155: okc_debug.log('700: Entered get_rec', 2);
156: END IF;
157:
158: x_no_data_found := TRUE;

Line 211: okc_debug.Set_Indentation('OKC_PAC_PVT');

207: l_pacv_rec pacv_rec_type := p_pacv_rec;
208: BEGIN
209:
210: IF (l_debug = 'Y') THEN
211: okc_debug.Set_Indentation('OKC_PAC_PVT');
212: okc_debug.log('900: Entered null_out_defaults', 2);
213: END IF;
214:
215: IF (l_pacv_rec.pat_id = OKC_API.G_MISS_NUM) THEN

Line 284: okc_debug.Set_Indentation('OKC_PAC_PVT');

280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
281: BEGIN
282:
283: IF (l_debug = 'Y') THEN
284: okc_debug.Set_Indentation('OKC_PAC_PVT');
285: okc_debug.log('1000: Entered validate_id', 2);
286: END IF;
287:
288: IF p_pacv_rec.id = OKC_API.G_MISS_NUM OR

Line 327: okc_debug.Set_Indentation('OKC_PAC_PVT');

323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
324: BEGIN
325:
326: IF (l_debug = 'Y') THEN
327: okc_debug.Set_Indentation('OKC_PAC_PVT');
328: okc_debug.log('1300: Entered validate_pat_id_from', 2);
329: END IF;
330:
331: IF p_pacv_rec.pat_id_from = OKC_API.G_MISS_NUM OR

Line 374: okc_debug.Set_Indentation('OKC_PAC_PVT');

370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
371: BEGIN
372:
373: IF (l_debug = 'Y') THEN
374: okc_debug.Set_Indentation('OKC_PAC_PVT');
375: okc_debug.log('1600: Entered Validate_Attributes', 2);
376: END IF;
377:
378: ---------------------------------------------------------------------------------------

Line 570: okc_debug.Set_Indentation('OKC_PAC_PVT');

566: END validate_foreign_keys;
567: BEGIN
568:
569: IF (l_debug = 'Y') THEN
570: okc_debug.Set_Indentation('OKC_PAC_PVT');
571: okc_debug.log('2300: Entered Validate_Record', 2);
572: END IF;
573:
574: l_return_status := validate_foreign_keys (p_pacv_rec);

Line 659: okc_debug.Set_Indentation('OKC_PAC_PVT');

655: l_pac_rec pac_rec_type;
656: BEGIN
657:
658: IF (l_debug = 'Y') THEN
659: okc_debug.Set_Indentation('OKC_PAC_PVT');
660: okc_debug.log('2600: Entered validate_row', 2);
661: END IF;
662:
663: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

761: i NUMBER := 0;
762: BEGIN
763:
764: IF (l_debug = 'Y') THEN
765: okc_debug.Set_Indentation('OKC_PAC_PVT');
766: okc_debug.log('3100: Entered validate_row', 2);
767: END IF;
768:
769: OKC_API.init_msg_list(p_init_msg_list);

Line 879: okc_debug.Set_Indentation('OKC_PAC_PVT');

875: END Set_Attributes;
876: BEGIN
877:
878: IF (l_debug = 'Y') THEN
879: okc_debug.Set_Indentation('OKC_PAC_PVT');
880: okc_debug.log('3700: Entered insert_row', 2);
881: END IF;
882:
883: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1050: okc_debug.Set_Indentation('OKC_PAC_PVT');

1046: END Set_Attributes;
1047: BEGIN
1048:
1049: IF (l_debug = 'Y') THEN
1050: okc_debug.Set_Indentation('OKC_PAC_PVT');
1051: okc_debug.log('4400: Entered insert_row', 2);
1052: END IF;
1053:
1054: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1194: okc_debug.Set_Indentation('OKC_PAC_PVT');

1190: i NUMBER := 0;
1191: BEGIN
1192:
1193: IF (l_debug = 'Y') THEN
1194: okc_debug.Set_Indentation('OKC_PAC_PVT');
1195: okc_debug.log('4900: Entered insert_row', 2);
1196: END IF;
1197:
1198: OKC_API.init_msg_list(p_init_msg_list);

Line 1303: okc_debug.Set_Indentation('OKC_PAC_PVT');

1299: lc_row_notfound BOOLEAN := FALSE;
1300: BEGIN
1301:
1302: IF (l_debug = 'Y') THEN
1303: okc_debug.Set_Indentation('OKC_PAC_PVT');
1304: okc_debug.log('5400: Entered lock_row', 2);
1305: END IF;
1306:
1307: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1483: okc_debug.Set_Indentation('OKC_PAC_PVT');

1479: l_pac_rec pac_rec_type;
1480: BEGIN
1481:
1482: IF (l_debug = 'Y') THEN
1483: okc_debug.Set_Indentation('OKC_PAC_PVT');
1484: okc_debug.log('6200: Entered lock_row', 2);
1485: END IF;
1486:
1487: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1594: okc_debug.Set_Indentation('OKC_PAC_PVT');

1590: i NUMBER := 0;
1591: BEGIN
1592:
1593: IF (l_debug = 'Y') THEN
1594: okc_debug.Set_Indentation('OKC_PAC_PVT');
1595: okc_debug.log('6700: Entered lock_row', 2);
1596: END IF;
1597:
1598: OKC_API.init_msg_list(p_init_msg_list);

Line 1705: okc_debug.Set_Indentation('OKC_PAC_PVT');

1701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1702: BEGIN
1703:
1704: IF (l_debug = 'Y') THEN
1705: okc_debug.Set_Indentation('OKC_PAC_PVT');
1706: okc_debug.log('7200: Entered populate_new_record', 2);
1707: END IF;
1708:
1709: x_pac_rec := p_pac_rec;

Line 1805: okc_debug.Set_Indentation('OKC_PAC_PVT');

1801: END Set_Attributes;
1802: BEGIN
1803:
1804: IF (l_debug = 'Y') THEN
1805: okc_debug.Set_Indentation('OKC_PAC_PVT');
1806: okc_debug.log('7400: Entered update_row', 2);
1807: END IF;
1808:
1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1960: okc_debug.Set_Indentation('OKC_PAC_PVT');

1956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1957: BEGIN
1958:
1959: IF (l_debug = 'Y') THEN
1960: okc_debug.Set_Indentation('OKC_PAC_PVT');
1961: okc_debug.log('8000: Entered populate_new_record', 2);
1962: END IF;
1963:
1964: x_pacv_rec := p_pacv_rec;

Line 2061: okc_debug.Set_Indentation('OKC_PAC_PVT');

2057: END Set_Attributes;
2058: BEGIN
2059:
2060: IF (l_debug = 'Y') THEN
2061: okc_debug.Set_Indentation('OKC_PAC_PVT');
2062: okc_debug.log('8200: Entered update_row', 2);
2063: END IF;
2064:
2065: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2208: okc_debug.Set_Indentation('OKC_PAC_PVT');

2204: i NUMBER := 0;
2205: BEGIN
2206:
2207: IF (l_debug = 'Y') THEN
2208: okc_debug.Set_Indentation('OKC_PAC_PVT');
2209: okc_debug.log('8700: Entered update_row', 2);
2210: END IF;
2211:
2212: OKC_API.init_msg_list(p_init_msg_list);

Line 2308: okc_debug.Set_Indentation('OKC_PAC_PVT');

2304: l_row_notfound BOOLEAN := TRUE;
2305: BEGIN
2306:
2307: IF (l_debug = 'Y') THEN
2308: okc_debug.Set_Indentation('OKC_PAC_PVT');
2309: okc_debug.log('9200: Entered delete_row', 2);
2310: END IF;
2311:
2312: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2397: l_pac_rec pac_rec_type;
2398: BEGIN
2399:
2400: IF (l_debug = 'Y') THEN
2401: okc_debug.Set_Indentation('OKC_PAC_PVT');
2402: okc_debug.log('9700: Entered delete_row', 2);
2403: END IF;
2404:
2405: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2512: okc_debug.Set_Indentation('OKC_PAC_PVT');

2508: i NUMBER := 0;
2509: BEGIN
2510:
2511: IF (l_debug = 'Y') THEN
2512: okc_debug.Set_Indentation('OKC_PAC_PVT');
2513: okc_debug.log('10200: Entered delete_row', 2);
2514: END IF;
2515:
2516: OKC_API.init_msg_list(p_init_msg_list);

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

2596:
2597: BEGIN
2598:
2599: IF (l_debug = 'Y') THEN
2600: okc_debug.Set_Indentation('OKC_PAC_PVT');
2601: okc_debug.log('10700: Entered create_version', 2);
2602: END IF;
2603:
2604: INSERT INTO okc_price_adj_assocs_h

Line 2690: okc_debug.Set_Indentation('OKC_PAC_PVT');

2686:
2687: BEGIN
2688:
2689: IF (l_debug = 'Y') THEN
2690: okc_debug.Set_Indentation('OKC_PAC_PVT');
2691: okc_debug.log('11000: Entered restore_version', 2);
2692: END IF;
2693:
2694: INSERT INTO okc_price_adj_assocs

Line 2768: END OKC_PAC_PVT;

2764: return l_return_status;
2765:
2766: END restore_version;
2767:
2768: END OKC_PAC_PVT;