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_PAT_PVT dependencies on OKC_PAT_PVT

Line 1: PACKAGE BODY OKC_PAT_PVT AS

1: PACKAGE BODY OKC_PAT_PVT AS
2: /* $Header: OKCSPATB.pls 120.1 2005/09/12 00:17:39 mchoudha noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 128: okc_debug.Set_Indentation('OKC_PAT_PVT');

124: l_pat_rec pat_rec_type;
125: BEGIN
126:
127: IF (l_debug = 'Y') THEN
128: okc_debug.Set_Indentation('OKC_PAT_PVT');
129: okc_debug.log('500: Entered get_rec', 2);
130: END IF;
131:
132: x_no_data_found := TRUE;

Line 307: okc_debug.Set_Indentation('OKC_PAT_PVT');

303: l_patv_rec patv_rec_type;
304: BEGIN
305:
306: IF (l_debug = 'Y') THEN
307: okc_debug.Set_Indentation('OKC_PAT_PVT');
308: okc_debug.log('700: Entered get_rec', 2);
309: END IF;
310:
311: x_no_data_found := TRUE;

Line 414: okc_debug.Set_Indentation('OKC_PAT_PVT');

410: l_patv_rec patv_rec_type := p_patv_rec;
411: BEGIN
412:
413: IF (l_debug = 'Y') THEN
414: okc_debug.Set_Indentation('OKC_PAT_PVT');
415: okc_debug.log('900: Entered null_out_defaults', 2);
416: END IF;
417:
418: IF (l_patv_rec.pat_id = OKC_API.G_MISS_NUM) THEN

Line 655: okc_debug.Set_Indentation('OKC_PAT_PVT');

651: where LIST_HEADER_ID = p_patv_rec.list_header_id;
652: Begin
653:
654: IF (l_debug = 'Y') THEN
655: okc_debug.Set_Indentation('OKC_PAT_PVT');
656: okc_debug.log('1000: Entered validate_list_header_id', 2);
657: END IF;
658:
659: -- initialize return status

Line 735: okc_debug.Set_Indentation('OKC_PAT_PVT');

731: where LIST_LINE_ID = p_patv_rec.list_line_id;
732: Begin
733:
734: IF (l_debug = 'Y') THEN
735: okc_debug.Set_Indentation('OKC_PAT_PVT');
736: okc_debug.log('1300: Entered validate_list_line_id', 2);
737: END IF;
738:
739: -- initialize return status

Line 806: okc_debug.Set_Indentation('OKC_PAT_PVT');

802: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
803: BEGIN
804:
805: IF (l_debug = 'Y') THEN
806: okc_debug.Set_Indentation('OKC_PAT_PVT');
807: okc_debug.log('1600: Entered validate_id', 2);
808: END IF;
809:
810: IF p_patv_rec.id = OKC_API.G_MISS_NUM OR

Line 848: okc_debug.Set_Indentation('OKC_PAT_PVT');

844: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
845: BEGIN
846:
847: IF (l_debug = 'Y') THEN
848: okc_debug.Set_Indentation('OKC_PAT_PVT');
849: okc_debug.log('1900: Entered validate_automatic_flag', 2);
850: END IF;
851:
852: -- Check if automatic_flag is Y or N.

Line 901: okc_debug.Set_Indentation('OKC_PAT_PVT');

897: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
898: BEGIN
899:
900: IF (l_debug = 'Y') THEN
901: okc_debug.Set_Indentation('OKC_PAT_PVT');
902: okc_debug.log('2300: Entered validate_update_allowed', 2);
903: END IF;
904:
905:

Line 953: okc_debug.Set_Indentation('OKC_PAT_PVT');

949: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
950: BEGIN
951:
952: IF (l_debug = 'Y') THEN
953: okc_debug.Set_Indentation('OKC_PAT_PVT');
954: okc_debug.log('2700: Entered validate_updated_flag', 2);
955: END IF;
956:
957:

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

1001: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: BEGIN
1003:
1004: IF (l_debug = 'Y') THEN
1005: okc_debug.Set_Indentation('OKC_PAT_PVT');
1006: okc_debug.log('3100: Entered validate_applied_flag', 2);
1007: END IF;
1008:
1009:

Line 1058: okc_debug.Set_Indentation('OKC_PAT_PVT');

1054: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1055: BEGIN
1056:
1057: IF (l_debug = 'Y') THEN
1058: okc_debug.Set_Indentation('OKC_PAT_PVT');
1059: okc_debug.log('3500: Entered validate_on_invoice_flag', 2);
1060: END IF;
1061:
1062:

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

1109: where id = p_patv_rec.chr_id;
1110: begin
1111:
1112: IF (l_debug = 'Y') THEN
1113: okc_debug.Set_Indentation('OKC_PAT_PVT');
1114: okc_debug.log('3900: Entered validate_chr_id', 2);
1115: END IF;
1116:
1117: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1171: okc_debug.Set_Indentation('OKC_PAT_PVT');

1167:
1168: BEGIN
1169:
1170: IF (l_debug = 'Y') THEN
1171: okc_debug.Set_Indentation('OKC_PAT_PVT');
1172: okc_debug.log('4200: Entered Validate_Attributes', 2);
1173: END IF;
1174:
1175: ---------------------------------------------------------------------------------------

Line 1372: okc_debug.Set_Indentation('OKC_PAT_PVT');

1368: l_row_notfound BOOLEAN := TRUE;
1369: BEGIN
1370:
1371: IF (l_debug = 'Y') THEN
1372: okc_debug.Set_Indentation('OKC_PAT_PVT');
1373: okc_debug.log('4600: Entered validate_foreign_keys', 2);
1374: END IF;
1375:
1376: IF (p_patv_rec.PAT_ID IS NOT NULL)

Line 1644: okc_debug.Set_Indentation('OKC_PAT_PVT');

1640: l_pat_rec pat_rec_type;
1641: BEGIN
1642:
1643: IF (l_debug = 'Y') THEN
1644: okc_debug.Set_Indentation('OKC_PAT_PVT');
1645: okc_debug.log('5200: Entered validate_row', 2);
1646: END IF;
1647:
1648: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1750: okc_debug.Set_Indentation('OKC_PAT_PVT');

1746: i NUMBER := 0;
1747: BEGIN
1748:
1749: IF (l_debug = 'Y') THEN
1750: okc_debug.Set_Indentation('OKC_PAT_PVT');
1751: okc_debug.log('5700: Entered validate_row', 2);
1752: END IF;
1753:
1754: OKC_API.init_msg_list(p_init_msg_list);

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

1860: END Set_Attributes;
1861: BEGIN
1862:
1863: IF (l_debug = 'Y') THEN
1864: okc_debug.Set_Indentation('OKC_PAT_PVT');
1865: okc_debug.log('6300: Entered insert_row', 2);
1866: END IF;
1867:
1868: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2137: okc_debug.Set_Indentation('OKC_PAT_PVT');

2133: END Set_Attributes;
2134: BEGIN
2135:
2136: IF (l_debug = 'Y') THEN
2137: okc_debug.Set_Indentation('OKC_PAT_PVT');
2138: okc_debug.log('7000: Entered insert_row', 2);
2139: END IF;
2140:
2141: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2281: okc_debug.Set_Indentation('OKC_PAT_PVT');

2277: i NUMBER := 0;
2278: BEGIN
2279:
2280: IF (l_debug = 'Y') THEN
2281: okc_debug.Set_Indentation('OKC_PAT_PVT');
2282: okc_debug.log('7500: Entered insert_row', 2);
2283: END IF;
2284:
2285: OKC_API.init_msg_list(p_init_msg_list);

Line 2397: okc_debug.Set_Indentation('OKC_PAT_PVT');

2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN
2395:
2396: IF (l_debug = 'Y') THEN
2397: okc_debug.Set_Indentation('OKC_PAT_PVT');
2398: okc_debug.log('8000: Entered lock_row', 2);
2399: END IF;
2400:
2401: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2413: okc_debug.Set_Indentation('OKC_PAT_PVT');

2409: END IF;
2410: BEGIN
2411:
2412: IF (l_debug = 'Y') THEN
2413: okc_debug.Set_Indentation('OKC_PAT_PVT');
2414: okc_debug.log('8100: Entered lock_row', 2);
2415: END IF;
2416:
2417: OPEN lock_csr(p_pat_rec);

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

2534: l_pat_rec pat_rec_type;
2535: BEGIN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.Set_Indentation('OKC_PAT_PVT');
2539: okc_debug.log('8800: Entered lock_row', 2);
2540: END IF;
2541:
2542: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2649: okc_debug.Set_Indentation('OKC_PAT_PVT');

2645: i NUMBER := 0;
2646: BEGIN
2647:
2648: IF (l_debug = 'Y') THEN
2649: okc_debug.Set_Indentation('OKC_PAT_PVT');
2650: okc_debug.log('9300: Entered lock_row', 2);
2651: END IF;
2652:
2653: OKC_API.init_msg_list(p_init_msg_list);

Line 2760: okc_debug.Set_Indentation('OKC_PAT_PVT');

2756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2757: BEGIN
2758:
2759: IF (l_debug = 'Y') THEN
2760: okc_debug.Set_Indentation('OKC_PAT_PVT');
2761: okc_debug.log('9800: Entered populate_new_record', 2);
2762: END IF;
2763:
2764: x_pat_rec := p_pat_rec;

Line 3065: okc_debug.Set_Indentation('OKC_PAT_PVT');

3061: END Set_Attributes;
3062: BEGIN
3063:
3064: IF (l_debug = 'Y') THEN
3065: okc_debug.Set_Indentation('OKC_PAT_PVT');
3066: okc_debug.log('10000: Entered update_row', 2);
3067: END IF;
3068:
3069: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3270: okc_debug.Set_Indentation('OKC_PAT_PVT');

3266: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3267: BEGIN
3268:
3269: IF (l_debug = 'Y') THEN
3270: okc_debug.Set_Indentation('OKC_PAT_PVT');
3271: okc_debug.log('10600: Entered populate_new_record', 2);
3272: END IF;
3273:
3274: x_patv_rec := p_patv_rec;

Line 3578: okc_debug.Set_Indentation('OKC_PAT_PVT');

3574: END Set_Attributes;
3575: BEGIN
3576:
3577: IF (l_debug = 'Y') THEN
3578: okc_debug.Set_Indentation('OKC_PAT_PVT');
3579: okc_debug.log('10800: Entered update_row', 2);
3580: END IF;
3581:
3582: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3725: okc_debug.Set_Indentation('OKC_PAT_PVT');

3721: i NUMBER := 0;
3722: BEGIN
3723:
3724: IF (l_debug = 'Y') THEN
3725: okc_debug.Set_Indentation('OKC_PAT_PVT');
3726: okc_debug.log('11300: Entered update_row', 2);
3727: END IF;
3728:
3729: OKC_API.init_msg_list(p_init_msg_list);

Line 3825: okc_debug.Set_Indentation('OKC_PAT_PVT');

3821: l_row_notfound BOOLEAN := TRUE;
3822: BEGIN
3823:
3824: IF (l_debug = 'Y') THEN
3825: okc_debug.Set_Indentation('OKC_PAT_PVT');
3826: okc_debug.log('11800: Entered delete_row', 2);
3827: END IF;
3828:
3829: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3918: okc_debug.Set_Indentation('OKC_PAT_PVT');

3914: l_pat_rec pat_rec_type;
3915: BEGIN
3916:
3917: IF (l_debug = 'Y') THEN
3918: okc_debug.Set_Indentation('OKC_PAT_PVT');
3919: okc_debug.log('12300: Entered delete_row', 2);
3920: END IF;
3921:
3922: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4028: okc_debug.Set_Indentation('OKC_PAT_PVT');

4024: i NUMBER := 0;
4025: BEGIN
4026:
4027: IF (l_debug = 'Y') THEN
4028: okc_debug.Set_Indentation('OKC_PAT_PVT');
4029: okc_debug.log('12800: Entered delete_row', 2);
4030: END IF;
4031:
4032: OKC_API.init_msg_list(p_init_msg_list);

Line 4188: okc_debug.Set_Indentation('OKC_PAT_PVT');

4184: --Initialize return status
4185: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4186:
4187: IF (l_debug = 'Y') THEN
4188: okc_debug.Set_Indentation('OKC_PAT_PVT');
4189: okc_debug.log('13300: Entered INSERT_ROW_UPG', 2);
4190: END IF;
4191:
4192: i := p_patv_tbl.FIRST; j:=0;

Line 4444: okc_debug.Set_Indentation('OKC_PAT_PVT');

4440:
4441: BEGIN
4442:
4443: IF (l_debug = 'Y') THEN
4444: okc_debug.Set_Indentation('OKC_PAT_PVT');
4445: okc_debug.log('13600: Entered create_version', 2);
4446: END IF;
4447:
4448: INSERT INTO okc_price_adjustments_h

Line 4633: okc_debug.Set_Indentation('OKC_PAT_PVT');

4629:
4630: BEGIN
4631:
4632: IF (l_debug = 'Y') THEN
4633: okc_debug.Set_Indentation('OKC_PAT_PVT');
4634: okc_debug.log('13900: Entered restore_version', 2);
4635: END IF;
4636:
4637: INSERT INTO okc_price_adjustments

Line 4811: END OKC_PAT_PVT;

4807: return l_return_status;
4808:
4809: END restore_version;
4810:
4811: END OKC_PAT_PVT;