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.OKS_PM_PROGRAMS_PVT dependencies on OKC_API

Line 6: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2: /* $Header: OKSRPMPB.pls 120.13 2007/12/24 10:21:51 rriyer ship $ */
3:
4: PROCEDURE GENERATE_SCHEDULE(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: p_periods IN NUMBER,

Line 32: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

28: i NUMBER;
29: l_period_ctr NUMBER := p_periods;
30: -----------------------------------------
31: BEGIN
32: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
33: p_init_msg_list,
34: '_PVT',
35: x_return_status);
36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

32: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
33: p_init_msg_list,
34: '_PVT',
35: x_return_status);
36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
37: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
38: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
39: RAISE OKC_API.G_EXCEPTION_ERROR;
40: END IF;

Line 37: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

33: p_init_msg_list,
34: '_PVT',
35: x_return_status);
36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
37: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
38: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
39: RAISE OKC_API.G_EXCEPTION_ERROR;
40: END IF;
41:

Line 38: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

34: '_PVT',
35: x_return_status);
36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
37: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
38: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
39: RAISE OKC_API.G_EXCEPTION_ERROR;
40: END IF;
41:
42:

Line 39: RAISE OKC_API.G_EXCEPTION_ERROR;

35: x_return_status);
36: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
37: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
38: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
39: RAISE OKC_API.G_EXCEPTION_ERROR;
40: END IF;
41:
42:
43: i:=1;

Line 83: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

79: END LOOP;
80:
81: END IF;
82:
83: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
84: RAISE G_EXCEPTION_HALT_VALIDATION;
85: END IF;
86:
87: x_return_status := l_return_status;

Line 95: OKC_API.SET_MESSAGE(

91: x_return_status := l_return_status ;
92:
93:
94: WHEN OTHERS THEN
95: OKC_API.SET_MESSAGE(
96: p_app_name => g_app_name,
97: p_msg_name => g_unexpected_error,
98: p_token1 => g_sqlcode_token,
99: p_token1_value => sqlcode,

Line 103: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

99: p_token1_value => sqlcode,
100: p_token2 => g_sqlerrm_token,
101: p_token2_value => sqlerrm);
102: -- notify caller of an error as UNEXPETED error
103: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
104: x_msg_count :=l_msg_count;
105: END generate_schedule;
106:
107:

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108:
109:
110: /*--for upgrade from Phase I
111: PROCEDURE update_pmp_rule_id(p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2)
116: IS

Line 139: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

135: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
136:
137: ctr NUMBER;
138: BEGIN
139: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
140: G_PKG_NAME,
141: p_init_msg_list,
142: l_api_version,
143: p_api_version,

Line 146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

142: l_api_version,
143: p_api_version,
144: '_PVT',
145: x_return_status);
146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
149: RAISE OKC_API.G_EXCEPTION_ERROR;
150: END IF;

Line 147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

143: p_api_version,
144: '_PVT',
145: x_return_status);
146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
149: RAISE OKC_API.G_EXCEPTION_ERROR;
150: END IF;
151:

Line 148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

144: '_PVT',
145: x_return_status);
146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
149: RAISE OKC_API.G_EXCEPTION_ERROR;
150: END IF;
151:
152: ctr :=1;

Line 149: RAISE OKC_API.G_EXCEPTION_ERROR;

145: x_return_status);
146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
149: RAISE OKC_API.G_EXCEPTION_ERROR;
150: END IF;
151:
152: ctr :=1;
153: FOR cr_pm_schedule IN cu_pm_schedule LOOP

Line 166: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

162: x_msg_count => l_msg_count ,
163: x_msg_data => l_msg_data ,
164: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
165: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
166: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
167: EXCEPTION
168: WHEN OKC_API.G_EXCEPTION_ERROR THEN
169: ROLLBACK ;
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 168: WHEN OKC_API.G_EXCEPTION_ERROR THEN

164: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
165: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
166: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
167: EXCEPTION
168: WHEN OKC_API.G_EXCEPTION_ERROR THEN
169: ROLLBACK ;
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (
172: l_api_name,

Line 170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

166: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
167: EXCEPTION
168: WHEN OKC_API.G_EXCEPTION_ERROR THEN
169: ROLLBACK ;
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (
172: l_api_name,
173: G_PKG_NAME,
174: 'OKC_API.G_RET_STS_ERROR',

Line 174: 'OKC_API.G_RET_STS_ERROR',

170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (
172: l_api_name,
173: G_PKG_NAME,
174: 'OKC_API.G_RET_STS_ERROR',
175: x_msg_count,
176: x_msg_data,
177: '_PVT'
178: );

Line 180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

176: x_msg_data,
177: '_PVT'
178: );
179:
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: ROLLBACK ;
182: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
183: (
184: l_api_name,

Line 182: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

178: );
179:
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: ROLLBACK ;
182: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
183: (
184: l_api_name,
185: G_PKG_NAME,
186: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 186: 'OKC_API.G_RET_STS_UNEXP_ERROR',

182: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
183: (
184: l_api_name,
185: G_PKG_NAME,
186: 'OKC_API.G_RET_STS_UNEXP_ERROR',
187: x_msg_count,
188: x_msg_data,
189: '_PVT'
190: );

Line 193: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

189: '_PVT'
190: );
191: WHEN OTHERS THEN
192: ROLLBACK ;
193: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
194: (
195: l_api_name,
196: G_PKG_NAME,
197: 'OTHERS',

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

203: */
204:
205: PROCEDURE CREATE_PM_PROGRAM_SCHEDULE
206: (p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_template_cle_id IN NUMBER,

Line 443: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

439: x_duration => l_duration,
440: x_timeunit => l_timeunit,
441: x_return_status => l_return_status);
442:
443: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
444: RAISE G_EXCEPTION_HALT_VALIDATION;
445: END IF;
446:
447: END IF;

Line 492: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN

488: x_periods => x_periods,
489: x_last_date => x_last_date,
490: x_pms_tbl => x_pms_tbl);
491:
492: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN
493: RAISE G_EXCEPTION_HALT_VALIDATION;
494: END IF;
495: l_pmlrulv_tbl(pml_ctr).NUMBER_OF_OCCURENCES := x_periods;
496: -- Added by Jvorugan for Bug:5191017

Line 531: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

527: IF (G_DEBUG_ENABLED = 'Y') THEN
528: okc_debug.log('After oks_pml_pvt insert_row', 3);
529: END IF;
530:
531: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
532: THEN
533: OKC_API.set_message
534: (G_APP_NAME,
535: G_REQUIRED_VALUE,

Line 533: OKC_API.set_message

529: END IF;
530:
531: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
532: THEN
533: OKC_API.set_message
534: (G_APP_NAME,
535: G_REQUIRED_VALUE,
536: G_COL_NAME_TOKEN,
537: 'create program stream levels');

Line 567: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

563: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
564: IF (G_DEBUG_ENABLED = 'Y') THEN
565: okc_debug.log('After OKS_PMS_PVT insert_row', 3);
566: END IF;
567: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
568: THEN
569: OKC_API.set_message
570: (G_APP_NAME,
571: G_REQUIRED_VALUE,

Line 569: OKC_API.set_message

565: okc_debug.log('After OKS_PMS_PVT insert_row', 3);
566: END IF;
567: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
568: THEN
569: OKC_API.set_message
570: (G_APP_NAME,
571: G_REQUIRED_VALUE,
572: G_COL_NAME_TOKEN,
573: 'create program schedules ');

Line 578: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND

574:
575: Raise G_EXCEPTION_HALT_VALIDATION;
576: END IF;
577: --Update schedule exists as'Y'
578: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
579: pml_ctr = l_pmlrulv_tbl.FIRST THEN
580: init_oks_k_line(l_klnv_tbl_in);
581: l_klnv_tbl_in(1).id := l_line_id;
582: l_klnv_tbl_in(1).object_version_number := l_obj_version_number;

Line 597: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

593: IF (G_DEBUG_ENABLED = 'Y') THEN
594: okc_debug.log('After OKS_CONTRACT_LINE_PUB UPDATE_LINE', 3);
595: END IF;
596:
597: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
598: OKC_API.set_message
599: (G_APP_NAME,
600: G_REQUIRED_VALUE,
601: G_COL_NAME_TOKEN,

Line 598: OKC_API.set_message

594: okc_debug.log('After OKS_CONTRACT_LINE_PUB UPDATE_LINE', 3);
595: END IF;
596:
597: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
598: OKC_API.set_message
599: (G_APP_NAME,
600: G_REQUIRED_VALUE,
601: G_COL_NAME_TOKEN,
602: 'update Oks_k_lines_b ');

Line 627: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

623: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
624: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
625:
626:
627: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
628: THEN
629: OKC_API.set_message
630: (G_APP_NAME,
631: G_REQUIRED_VALUE,

Line 629: OKC_API.set_message

625:
626:
627: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
628: THEN
629: OKC_API.set_message
630: (G_APP_NAME,
631: G_REQUIRED_VALUE,
632: G_COL_NAME_TOKEN,
633: 'create program schedules ');

Line 661: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

657: x_msg_count =>l_msg_count,
658: x_msg_data =>l_msg_data,
659: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
660: x_pmav_rec =>l_pmarulvrec_Out);
661: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
662: THEN
663: OKC_API.set_message
664: (G_APP_NAME,
665: G_REQUIRED_VALUE,

Line 663: OKC_API.set_message

659: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
660: x_pmav_rec =>l_pmarulvrec_Out);
661: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
662: THEN
663: OKC_API.set_message
664: (G_APP_NAME,
665: G_REQUIRED_VALUE,
666: G_COL_NAME_TOKEN,
667: 'create pm activities');

Line 697: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

693: x_pmav_rec =>l_pmarulvrec_Out);
694: IF (G_DEBUG_ENABLED = 'Y') THEN
695: okc_debug.log('After oks_pma_pvt insert_row', 3);
696: END IF;
697: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
698: THEN
699: OKC_API.set_message
700: (G_APP_NAME,
701: G_REQUIRED_VALUE,

Line 699: OKC_API.set_message

695: okc_debug.log('After oks_pma_pvt insert_row', 3);
696: END IF;
697: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
698: THEN
699: OKC_API.set_message
700: (G_APP_NAME,
701: G_REQUIRED_VALUE,
702: G_COL_NAME_TOKEN,
703: 'create pm activities');

Line 755: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

751: x_duration => l_duration,
752: x_timeunit => l_timeunit,
753: x_return_status => l_return_status);
754:
755: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
756: RAISE G_EXCEPTION_HALT_VALIDATION;
757: END IF;
758:
759: END IF;

Line 804: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN

800: p_first_sch_date => l_first_sch_date,
801: x_periods => x_periods,
802: x_last_date => x_last_date,
803: x_pms_tbl => x_pms_tbl);
804: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN
805: RAISE G_EXCEPTION_HALT_VALIDATION;
806: END IF;
807: l_pmlrulv_tbl(pml_ctr).NUMBER_OF_OCCURENCES := x_periods;
808: -- Added by Jvorugan for Bug:5511803

Line 841: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

837: x_pmlv_rec =>l_pmlrulvrec_Out);
838: IF (G_DEBUG_ENABLED = 'Y') THEN
839: okc_debug.log('After act oks_pml_pvt insert_row', 3);
840: END IF;
841: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
842: THEN
843: OKC_API.set_message
844: (G_APP_NAME,
845: G_REQUIRED_VALUE,

Line 843: OKC_API.set_message

839: okc_debug.log('After act oks_pml_pvt insert_row', 3);
840: END IF;
841: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
842: THEN
843: OKC_API.set_message
844: (G_APP_NAME,
845: G_REQUIRED_VALUE,
846: G_COL_NAME_TOKEN,
847: 'create activity stream levels');

Line 878: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

874:
875: IF (G_DEBUG_ENABLED = 'Y') THEN
876: okc_debug.log('After act OKS_PMS_PVT insert_row', 3);
877: END IF;
878: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
879: THEN
880: OKC_API.set_message
881: (G_APP_NAME,
882: G_REQUIRED_VALUE,

Line 880: OKC_API.set_message

876: okc_debug.log('After act OKS_PMS_PVT insert_row', 3);
877: END IF;
878: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
879: THEN
880: OKC_API.set_message
881: (G_APP_NAME,
882: G_REQUIRED_VALUE,
883: G_COL_NAME_TOKEN,
884: 'create activity schedules ');

Line 898: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

894: x_msg_count =>l_msg_count,
895: x_msg_data =>l_msg_data,
896: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
897: x_pmav_rec =>l_pmarulvrec_Out);
898: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
899: THEN
900: OKC_API.set_message
901: (G_APP_NAME,
902: G_REQUIRED_VALUE,

Line 900: OKC_API.set_message

896: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
897: x_pmav_rec =>l_pmarulvrec_Out);
898: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
899: THEN
900: OKC_API.set_message
901: (G_APP_NAME,
902: G_REQUIRED_VALUE,
903: G_COL_NAME_TOKEN,
904: 'UPDATE pm activities');

Line 930: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

926: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
927: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
928:
929:
930: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
931: THEN
932: OKC_API.set_message
933: (G_APP_NAME,
934: G_REQUIRED_VALUE,

Line 932: OKC_API.set_message

928:
929:
930: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
931: THEN
932: OKC_API.set_message
933: (G_APP_NAME,
934: G_REQUIRED_VALUE,
935: G_COL_NAME_TOKEN,
936: 'create activity schedules ');

Line 959: OKC_API.SET_MESSAGE(

955: okc_debug.log('Exiting Create_PM_Program_Schedule'||l_return_Status, 3);
956: okc_debug.Reset_Indentation;
957: END IF;
958: WHEN OTHERS THEN
959: OKC_API.SET_MESSAGE(
960: p_app_name => g_app_name,
961: p_msg_name => g_unexpected_error,
962: p_token1 => g_sqlcode_token,
963: p_token1_value => sqlcode,

Line 967: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

963: p_token1_value => sqlcode,
964: p_token2 => g_sqlerrm_token,
965: p_token2_value => sqlerrm);
966:
967: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
968: x_msg_count :=l_msg_count;
969: IF (G_DEBUG_ENABLED = 'Y') THEN
970: okc_debug.log('Exiting Create_PM_Program_Schedule'||sqlerrm, 3);
971: okc_debug.Reset_Indentation;

Line 979: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

975:
976:
977: PROCEDURE REFRESH_PM_PROGRAM_SCHEDULE
978: (p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_count OUT NOCOPY NUMBER,
982: x_msg_data OUT NOCOPY VARCHAR2,
983: p_cov_tbl IN okc_contract_pub.clev_tbl_type,

Line 1088: IF NOT l_sort_ret_status = OKC_API.G_RET_STS_SUCCESS THEN

1084: ,X_Output_Tab => l_pmlrulv_tbl
1085: ,X_Return_Status => l_sort_ret_status);
1086:
1087:
1088: IF NOT l_sort_ret_status = OKC_API.G_RET_STS_SUCCESS THEN
1089: RAISE G_EXCEPTION_HALT_VALIDATION;
1090: END IF;
1091: -- l_msg_data := l_msg_data||'Sort_PML_StDt : '||l_sort_ret_status||'; ';
1092:

Line 1141: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1137: x_duration => l_duration,
1138: x_timeunit => l_timeunit,
1139: x_return_status => l_return_status);
1140:
1141: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1142: RAISE G_EXCEPTION_HALT_VALIDATION;
1143: END IF;
1144:
1145: END IF;

Line 1175: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN

1171: x_periods => x_periods,
1172: x_last_date => x_last_date,
1173: x_pms_tbl => x_pms_tbl);
1174:
1175: IF NOT x_sch_ret_status = OKC_API.G_RET_STS_SUCCESS THEN
1176: RAISE G_EXCEPTION_HALT_VALIDATION;
1177: END IF;
1178:
1179: -- l_msg_data := l_msg_data||'l_pmlrulv_tbl_out(i).id : '||l_pmlrulv_tbl_out(i).id||'; ';

Line 1246: OKC_API.SET_MESSAGE(

1242: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1243: x_return_status := l_return_status ;
1244:
1245: WHEN OTHERS THEN
1246: OKC_API.SET_MESSAGE(
1247: p_app_name => g_app_name,
1248: p_msg_name => g_unexpected_error,
1249: p_token1 => g_sqlcode_token,
1250: p_token1_value => sqlcode,

Line 1254: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1250: p_token1_value => sqlcode,
1251: p_token2 => g_sqlerrm_token,
1252: p_token2_value => sqlerrm);
1253:
1254: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1255:
1256: END REFRESH_PM_PROGRAM_SCHEDULE;
1257:
1258: PROCEDURE RENEW_PM_PROGRAM_SCHEDULE

Line 1260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1256: END REFRESH_PM_PROGRAM_SCHEDULE;
1257:
1258: PROCEDURE RENEW_PM_PROGRAM_SCHEDULE
1259: (p_api_version IN NUMBER,
1260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1263: x_msg_data OUT NOCOPY VARCHAR2,
1264: p_contract_line_id IN NUMBER)

Line 1332: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

1328: IF (G_DEBUG_ENABLED = 'Y') THEN
1329: okc_debug.log('After CREATE_PM_PROGRAM_SCHEDULE', 3);
1330: END IF;
1331:
1332: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1333: THEN
1334: OKC_API.set_message
1335: (G_APP_NAME,
1336: G_REQUIRED_VALUE,

Line 1334: OKC_API.set_message

1330: END IF;
1331:
1332: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1333: THEN
1334: OKC_API.set_message
1335: (G_APP_NAME,
1336: G_REQUIRED_VALUE,
1337: G_COL_NAME_TOKEN,
1338: 'create activities streamlevels and schedules');

Line 1361: OKC_API.SET_MESSAGE(

1357: okc_debug.Reset_Indentation;
1358: END IF;
1359:
1360: WHEN OTHERS THEN
1361: OKC_API.SET_MESSAGE(
1362: p_app_name => g_app_name,
1363: p_msg_name => g_unexpected_error,
1364: p_token1 => g_sqlcode_token,
1365: p_token1_value => sqlcode,

Line 1369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1365: p_token1_value => sqlcode,
1366: p_token2 => g_sqlerrm_token,
1367: p_token2_value => sqlerrm);
1368:
1369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1370: x_msg_count :=l_msg_count;
1371: IF (G_DEBUG_ENABLED = 'Y') THEN
1372: okc_debug.log('Exiting Renew_PM_Program_Schedule'||l_return_Status, 3);
1373: okc_debug.Reset_Indentation;

Line 1382: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1378:
1379: --CK CODE FOR RULES CHANGES
1380: PROCEDURE POPULATE_SCHEDULE
1381: (p_api_version IN NUMBER,
1382: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1383: x_return_status OUT NOCOPY VARCHAR2,
1384: x_msg_count OUT NOCOPY NUMBER,
1385: x_msg_data OUT NOCOPY VARCHAR2,
1386: p_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,

Line 1420: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1416: WHERE id=cp_activity_line_id;
1417: -- cr_obj_version cu_obj_version%ROWTYPE;
1418: l_object_version_number NUMBER;
1419: BEGIN
1420: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1421: p_init_msg_list,
1422: '_PVT',
1423: x_return_status);
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1420: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1421: p_init_msg_list,
1422: '_PVT',
1423: x_return_status);
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;

Line 1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1421: p_init_msg_list,
1422: '_PVT',
1423: x_return_status);
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429:

Line 1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1422: '_PVT',
1423: x_return_status);
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429:
1430:

Line 1427: RAISE OKC_API.G_EXCEPTION_ERROR;

1423: x_return_status);
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429:
1430:
1431: l_pml_index:=1;

Line 1459: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

1455: x_msg_count =>l_msg_count,
1456: x_msg_data =>l_msg_data,
1457: p_pmlv_rec =>l_pmlrulv_tbl(l_pml_index),
1458: x_pmlv_rec =>l_pmlrulvrec_Out);
1459: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1460: THEN
1461: OKC_API.set_message
1462: (G_APP_NAME,
1463: G_REQUIRED_VALUE,

Line 1461: OKC_API.set_message

1457: p_pmlv_rec =>l_pmlrulv_tbl(l_pml_index),
1458: x_pmlv_rec =>l_pmlrulvrec_Out);
1459: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1460: THEN
1461: OKC_API.set_message
1462: (G_APP_NAME,
1463: G_REQUIRED_VALUE,
1464: G_COL_NAME_TOKEN,
1465: 'create program stream levels');

Line 1501: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

1497: x_msg_count => l_msg_count ,
1498: x_msg_data => l_msg_data ,
1499: p_oks_pm_schedules_v_tbl => l_sch_tbl,
1500: x_oks_pm_schedules_v_tbl =>l_sch_tbl_out);
1501: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1502: THEN
1503: OKC_API.set_message
1504: (G_APP_NAME,
1505: G_REQUIRED_VALUE,

Line 1503: OKC_API.set_message

1499: p_oks_pm_schedules_v_tbl => l_sch_tbl,
1500: x_oks_pm_schedules_v_tbl =>l_sch_tbl_out);
1501: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1502: THEN
1503: OKC_API.set_message
1504: (G_APP_NAME,
1505: G_REQUIRED_VALUE,
1506: G_COL_NAME_TOKEN,
1507: 'create activity schedules');

Line 1525: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS

1521: x_msg_count =>l_msg_count,
1522: x_msg_data =>l_msg_data,
1523: p_pmav_rec =>l_pmarulv_rec,
1524: x_pmav_rec =>l_pmarulv_rec_Out);
1525: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1526: THEN
1527: OKC_API.set_message
1528: (G_APP_NAME,
1529: G_REQUIRED_VALUE,

Line 1527: OKC_API.set_message

1523: p_pmav_rec =>l_pmarulv_rec,
1524: x_pmav_rec =>l_pmarulv_rec_Out);
1525: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS
1526: THEN
1527: OKC_API.set_message
1528: (G_APP_NAME,
1529: G_REQUIRED_VALUE,
1530: G_COL_NAME_TOKEN,
1531: 'update schedule exists');

Line 1547: OKC_API.SET_MESSAGE(

1543: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1544: x_return_status := l_return_status ;
1545:
1546: WHEN OTHERS THEN
1547: OKC_API.SET_MESSAGE(
1548: p_app_name => g_app_name,
1549: p_msg_name => g_unexpected_error,
1550: p_token1 => g_sqlcode_token,
1551: p_token1_value => sqlcode,

Line 1555: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1551: p_token1_value => sqlcode,
1552: p_token2 => g_sqlerrm_token,
1553: p_token2_value => sqlerrm);
1554: -- notify caller of an error as UNEXPETED error
1555: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1556: x_msg_count :=l_msg_count;
1557:
1558: END POPULATE_SCHEDULE;
1559:

Line 1633: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1629:
1630: */
1631: PROCEDURE ADJUST_PM_PROGRAM_SCHEDULE
1632: (p_api_version IN NUMBER,
1633: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1634: p_contract_line_id IN NUMBER,
1635: p_new_start_date IN DATE,
1636: p_new_end_date IN DATE,
1637: x_return_status OUT NOCOPY VARCHAR2,

Line 2294: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2290: IF (G_DEBUG_ENABLED = 'Y') THEN
2291: okc_debug.log('After oks_pms_pvt delete_row', 3);
2292: END IF;
2293:
2294: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2295: OKC_API.set_message
2296: (G_APP_NAME,
2297: G_REQUIRED_VALUE,
2298: G_COL_NAME_TOKEN,

Line 2295: OKC_API.set_message

2291: okc_debug.log('After oks_pms_pvt delete_row', 3);
2292: END IF;
2293:
2294: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2295: OKC_API.set_message
2296: (G_APP_NAME,
2297: G_REQUIRED_VALUE,
2298: G_COL_NAME_TOKEN,
2299: 'delete pm schedules');

Line 2316: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2312: IF (G_DEBUG_ENABLED = 'Y') THEN
2313: okc_debug.log('After oks_pml_pvt delete_row', 3);
2314: END IF;
2315:
2316: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2317: OKC_API.set_message
2318: (G_APP_NAME,
2319: G_REQUIRED_VALUE,
2320: G_COL_NAME_TOKEN,

Line 2317: OKC_API.set_message

2313: okc_debug.log('After oks_pml_pvt delete_row', 3);
2314: END IF;
2315:
2316: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2317: OKC_API.set_message
2318: (G_APP_NAME,
2319: G_REQUIRED_VALUE,
2320: G_COL_NAME_TOKEN,
2321: 'delete pml rules');

Line 2340: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2336: IF (G_DEBUG_ENABLED = 'Y') THEN
2337: okc_debug.log('After oks_pms_pvt insert_row', 3);
2338: END IF;
2339:
2340: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2341: OKC_API.set_message
2342: (G_APP_NAME,
2343: G_REQUIRED_VALUE,
2344: G_COL_NAME_TOKEN,

Line 2341: OKC_API.set_message

2337: okc_debug.log('After oks_pms_pvt insert_row', 3);
2338: END IF;
2339:
2340: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2341: OKC_API.set_message
2342: (G_APP_NAME,
2343: G_REQUIRED_VALUE,
2344: G_COL_NAME_TOKEN,
2345: 'insert pm schedules');

Line 2362: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2358:
2359: IF (G_DEBUG_ENABLED = 'Y') THEN
2360: okc_debug.log('After oks_pml_pvt insert_row', 3);
2361: END IF;
2362: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2363: OKC_API.set_message
2364: (G_APP_NAME,
2365: G_REQUIRED_VALUE,
2366: G_COL_NAME_TOKEN,

Line 2363: OKC_API.set_message

2359: IF (G_DEBUG_ENABLED = 'Y') THEN
2360: okc_debug.log('After oks_pml_pvt insert_row', 3);
2361: END IF;
2362: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2363: OKC_API.set_message
2364: (G_APP_NAME,
2365: G_REQUIRED_VALUE,
2366: G_COL_NAME_TOKEN,
2367: 'insert pml rules');

Line 2411: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2407: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
2408: IF (G_DEBUG_ENABLED = 'Y') THEN
2409: okc_debug.log('After oks_pms_pvt delete_row', 3);
2410: END IF;
2411: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2412: OKC_API.set_message
2413: (G_APP_NAME,
2414: G_REQUIRED_VALUE,
2415: G_COL_NAME_TOKEN,

Line 2412: OKC_API.set_message

2408: IF (G_DEBUG_ENABLED = 'Y') THEN
2409: okc_debug.log('After oks_pms_pvt delete_row', 3);
2410: END IF;
2411: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2412: OKC_API.set_message
2413: (G_APP_NAME,
2414: G_REQUIRED_VALUE,
2415: G_COL_NAME_TOKEN,
2416: 'delete pm schedules');

Line 2436: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2432: IF (G_DEBUG_ENABLED = 'Y') THEN
2433: okc_debug.log('After oks_pml_pvt delete_row', 3);
2434: END IF;
2435:
2436: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2437: OKC_API.set_message
2438: (G_APP_NAME,
2439: G_REQUIRED_VALUE,
2440: G_COL_NAME_TOKEN,

Line 2437: OKC_API.set_message

2433: okc_debug.log('After oks_pml_pvt delete_row', 3);
2434: END IF;
2435:
2436: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2437: OKC_API.set_message
2438: (G_APP_NAME,
2439: G_REQUIRED_VALUE,
2440: G_COL_NAME_TOKEN,
2441: 'delete pml rules');

Line 2468: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2464: x_duration => l_duration,
2465: x_timeunit => l_timeunit,
2466: x_return_status => l_return_status);
2467:
2468: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2469: RAISE G_EXCEPTION_HALT_VALIDATION;
2470: END IF;
2471:
2472: ELSE

Line 2556: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2552: END IF;
2553:
2554: END IF;
2555:
2556: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2557: RAISE G_EXCEPTION_HALT_VALIDATION;
2558: END IF;
2559:
2560: l_pmlrulv_tbl_start(1).OFFSET_DURATION := l_duration;

Line 2598: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2594: IF (G_DEBUG_ENABLED = 'Y') THEN
2595: okc_debug.log('After oks_pms_pvt insert_row', 3);
2596: END IF;
2597:
2598: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2599: OKC_API.set_message
2600: (G_APP_NAME,
2601: G_REQUIRED_VALUE,
2602: G_COL_NAME_TOKEN,

Line 2599: OKC_API.set_message

2595: okc_debug.log('After oks_pms_pvt insert_row', 3);
2596: END IF;
2597:
2598: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2599: OKC_API.set_message
2600: (G_APP_NAME,
2601: G_REQUIRED_VALUE,
2602: G_COL_NAME_TOKEN,
2603: 'inserting PM schedules');

Line 2654: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2650: IF (G_DEBUG_ENABLED = 'Y') THEN
2651: okc_debug.log('After oks_pms_pvt update_row', 3);
2652: END IF;
2653:
2654: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2655: OKC_API.set_message
2656: (G_APP_NAME,
2657: G_REQUIRED_VALUE,
2658: G_COL_NAME_TOKEN,

Line 2655: OKC_API.set_message

2651: okc_debug.log('After oks_pms_pvt update_row', 3);
2652: END IF;
2653:
2654: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2655: OKC_API.set_message
2656: (G_APP_NAME,
2657: G_REQUIRED_VALUE,
2658: G_COL_NAME_TOKEN,
2659: 'updating PM schedules');

Line 2699: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2695: x_duration => l_duration,
2696: x_timeunit => l_timeunit,
2697: x_return_status => l_return_status);
2698:
2699: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2700: RAISE G_EXCEPTION_HALT_VALIDATION;
2701: END IF;
2702:
2703: ELSE

Line 2788: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2784: END IF;
2785:
2786: END IF;
2787:
2788: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2789: RAISE G_EXCEPTION_HALT_VALIDATION;
2790: END IF;
2791:
2792: l_pmlrulv_tbl_start(1).OFFSET_DURATION := l_duration;

Line 2829: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2825: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2826: IF (G_DEBUG_ENABLED = 'Y') THEN
2827: okc_debug.log('After oks_pms_pvt insert_row', 3);
2828: END IF;
2829: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2830: OKC_API.set_message
2831: (G_APP_NAME,
2832: G_REQUIRED_VALUE,
2833: G_COL_NAME_TOKEN,

Line 2830: OKC_API.set_message

2826: IF (G_DEBUG_ENABLED = 'Y') THEN
2827: okc_debug.log('After oks_pms_pvt insert_row', 3);
2828: END IF;
2829: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2830: OKC_API.set_message
2831: (G_APP_NAME,
2832: G_REQUIRED_VALUE,
2833: G_COL_NAME_TOKEN,
2834: 'inserting PM schedules');

Line 2906: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2902: IF (G_DEBUG_ENABLED = 'Y') THEN
2903: okc_debug.log('After oks_pms_pvt insert_row', 3);
2904: END IF;
2905:
2906: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2907: OKC_API.set_message
2908: (G_APP_NAME,
2909: G_REQUIRED_VALUE,
2910: G_COL_NAME_TOKEN,

Line 2907: OKC_API.set_message

2903: okc_debug.log('After oks_pms_pvt insert_row', 3);
2904: END IF;
2905:
2906: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2907: OKC_API.set_message
2908: (G_APP_NAME,
2909: G_REQUIRED_VALUE,
2910: G_COL_NAME_TOKEN,
2911: 'inserting PM schedules');

Line 2953: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2949: IF (G_DEBUG_ENABLED = 'Y') THEN
2950: okc_debug.log('After oks_pms_pvt update_row', 3);
2951: END IF;
2952:
2953: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2954: OKC_API.set_message
2955: (G_APP_NAME,
2956: G_REQUIRED_VALUE,
2957: G_COL_NAME_TOKEN,

Line 2954: OKC_API.set_message

2950: okc_debug.log('After oks_pms_pvt update_row', 3);
2951: END IF;
2952:
2953: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2954: OKC_API.set_message
2955: (G_APP_NAME,
2956: G_REQUIRED_VALUE,
2957: G_COL_NAME_TOKEN,
2958: 'updating PM schedules');

Line 3053: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3049: IF (G_DEBUG_ENABLED = 'Y') THEN
3050: okc_debug.log('After oks_pms_pvt insert_row', 3);
3051: END IF;
3052:
3053: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3054: OKC_API.set_message
3055: (G_APP_NAME,
3056: G_REQUIRED_VALUE,
3057: G_COL_NAME_TOKEN,

Line 3054: OKC_API.set_message

3050: okc_debug.log('After oks_pms_pvt insert_row', 3);
3051: END IF;
3052:
3053: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3054: OKC_API.set_message
3055: (G_APP_NAME,
3056: G_REQUIRED_VALUE,
3057: G_COL_NAME_TOKEN,
3058: 'inserting PM schedules');

Line 3108: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3104:
3105: IF (G_DEBUG_ENABLED = 'Y') THEN
3106: okc_debug.log('After oks_pms_pvt update_row', 3);
3107: END IF;
3108: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3109: OKC_API.set_message
3110: (G_APP_NAME,
3111: G_REQUIRED_VALUE,
3112: G_COL_NAME_TOKEN,

Line 3109: OKC_API.set_message

3105: IF (G_DEBUG_ENABLED = 'Y') THEN
3106: okc_debug.log('After oks_pms_pvt update_row', 3);
3107: END IF;
3108: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3109: OKC_API.set_message
3110: (G_APP_NAME,
3111: G_REQUIRED_VALUE,
3112: G_COL_NAME_TOKEN,
3113: 'updating PM schedules');

Line 3198: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3194: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3195: IF (G_DEBUG_ENABLED = 'Y') THEN
3196: okc_debug.log('After oks_pms_pvt update_row', 3);
3197: END IF;
3198: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3199: OKC_API.set_message
3200: (G_APP_NAME,
3201: G_REQUIRED_VALUE,
3202: G_COL_NAME_TOKEN,

Line 3199: OKC_API.set_message

3195: IF (G_DEBUG_ENABLED = 'Y') THEN
3196: okc_debug.log('After oks_pms_pvt update_row', 3);
3197: END IF;
3198: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3199: OKC_API.set_message
3200: (G_APP_NAME,
3201: G_REQUIRED_VALUE,
3202: G_COL_NAME_TOKEN,
3203: 'updating PM schedules');

Line 3266: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3262: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3263: IF (G_DEBUG_ENABLED = 'Y') THEN
3264: okc_debug.log('After oks_pml_pvt update_row', 3);
3265: END IF;
3266: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3267: OKC_API.set_message
3268: (G_APP_NAME,
3269: G_REQUIRED_VALUE,
3270: G_COL_NAME_TOKEN,

Line 3267: OKC_API.set_message

3263: IF (G_DEBUG_ENABLED = 'Y') THEN
3264: okc_debug.log('After oks_pml_pvt update_row', 3);
3265: END IF;
3266: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3267: OKC_API.set_message
3268: (G_APP_NAME,
3269: G_REQUIRED_VALUE,
3270: G_COL_NAME_TOKEN,
3271: 'updating pml rules');

Line 3312: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3308: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
3309: IF (G_DEBUG_ENABLED = 'Y') THEN
3310: okc_debug.log('After oks_pms_pvt delete_row', 3);
3311: END IF;
3312: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3313: OKC_API.set_message
3314: (G_APP_NAME,
3315: G_REQUIRED_VALUE,
3316: G_COL_NAME_TOKEN,

Line 3313: OKC_API.set_message

3309: IF (G_DEBUG_ENABLED = 'Y') THEN
3310: okc_debug.log('After oks_pms_pvt delete_row', 3);
3311: END IF;
3312: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3313: OKC_API.set_message
3314: (G_APP_NAME,
3315: G_REQUIRED_VALUE,
3316: G_COL_NAME_TOKEN,
3317: 'delete pm schedules');

Line 3337: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3333: IF (G_DEBUG_ENABLED = 'Y') THEN
3334: okc_debug.log('After oks_pml_pvt delete_row', 3);
3335: END IF;
3336:
3337: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3338: OKC_API.set_message
3339: (G_APP_NAME,
3340: G_REQUIRED_VALUE,
3341: G_COL_NAME_TOKEN,

Line 3338: OKC_API.set_message

3334: okc_debug.log('After oks_pml_pvt delete_row', 3);
3335: END IF;
3336:
3337: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3338: OKC_API.set_message
3339: (G_APP_NAME,
3340: G_REQUIRED_VALUE,
3341: G_COL_NAME_TOKEN,
3342: 'delete pml rules');

Line 3395: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3391: IF (G_DEBUG_ENABLED = 'Y') THEN
3392: okc_debug.log('After oks_pms_pvt update_row', 3);
3393: END IF;
3394:
3395: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3396: OKC_API.set_message
3397: (G_APP_NAME,
3398: G_REQUIRED_VALUE,
3399: G_COL_NAME_TOKEN,

Line 3396: OKC_API.set_message

3392: okc_debug.log('After oks_pms_pvt update_row', 3);
3393: END IF;
3394:
3395: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3396: OKC_API.set_message
3397: (G_APP_NAME,
3398: G_REQUIRED_VALUE,
3399: G_COL_NAME_TOKEN,
3400: 'updating PM schedules');

Line 3422: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3418: l_pmschv_start(1).schedule_date_from) - 1,
3419: x_duration => l_duration,
3420: x_timeunit => l_timeunit,
3421: x_return_status => l_return_status);
3422: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3423: RAISE G_EXCEPTION_HALT_VALIDATION;
3424: END IF;
3425:
3426: ELSE

Line 3434: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3430:
3431: END IF;
3432:
3433:
3434: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3435: RAISE G_EXCEPTION_HALT_VALIDATION;
3436: END IF;
3437:
3438: l_pmlrulv_tbl_start(1).OFFSET_DURATION := l_duration;

Line 3532: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3528: END IF;
3529: END IF;
3530:
3531:
3532: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3533: RAISE G_EXCEPTION_HALT_VALIDATION;
3534: END IF;
3535:
3536: l_pmlrulv_tbl_start(1).OFFSET_DURATION := l_duration;

Line 3560: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3556: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
3557: IF (G_DEBUG_ENABLED = 'Y') THEN
3558: okc_debug.log('After oks_pms_pvt insert_row', 3);
3559: END IF;
3560: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3561: OKC_API.set_message
3562: (G_APP_NAME,
3563: G_REQUIRED_VALUE,
3564: G_COL_NAME_TOKEN,

Line 3561: OKC_API.set_message

3557: IF (G_DEBUG_ENABLED = 'Y') THEN
3558: okc_debug.log('After oks_pms_pvt insert_row', 3);
3559: END IF;
3560: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3561: OKC_API.set_message
3562: (G_APP_NAME,
3563: G_REQUIRED_VALUE,
3564: G_COL_NAME_TOKEN,
3565: 'insert pm schedules');

Line 3582: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3578:
3579: IF (G_DEBUG_ENABLED = 'Y') THEN
3580: okc_debug.log('After oks_pms_pvt update_row', 3);
3581: END IF;
3582: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3583: OKC_API.set_message
3584: (G_APP_NAME,
3585: G_REQUIRED_VALUE,
3586: G_COL_NAME_TOKEN,

Line 3583: OKC_API.set_message

3579: IF (G_DEBUG_ENABLED = 'Y') THEN
3580: okc_debug.log('After oks_pms_pvt update_row', 3);
3581: END IF;
3582: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3583: OKC_API.set_message
3584: (G_APP_NAME,
3585: G_REQUIRED_VALUE,
3586: G_COL_NAME_TOKEN,
3587: 'update pm schedules');

Line 3621: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3617: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3618: IF (G_DEBUG_ENABLED = 'Y') THEN
3619: okc_debug.log('After oks_pml_pvt update_row', 3);
3620: END IF;
3621: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3622: OKC_API.set_message
3623: (G_APP_NAME,
3624: G_REQUIRED_VALUE,
3625: G_COL_NAME_TOKEN,

Line 3622: OKC_API.set_message

3618: IF (G_DEBUG_ENABLED = 'Y') THEN
3619: okc_debug.log('After oks_pml_pvt update_row', 3);
3620: END IF;
3621: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3622: OKC_API.set_message
3623: (G_APP_NAME,
3624: G_REQUIRED_VALUE,
3625: G_COL_NAME_TOKEN,
3626: 'updating pml rules');

Line 3669: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3665: IF (G_DEBUG_ENABLED = 'Y') THEN
3666: okc_debug.log('After oks_pms_pvt update_row', 3);
3667: END IF;
3668:
3669: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3670: OKC_API.set_message
3671: (G_APP_NAME,
3672: G_REQUIRED_VALUE,
3673: G_COL_NAME_TOKEN,

Line 3670: OKC_API.set_message

3666: okc_debug.log('After oks_pms_pvt update_row', 3);
3667: END IF;
3668:
3669: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3670: OKC_API.set_message
3671: (G_APP_NAME,
3672: G_REQUIRED_VALUE,
3673: G_COL_NAME_TOKEN,
3674: 'updating PM schedules');

Line 3709: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3705: IF (G_DEBUG_ENABLED = 'Y') THEN
3706: okc_debug.log('After oks_pml_pvt update_row', 3);
3707: END IF;
3708:
3709: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3710: OKC_API.set_message
3711: (G_APP_NAME,
3712: G_REQUIRED_VALUE,
3713: G_COL_NAME_TOKEN,

Line 3710: OKC_API.set_message

3706: okc_debug.log('After oks_pml_pvt update_row', 3);
3707: END IF;
3708:
3709: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3710: OKC_API.set_message
3711: (G_APP_NAME,
3712: G_REQUIRED_VALUE,
3713: G_COL_NAME_TOKEN,
3714: 'updating pml rules');

Line 3755: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3751: IF (G_DEBUG_ENABLED = 'Y') THEN
3752: okc_debug.log('After oks_pms_pvt delete_row', 3);
3753: END IF;
3754:
3755: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3756: OKC_API.set_message
3757: (G_APP_NAME,
3758: G_REQUIRED_VALUE,
3759: G_COL_NAME_TOKEN,

Line 3756: OKC_API.set_message

3752: okc_debug.log('After oks_pms_pvt delete_row', 3);
3753: END IF;
3754:
3755: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3756: OKC_API.set_message
3757: (G_APP_NAME,
3758: G_REQUIRED_VALUE,
3759: G_COL_NAME_TOKEN,
3760: 'delete pm schedules');

Line 3774: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3770: x_msg_data => l_msg_data,
3771: p_pmlv_tbl => l_pmlrulv_tbl_del);
3772:
3773:
3774: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3775: OKC_API.set_message
3776: (G_APP_NAME,
3777: G_REQUIRED_VALUE,
3778: G_COL_NAME_TOKEN,

Line 3775: OKC_API.set_message

3771: p_pmlv_tbl => l_pmlrulv_tbl_del);
3772:
3773:
3774: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3775: OKC_API.set_message
3776: (G_APP_NAME,
3777: G_REQUIRED_VALUE,
3778: G_COL_NAME_TOKEN,
3779: 'delete pml rules');

Line 3817: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3813: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3814: IF (G_DEBUG_ENABLED = 'Y') THEN
3815: okc_debug.log('After oks_pms_pvt update_row', 3);
3816: END IF;
3817: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3818: OKC_API.set_message
3819: (G_APP_NAME,
3820: G_REQUIRED_VALUE,
3821: G_COL_NAME_TOKEN,

Line 3818: OKC_API.set_message

3814: IF (G_DEBUG_ENABLED = 'Y') THEN
3815: okc_debug.log('After oks_pms_pvt update_row', 3);
3816: END IF;
3817: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3818: OKC_API.set_message
3819: (G_APP_NAME,
3820: G_REQUIRED_VALUE,
3821: G_COL_NAME_TOKEN,
3822: 'update pm schedules');

Line 3840: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3836:
3837:
3838:
3839:
3840: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3841: OKC_API.set_message
3842: (G_APP_NAME,
3843: G_REQUIRED_VALUE,
3844: G_COL_NAME_TOKEN,

Line 3841: OKC_API.set_message

3837:
3838:
3839:
3840: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3841: OKC_API.set_message
3842: (G_APP_NAME,
3843: G_REQUIRED_VALUE,
3844: G_COL_NAME_TOKEN,
3845: 'updating pml rules');

Line 3912: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3908: IF (G_DEBUG_ENABLED = 'Y') THEN
3909: okc_debug.log('After oks_pms_pvt insert_row', 3);
3910: END IF;
3911:
3912: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3913: OKC_API.set_message
3914: (G_APP_NAME,
3915: G_REQUIRED_VALUE,
3916: G_COL_NAME_TOKEN,

Line 3913: OKC_API.set_message

3909: okc_debug.log('After oks_pms_pvt insert_row', 3);
3910: END IF;
3911:
3912: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3913: OKC_API.set_message
3914: (G_APP_NAME,
3915: G_REQUIRED_VALUE,
3916: G_COL_NAME_TOKEN,
3917: 'update pm schedules');

Line 3938: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

3934: IF (G_DEBUG_ENABLED = 'Y') THEN
3935: okc_debug.log('After oks_pml_pvt update_row', 3);
3936: END IF;
3937:
3938: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3939: OKC_API.set_message
3940: (G_APP_NAME,
3941: G_REQUIRED_VALUE,
3942: G_COL_NAME_TOKEN,

Line 3939: OKC_API.set_message

3935: okc_debug.log('After oks_pml_pvt update_row', 3);
3936: END IF;
3937:
3938: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3939: OKC_API.set_message
3940: (G_APP_NAME,
3941: G_REQUIRED_VALUE,
3942: G_COL_NAME_TOKEN,
3943: 'updating pml rules');

Line 3978: OKC_API.SET_MESSAGE(

3974: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||l_return_Status, 3);
3975: okc_debug.Reset_Indentation;
3976: END IF;
3977: WHEN OTHERS THEN
3978: OKC_API.SET_MESSAGE(
3979: p_app_name => g_app_name,
3980: p_msg_name => g_unexpected_error,
3981: p_token1 => g_sqlcode_token,
3982: p_token1_value => sqlcode,

Line 3986: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3982: p_token1_value => sqlcode,
3983: p_token2 => g_sqlerrm_token,
3984: p_token2_value => sqlerrm);
3985: ------------dbms_output.put_line('Value of l_return_status6='||l_return_status||substr(sqlerrm,1,200));
3986: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3987: x_msg_count :=l_msg_count;
3988: IF (G_DEBUG_ENABLED = 'Y') THEN
3989: okc_debug.log('Exiting Adjust_PM_Program_Schedule'||sqlerrm, 3);
3990: okc_debug.Reset_Indentation;

Line 3999: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3995: PROCEDURE migrate_to_program
3996: ( p_start_rowid IN ROWID,
3997: p_end_rowid IN ROWID,
3998: p_api_version IN NUMBER,
3999: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4000: x_msg_count OUT NOCOPY NUMBER,
4001: x_return_status OUT NOCOPY VARCHAR2,
4002: x_msg_data OUT NOCOPY VARCHAR2)
4003: IS

Line 4013: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4009: PROCEDURE migrate_to_activities
4010: ( p_start_rowid IN ROWID,
4011: p_end_rowid IN ROWID,
4012: p_api_version IN NUMBER,
4013: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4014: x_msg_count OUT NOCOPY NUMBER,
4015: x_return_status OUT NOCOPY VARCHAR2,
4016: x_msg_data OUT NOCOPY VARCHAR2)
4017:

Line 4027: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4023:
4024: -- procedure called from CHECK_PM_MATCH
4025: Procedure CHECK_PM_STREAM_MATCH
4026: ( p_api_version IN NUMBER,
4027: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4028: x_return_status OUT NOCOPY VARCHAR2,
4029: x_msg_count OUT NOCOPY NUMBER,
4030: x_msg_data OUT NOCOPY VARCHAR2,
4031: P_Source_coverage_Line_Id IN NUMBER,

Line 4153: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

4149: END IF;
4150:
4151: l_source_pml_tbl.delete;
4152: l_target_pml_tbl.delete;
4153: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4154: x_pm_stream_match:= 'Y';
4155: Exception
4156:
4157: When G_MISMATCH THEN

Line 4159: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

4155: Exception
4156:
4157: When G_MISMATCH THEN
4158: x_pm_stream_match:= 'N';
4159: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4160:
4161: WHEN OTHERS THEN
4162: OKC_API.set_message(G_APP_NAME,
4163: G_UNEXPECTED_ERROR,

Line 4162: OKC_API.set_message(G_APP_NAME,

4158: x_pm_stream_match:= 'N';
4159: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4160:
4161: WHEN OTHERS THEN
4162: OKC_API.set_message(G_APP_NAME,
4163: G_UNEXPECTED_ERROR,
4164: G_SQLCODE_TOKEN,
4165: SQLCODE,
4166: G_SQLERRM_TOKEN,

Line 4169: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4165: SQLCODE,
4166: G_SQLERRM_TOKEN,
4167: SQLERRM);
4168: -- notify caller of an UNEXPECTED error
4169: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4170: x_pm_stream_match:= 'E';
4171:
4172:
4173: END CHECK_PM_STREAM_MATCH;

Line 4177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4173: END CHECK_PM_STREAM_MATCH;
4174:
4175: Procedure CHECK_PM_MATCH
4176: ( p_api_version IN NUMBER,
4177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4178: x_return_status OUT NOCOPY VARCHAR2,
4179: x_msg_count OUT NOCOPY NUMBER,
4180: x_msg_data OUT NOCOPY VARCHAR2,
4181: P_Source_coverage_Line_Id IN NUMBER,

Line 4301: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

4297: --===
4298: l_source_pma_tbl.delete;
4299: l_target_pma_tbl.delete;
4300:
4301: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4302: x_pm_match:= 'Y';
4303: Exception
4304:
4305: When G_MISMATCH THEN

Line 4307: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

4303: Exception
4304:
4305: When G_MISMATCH THEN
4306: x_pm_match:= 'N';
4307: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4308:
4309: WHEN OTHERS THEN
4310: OKC_API.set_message(G_APP_NAME,
4311: G_UNEXPECTED_ERROR,

Line 4310: OKC_API.set_message(G_APP_NAME,

4306: x_pm_match:= 'N';
4307: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
4308:
4309: WHEN OTHERS THEN
4310: OKC_API.set_message(G_APP_NAME,
4311: G_UNEXPECTED_ERROR,
4312: G_SQLCODE_TOKEN,
4313: SQLCODE,
4314: G_SQLERRM_TOKEN,

Line 4317: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4313: SQLCODE,
4314: G_SQLERRM_TOKEN,
4315: SQLERRM);
4316: -- notify caller of an UNEXPECTED error
4317: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4318: x_pm_match:= 'E';
4319:
4320:
4321: END CHECK_PM_MATCH;

Line 4329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4325: x_return_status OUT NOCOPY VARCHAR2,
4326: p_chr_id IN NUMBER
4327: )
4328: IS
4329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4330: l_dummy VARCHAR2(1) := '?';
4331: l_count NUMBER := 0;
4332: l_prog_term_flag VARCHAR2(1);
4333: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS

Line 4382: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4378: l_act_rec l_act_csr%ROWTYPE;
4379:
4380: BEGIN
4381: -- initialize return status
4382: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4383:
4384: OPEN l_cle_csr(p_chr_id);
4385:
4386: LOOP

Line 4394: OKC_API.set_message(

4390: OPEN l_prog_csr(l_cle_rec.id);
4391: FETCH l_prog_csr into l_prog_rec;
4392: If l_prog_csr%FOUND THEN
4393: If l_prog_rec.terminate is not null THEN
4394: OKC_API.set_message(
4395: p_app_name => G_APP_NAME_OKS,
4396: p_msg_name => 'OKS_PM_PROGRAM_EFFECTIVITY',
4397: p_token1 => 'CONTRACT_LINE',
4398: p_token1_value =>l_cle_rec.line_number);

Line 4400: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;

4396: p_msg_name => 'OKS_PM_PROGRAM_EFFECTIVITY',
4397: p_token1 => 'CONTRACT_LINE',
4398: p_token1_value =>l_cle_rec.line_number);
4399: -- notify caller of an error
4400: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4401: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4402: l_prog_term_flag :='Y';
4403: End if;--03/01
4404: END IF;

Line 4401: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;

4397: p_token1 => 'CONTRACT_LINE',
4398: p_token1_value =>l_cle_rec.line_number);
4399: -- notify caller of an error
4400: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4401: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4402: l_prog_term_flag :='Y';
4403: End if;--03/01
4404: END IF;
4405: CLOSE l_prog_csr;

Line 4411: OKC_API.set_message(

4407: OPEN l_act_csr(l_cle_rec.id);
4408: FETCH l_act_csr into l_act_rec;
4409: If l_act_csr%FOUND THEN
4410: If l_act_rec.terminate is not null THEN
4411: OKC_API.set_message(
4412: p_app_name => G_APP_NAME_OKS,
4413: p_msg_name => 'OKS_PM_PROGRAM_EFFECTIVITY',
4414: -- token replaced p_token1 => 'LINE_NUMBER',
4415: p_token1 => 'CONTRACT_LINE',

Line 4418: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;

4414: -- token replaced p_token1 => 'LINE_NUMBER',
4415: p_token1 => 'CONTRACT_LINE',
4416: p_token1_value =>l_cle_rec.line_number);
4417: -- notify caller of an error
4418: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4419: x_return_status := 'E';
4420: End If;
4421: End if;
4422: CLOSE l_act_csr;

Line 4434: OKC_API.SET_MESSAGE(

4430: NULL;
4431: WHEN OTHERS THEN
4432: -- store SQL error message on message stack
4433:
4434: OKC_API.SET_MESSAGE(
4435: p_app_name => G_APP_NAME,
4436: p_msg_name => G_UNEXPECTED_ERROR,
4437: p_token1 => G_SQLCODE_TOKEN,
4438: p_token1_value => SQLCODE,

Line 4442: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4438: p_token1_value => SQLCODE,
4439: p_token2 => G_SQLERRM_TOKEN,
4440: p_token2_value => SQLERRM);
4441: -- notify caller of an error as UNEXPETED error
4442: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4443: -- verify that cursor was closed
4444: IF l_cle_csr%ISOPEN THEN
4445: CLOSE l_cle_csr;
4446: END IF;

Line 4458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4454: x_return_status OUT NOCOPY VARCHAR2,
4455: p_chr_id IN NUMBER
4456: )
4457: IS
4458: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4459: l_dummy VARCHAR2(1) := '?';
4460: l_count NUMBER := 0;
4461: l_prog_term_flag VARCHAR2(1);
4462: l_prog1_term_flag VARCHAR2(1);

Line 4508: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4504: and rownum <2;
4505: l_act_rec l_act_csr%ROWTYPE;
4506: BEGIN
4507: -- initialize return status
4508: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4509:
4510: OPEN l_cle_csr(p_chr_id);
4511:
4512: LOOP

Line 4520: OKC_API.set_message(

4516: OPEN l_prog_csr(l_cle_rec.id);
4517: FETCH l_prog_csr into l_prog_rec;
4518: If l_prog_csr%FOUND THEN
4519: If l_prog_rec.mr_header_id is not null THEN
4520: OKC_API.set_message(
4521: p_app_name => G_APP_NAME_OKS,
4522: p_msg_name => 'OKS_PM_MR_EFFECTIVITY',
4523: p_token1 => 'CONTRACT_LINE',
4524: p_token1_value =>l_cle_rec.line_number);

Line 4526: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;

4522: p_msg_name => 'OKS_PM_MR_EFFECTIVITY',
4523: p_token1 => 'CONTRACT_LINE',
4524: p_token1_value =>l_cle_rec.line_number);
4525: -- notify caller of an error
4526: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4527: l_prog_term_flag :='Y';
4528: End if;
4529: END IF;
4530: CLOSE l_prog_csr;

Line 4536: OKC_API.set_message(

4532: OPEN l_act_csr(l_cle_rec.id);
4533: FETCH l_act_csr into l_act_rec;
4534: If l_act_csr%FOUND THEN
4535: If l_act_rec.mr_header_id is not null THEN
4536: OKC_API.set_message(
4537: p_app_name => G_APP_NAME_OKS,
4538: p_msg_name => 'OKS_PM_MR_EFFECTIVITY',
4539: p_token1 => 'CONTRACT_LINE',
4540: p_token1_value =>l_cle_rec.line_number);

Line 4542: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;

4538: p_msg_name => 'OKS_PM_MR_EFFECTIVITY',
4539: p_token1 => 'CONTRACT_LINE',
4540: p_token1_value =>l_cle_rec.line_number);
4541: -- notify caller of an error
4542: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4543: End If;
4544: End if;
4545: CLOSE l_act_csr;
4546: END IF;

Line 4557: OKC_API.SET_MESSAGE(

4553: NULL;
4554: WHEN OTHERS THEN
4555: -- store SQL error message on message stack
4556:
4557: OKC_API.SET_MESSAGE(
4558: p_app_name => G_APP_NAME,
4559: p_msg_name => G_UNEXPECTED_ERROR,
4560: p_token1 => G_SQLCODE_TOKEN,
4561: p_token1_value => SQLCODE,

Line 4565: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4561: p_token1_value => SQLCODE,
4562: p_token2 => G_SQLERRM_TOKEN,
4563: p_token2_value => SQLERRM);
4564: -- notify caller of an error as UNEXPETED error
4565: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4566: -- verify that cursor was closed
4567: IF l_cle_csr%ISOPEN THEN
4568: CLOSE l_cle_csr;
4569: END IF;

Line 4581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4577: x_return_status OUT NOCOPY VARCHAR2,
4578: p_chr_id IN NUMBER
4579: )
4580: IS
4581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4582: l_dummy VARCHAR2(1) := '?';
4583: l_count NUMBER := 0;
4584: /* Modified by jvorugan for Bug:5215180
4585: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS

Line 4700: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4696:
4697:
4698: BEGIN
4699: -- initialize return status
4700: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4701:
4702: OPEN l_cle_csr(p_chr_id);
4703:
4704: LOOP

Line 4716: OKC_API.set_message(

4712: OPEN l_sch_csr(l_cle_rec.id);
4713: FETCH l_sch_csr into l_sch_rec;
4714: If l_sch_csr%NOTFOUND Then
4715:
4716: OKC_API.set_message(
4717: p_app_name => G_APP_NAME_OKS,
4718: p_msg_name => 'OKS_PM_REQUIRED_SCHEDULE',
4719: --03/23 modified token
4720: -- p_token1 => 'LINE_NUMBER',

Line 4725: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;

4721: p_token1 => 'CONTRACT_LINE',
4722: p_token1_value =>l_cle_rec.line_number);
4723:
4724: -- notify caller of an error
4725: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4726: x_return_status := 'E';
4727:
4728: End If;
4729: -- END IF;

Line 4745: OKC_API.set_message(

4741: OPEN l_actsch_csr(l_cle_rec.id);
4742: FETCH l_actsch_csr into l_actsch_rec;
4743: If (l_actsch_csr%NOTFOUND) Then
4744:
4745: OKC_API.set_message(
4746: p_app_name => G_APP_NAME_OKS,
4747: p_msg_name => 'OKS_PMACT_REQUIRED_SCHEDULE',
4748: --03/23 modified token
4749: -- p_token1 => 'LINE_NUMBER',

Line 4753: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;

4749: -- p_token1 => 'LINE_NUMBER',
4750: p_token1 => 'CONTRACT_LINE',
4751: p_token1_value =>l_cle_rec.line_number);
4752: -- notify caller of an error
4753: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4754: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4755: End If;
4756: CLOSE l_actsch_csr;
4757: END if;

Line 4754: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;

4750: p_token1 => 'CONTRACT_LINE',
4751: p_token1_value =>l_cle_rec.line_number);
4752: -- notify caller of an error
4753: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4754: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4755: End If;
4756: CLOSE l_actsch_csr;
4757: END if;
4758: CLOSE l_act_csr;

Line 4769: OKC_API.SET_MESSAGE(

4765: NULL;
4766: WHEN OTHERS THEN
4767: -- store SQL error message on message stack
4768:
4769: OKC_API.SET_MESSAGE(
4770: p_app_name => G_APP_NAME,
4771: p_msg_name => G_UNEXPECTED_ERROR,
4772: p_token1 => G_SQLCODE_TOKEN,
4773: p_token1_value => SQLCODE,

Line 4777: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4773: p_token1_value => SQLCODE,
4774: p_token2 => G_SQLERRM_TOKEN,
4775: p_token2_value => SQLERRM);
4776: -- notify caller of an error as UNEXPETED error
4777: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4778: -- verify that cursor was closed
4779: IF l_cle_csr%ISOPEN THEN
4780: CLOSE l_cle_csr;
4781: END IF;

Line 4798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4794: x_return_status OUT NOCOPY VARCHAR2,
4795: p_chr_id IN NUMBER
4796: )
4797: IS
4798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4799: l_dummy VARCHAR2(1) := '?';
4800: l_count NUMBER := 0;
4801: l_act_tbl act_tbl_type;
4802: /* Modified by Jvorugan for Bug:5215180

Line 4865: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4861: l_act_ctr1 NUMBER;
4862: l_act_exists VARCHAR2(1):='Y';
4863: BEGIN
4864: -- initialize return status
4865: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4866:
4867: OPEN l_cle_csr(p_chr_id);
4868:
4869: LOOP

Line 4899: OKC_API.set_message(

4895: END LOOP;
4896: CLOSE l_act_csr;
4897: -- END LOOP;
4898: IF l_act_exists ='N' THEN
4899: OKC_API.set_message(
4900: p_app_name => G_APP_NAME_OKS,
4901: p_msg_name => 'OKS_PM_NEW_ACTIVITIES',
4902: -- 03/23 changed token p_token1 => 'LINE_NUMBER',
4903: p_token1 => 'CONTRACT_LINE',

Line 4906: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;

4902: -- 03/23 changed token p_token1 => 'LINE_NUMBER',
4903: p_token1 => 'CONTRACT_LINE',
4904: p_token1_value =>l_cle_rec.line_number);
4905: -- notify caller of an error
4906: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4907: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4908: END IF;
4909: END LOOP;
4910: END IF;

Line 4907: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;

4903: p_token1 => 'CONTRACT_LINE',
4904: p_token1_value =>l_cle_rec.line_number);
4905: -- notify caller of an error
4906: --modified to return 'E' instead of 'W' x_return_status := 'W'; --OKC_API.G_RET_STS_ERROR;
4907: x_return_status := 'E'; --OKC_API.G_RET_STS_ERROR;
4908: END IF;
4909: END LOOP;
4910: END IF;
4911: END LOOP;

Line 4921: OKC_API.SET_MESSAGE(

4917: NULL;
4918: WHEN OTHERS THEN
4919: -- store SQL error message on message stack
4920:
4921: OKC_API.SET_MESSAGE(
4922: p_app_name => G_APP_NAME,
4923: p_msg_name => G_UNEXPECTED_ERROR,
4924: p_token1 => G_SQLCODE_TOKEN,
4925: p_token1_value => SQLCODE,

Line 4929: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4925: p_token1_value => SQLCODE,
4926: p_token2 => G_SQLERRM_TOKEN,
4927: p_token2_value => SQLERRM);
4928: -- notify caller of an error as UNEXPETED error
4929: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4930: -- verify that cursor was closed
4931: IF l_cle_csr%ISOPEN THEN
4932: CLOSE l_cle_csr;
4933: END IF;

Line 4941: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4937: END check_pm_new_activities;
4938:
4939: PROCEDURE UNDO_PM_LINE(
4940: p_api_version IN NUMBER,
4941: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4942: x_return_status OUT NOCOPY VARCHAR2,
4943: x_msg_count OUT NOCOPY NUMBER,
4944: x_msg_data OUT NOCOPY VARCHAR2,
4945: p_cle_id IN NUMBER--COVERAGE LINE ID

Line 4978: x_return_status:=OKC_API.G_Ret_Sts_Success;

4974: IF (G_DEBUG_ENABLED = 'Y') THEN
4975: okc_debug.Set_Indentation('Undo_PM_Line');
4976: okc_debug.log('Entered Undo_PM_Line', 3);
4977: END IF;
4978: x_return_status:=OKC_API.G_Ret_Sts_Success;
4979: --Deleting activities
4980: FOR CR_GET_PMA IN CU_GET_PMA
4981: LOOP
4982: l_pma_index:= l_pma_index + 1 ;

Line 4999: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN

4995: IF (G_DEBUG_ENABLED = 'Y') THEN
4996: okc_debug.log('After OKS_PMA_PVT delete_row', 3);
4997: END IF;
4998:
4999: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5000: x_return_status := OKC_API.G_RET_STS_ERROR;
5001: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Activities');
5002: RETURN;
5003: END IF;

Line 5000: x_return_status := OKC_API.G_RET_STS_ERROR;

4996: okc_debug.log('After OKS_PMA_PVT delete_row', 3);
4997: END IF;
4998:
4999: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5000: x_return_status := OKC_API.G_RET_STS_ERROR;
5001: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Activities');
5002: RETURN;
5003: END IF;
5004: --Deleting stream levels

Line 5001: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Activities');

4997: END IF;
4998:
4999: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5000: x_return_status := OKC_API.G_RET_STS_ERROR;
5001: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Activities');
5002: RETURN;
5003: END IF;
5004: --Deleting stream levels
5005: FOR CR_GET_PML IN CU_GET_PML

Line 5025: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN

5021: IF (G_DEBUG_ENABLED = 'Y') THEN
5022: okc_debug.log('After OKS_PML_PVT delete_row', 3);
5023: END IF;
5024:
5025: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5026: x_return_status := OKC_API.G_RET_STS_ERROR;
5027: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Stream Levels');
5028: RETURN;
5029: END IF;

Line 5026: x_return_status := OKC_API.G_RET_STS_ERROR;

5022: okc_debug.log('After OKS_PML_PVT delete_row', 3);
5023: END IF;
5024:
5025: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5026: x_return_status := OKC_API.G_RET_STS_ERROR;
5027: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Stream Levels');
5028: RETURN;
5029: END IF;
5030: --Deleting schedules

Line 5027: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Stream Levels');

5023: END IF;
5024:
5025: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5026: x_return_status := OKC_API.G_RET_STS_ERROR;
5027: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM Stream Levels');
5028: RETURN;
5029: END IF;
5030: --Deleting schedules
5031: FOR CR_GET_SCH IN CU_GET_SCH

Line 5051: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN

5047: IF (G_DEBUG_ENABLED = 'Y') THEN
5048: okc_debug.log('After OKS_PMS_PVT delete_row', 3);
5049: END IF;
5050:
5051: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5052: x_return_status := OKC_API.G_RET_STS_ERROR;
5053: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM_SCHEDULES');
5054: RETURN;
5055: END IF;

Line 5052: x_return_status := OKC_API.G_RET_STS_ERROR;

5048: okc_debug.log('After OKS_PMS_PVT delete_row', 3);
5049: END IF;
5050:
5051: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5052: x_return_status := OKC_API.G_RET_STS_ERROR;
5053: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM_SCHEDULES');
5054: RETURN;
5055: END IF;
5056: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 5053: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM_SCHEDULES');

5049: END IF;
5050:
5051: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
5052: x_return_status := OKC_API.G_RET_STS_ERROR;
5053: OKC_API.Set_Message(G_APP_NAME,G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ERROR IN DELETING PM_SCHEDULES');
5054: RETURN;
5055: END IF;
5056: IF (G_DEBUG_ENABLED = 'Y') THEN
5057: okc_debug.log('Exiting Undo_PM_Line', 3);

Line 5064: OKC_API.SET_MESSAGE(

5060:
5061: EXCEPTION
5062: WHEN OTHERS THEN
5063: x_msg_count :=l_msg_count;
5064: OKC_API.SET_MESSAGE(
5065: p_app_name => g_app_name,
5066: p_msg_name => g_unexpected_error,
5067: p_token1 => g_sqlcode_token,
5068: p_token1_value => sqlcode,

Line 5072: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5068: p_token1_value => sqlcode,
5069: p_token2 => g_sqlerrm_token,
5070: p_token2_value => sqlerrm);
5071: -- notify caller of an error as UNEXPETED error
5072: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5073: IF (G_DEBUG_ENABLED = 'Y') THEN
5074: okc_debug.log('Exiting Undo_PM_Line'||sqlerrm, 3);
5075: okc_debug.Reset_Indentation;
5076: END IF;

Line 5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;

5082:
5083: BEGIN
5084:
5085:
5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;

Line 5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;

5083: BEGIN
5084:
5085:
5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;

Line 5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;

5084:
5085:
5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;

Line 5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;

5085:
5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;

Line 5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;

5086: x_klnv_tbl(1).ID := OKC_API.G_MISS_NUM;
5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;

Line 5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;

5087: x_klnv_tbl(1).CLE_ID := OKC_API.G_MISS_NUM;
5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;

Line 5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;

5088: x_klnv_tbl(1).DNZ_CHR_ID := OKC_API.G_MISS_NUM;
5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;

Line 5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;

5089: x_klnv_tbl(1).DISCOUNT_LIST := OKC_API.G_MISS_NUM;
5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;

Line 5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;

5090: x_klnv_tbl(1).ACCT_RULE_ID := OKC_API.G_MISS_NUM;
5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;

Line 5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;

5091: x_klnv_tbl(1).PAYMENT_TYPE := OKC_API.G_MISS_CHAR;
5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;

Line 5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;

5092: x_klnv_tbl(1).CC_NO := OKC_API.G_MISS_CHAR;
5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;

Line 5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;

5093: x_klnv_tbl(1).CC_EXPIRY_DATE := OKC_API.G_MISS_DATE;
5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;

Line 5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;

5094: x_klnv_tbl(1).CC_BANK_ACCT_ID := OKC_API.G_MISS_NUM;
5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;

Line 5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;

5095: x_klnv_tbl(1).CC_AUTH_CODE := OKC_API.G_MISS_CHAR;
5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;

Line 5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;

5096: x_klnv_tbl(1).COMMITMENT_ID := OKC_API.G_MISS_NUM;
5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;

Line 5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;

5097: x_klnv_tbl(1).LOCKED_PRICE_LIST_ID := OKC_API.G_MISS_NUM;
5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;

Line 5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;

5098: x_klnv_tbl(1).USAGE_EST_YN := OKC_API.G_MISS_CHAR;
5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;

Line 5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;

5099: x_klnv_tbl(1).USAGE_EST_METHOD := OKC_API.G_MISS_CHAR;
5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;

Line 5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;

5100: x_klnv_tbl(1).USAGE_EST_START_DATE := OKC_API.G_MISS_DATE;
5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;

Line 5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;

5101: x_klnv_tbl(1).TERMN_METHOD := OKC_API.G_MISS_CHAR;
5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;

Line 5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;

5102: x_klnv_tbl(1).UBT_AMOUNT := OKC_API.G_MISS_NUM;
5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;

Line 5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;

5103: x_klnv_tbl(1).CREDIT_AMOUNT := OKC_API.G_MISS_NUM;
5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;

Line 5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;

5104: x_klnv_tbl(1).SUPPRESSED_CREDIT := OKC_API.G_MISS_NUM;
5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;

Line 5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;

5105: x_klnv_tbl(1).OVERRIDE_AMOUNT := OKC_API.G_MISS_NUM;
5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;

Line 5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;

5106: x_klnv_tbl(1).GRACE_DURATION := OKC_API.G_MISS_NUM;
5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;

Line 5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;

5107: x_klnv_tbl(1).GRACE_PERIOD := OKC_API.G_MISS_CHAR;
5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;

Line 5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;

5108: x_klnv_tbl(1).INV_PRINT_FLAG := OKC_API.G_MISS_CHAR;
5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;

Line 5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;

5109: x_klnv_tbl(1).PRICE_UOM := OKC_API.G_MISS_CHAR;
5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;

Line 5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;

5110: x_klnv_tbl(1).TAX_AMOUNT := OKC_API.G_MISS_NUM;
5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;

Line 5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;

5111: x_klnv_tbl(1).TAX_INCLUSIVE_YN := OKC_API.G_MISS_CHAR;
5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;

Line 5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;

5112: x_klnv_tbl(1).TAX_STATUS := OKC_API.G_MISS_CHAR;
5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;

Line 5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;

5113: x_klnv_tbl(1).TAX_CODE := OKC_API.G_MISS_NUM;
5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;

Line 5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;

5114: x_klnv_tbl(1).TAX_EXEMPTION_ID := OKC_API.G_MISS_NUM;
5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;

Line 5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;

5115: x_klnv_tbl(1).IB_TRANS_TYPE := OKC_API.G_MISS_CHAR;
5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;

Line 5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;

5116: x_klnv_tbl(1).IB_TRANS_DATE := OKC_API.G_MISS_DATE;
5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;

Line 5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;

5117: x_klnv_tbl(1).PROD_PRICE := OKC_API.G_MISS_NUM;
5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;

Line 5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;

5118: x_klnv_tbl(1).SERVICE_PRICE := OKC_API.G_MISS_NUM;
5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;

Line 5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;

5119: x_klnv_tbl(1).CLVL_LIST_PRICE := OKC_API.G_MISS_NUM;
5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;

Line 5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;

5120: x_klnv_tbl(1).CLVL_QUANTITY := OKC_API.G_MISS_NUM;
5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;

Line 5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;

5121: x_klnv_tbl(1).CLVL_EXTENDED_AMT := OKC_API.G_MISS_NUM;
5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;

Line 5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;

5122: x_klnv_tbl(1).CLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;

Line 5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;

5123: x_klnv_tbl(1).TOPLVL_OPERAND_CODE := OKC_API.G_MISS_CHAR;
5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;

Line 5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;

5124: x_klnv_tbl(1).TOPLVL_OPERAND_VAL := OKC_API.G_MISS_NUM;
5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;

Line 5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;

5125: x_klnv_tbl(1).TOPLVL_QUANTITY := OKC_API.G_MISS_NUM;
5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;

Line 5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;

5126: x_klnv_tbl(1).TOPLVL_UOM_CODE := OKC_API.G_MISS_CHAR;
5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;

Line 5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;

5127: x_klnv_tbl(1).TOPLVL_ADJ_PRICE := OKC_API.G_MISS_NUM;
5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;

Line 5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;

5128: x_klnv_tbl(1).TOPLVL_PRICE_QTY := OKC_API.G_MISS_NUM;
5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;

Line 5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;

5129: x_klnv_tbl(1).AVERAGING_INTERVAL := OKC_API.G_MISS_NUM;
5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;

Line 5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;

5130: x_klnv_tbl(1).SETTLEMENT_INTERVAL := OKC_API.G_MISS_CHAR;
5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;

Line 5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;

5131: x_klnv_tbl(1).MINIMUM_QUANTITY := OKC_API.G_MISS_NUM;
5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;

Line 5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;

5132: x_klnv_tbl(1).DEFAULT_QUANTITY := OKC_API.G_MISS_NUM;
5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;

Line 5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;

5133: x_klnv_tbl(1).AMCV_FLAG := OKC_API.G_MISS_CHAR;
5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;

Line 5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;

5134: x_klnv_tbl(1).FIXED_QUANTITY := OKC_API.G_MISS_NUM;
5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;

Line 5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;

5135: x_klnv_tbl(1).USAGE_DURATION := OKC_API.G_MISS_NUM;
5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;

Line 5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;

5136: x_klnv_tbl(1).USAGE_PERIOD := OKC_API.G_MISS_CHAR;
5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;

Line 5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;

5137: x_klnv_tbl(1).LEVEL_YN := OKC_API.G_MISS_CHAR;
5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;

Line 5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;

5138: x_klnv_tbl(1).USAGE_TYPE := OKC_API.G_MISS_CHAR;
5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;

Line 5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;

5139: x_klnv_tbl(1).UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;

Line 5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;

5140: x_klnv_tbl(1).BASE_READING := OKC_API.G_MISS_NUM;
5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;

Line 5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;

5141: x_klnv_tbl(1).BILLING_SCHEDULE_TYPE := OKC_API.G_MISS_CHAR;
5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;

Line 5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;

5142: x_klnv_tbl(1).COVERAGE_TYPE := OKC_API.G_MISS_CHAR;
5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;

Line 5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;

5143: x_klnv_tbl(1).EXCEPTION_COV_ID := OKC_API.G_MISS_NUM;
5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;

Line 5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;

5144: x_klnv_tbl(1).LIMIT_UOM_QUANTIFIED := OKC_API.G_MISS_CHAR;
5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;

Line 5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;

5145: x_klnv_tbl(1).DISCOUNT_AMOUNT := OKC_API.G_MISS_NUM;
5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;

Line 5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;

5146: x_klnv_tbl(1).DISCOUNT_PERCENT := OKC_API.G_MISS_NUM;
5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;

Line 5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;

5147: x_klnv_tbl(1).OFFSET_DURATION := OKC_API.G_MISS_NUM;
5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;

Line 5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;

5148: x_klnv_tbl(1).OFFSET_PERIOD := OKC_API.G_MISS_CHAR;
5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;

Line 5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;

5149: x_klnv_tbl(1).INCIDENT_SEVERITY_ID := OKC_API.G_MISS_NUM;
5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;

Line 5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;

5150: x_klnv_tbl(1).PDF_ID := OKC_API.G_MISS_NUM;
5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;

Line 5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;

5151: x_klnv_tbl(1).WORK_THRU_YN := OKC_API.G_MISS_CHAR;
5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;

Line 5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;

5152: x_klnv_tbl(1).REACT_ACTIVE_YN := OKC_API.G_MISS_CHAR;
5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;

Line 5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;

5153: x_klnv_tbl(1).TRANSFER_OPTION := OKC_API.G_MISS_CHAR;
5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;

Line 5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;

5154: x_klnv_tbl(1).PROD_UPGRADE_YN := OKC_API.G_MISS_CHAR;
5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;

Line 5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;

5155: x_klnv_tbl(1).INHERITANCE_TYPE := OKC_API.G_MISS_CHAR;
5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;

Line 5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;

5156: x_klnv_tbl(1).PM_PROGRAM_ID := OKC_API.G_MISS_NUM;
5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;

Line 5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;

5157: x_klnv_tbl(1).PM_CONF_REQ_YN := OKC_API.G_MISS_CHAR;
5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;

Line 5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;

5158: x_klnv_tbl(1).PM_SCH_EXISTS_YN := OKC_API.G_MISS_CHAR;
5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;

Line 5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;

5159: x_klnv_tbl(1).ALLOW_BT_DISCOUNT := OKC_API.G_MISS_CHAR;
5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;

Line 5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;

5160: x_klnv_tbl(1).APPLY_DEFAULT_TIMEZONE := OKC_API.G_MISS_CHAR;
5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;

Line 5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;

5161: x_klnv_tbl(1).SYNC_DATE_INSTALL := OKC_API.G_MISS_CHAR;
5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;

Line 5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;

5162: x_klnv_tbl(1).SFWT_FLAG := OKC_API.G_MISS_CHAR;
5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;

Line 5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;

5163: x_klnv_tbl(1).OBJECT_VERSION_NUMBER := OKC_API.G_MISS_NUM;
5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
5171: END init_oks_k_line;

Line 5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;

5164: x_klnv_tbl(1).SECURITY_GROUP_ID := OKC_API.G_MISS_NUM;
5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
5171: END init_oks_k_line;
5172:

Line 5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;

5165: x_klnv_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
5171: END init_oks_k_line;
5172:
5173:

Line 5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;

5166: x_klnv_tbl(1).CREATED_BY := OKC_API.G_MISS_NUM;
5167: x_klnv_tbl(1).CREATION_DATE := OKC_API.G_MISS_DATE;
5168: x_klnv_tbl(1).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
5169: x_klnv_tbl(1).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
5170: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
5171: END init_oks_k_line;
5172:
5173:
5174: PROCEDURE Version_PM(

Line 5202: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5198: l_return_Status := OKS_PMS_PVT.Create_Version(
5199: p_id => l_chr_id,
5200: p_major_version =>l_major_version);
5201:
5202: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5203:
5204: EXCEPTION
5205:
5206: WHEN OTHERS THEN

Line 5208: OKC_API.SET_MESSAGE(

5204: EXCEPTION
5205:
5206: WHEN OTHERS THEN
5207:
5208: OKC_API.SET_MESSAGE(
5209: p_app_name => g_app_name,
5210: p_msg_name => g_unexpected_error,
5211: p_token1 => g_sqlcode_token,
5212: p_token1_value => sqlcode,

Line 5216: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5212: p_token1_value => sqlcode,
5213: p_token2 => g_sqlerrm_token,
5214: p_token2_value => sqlerrm);
5215:
5216: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5217:
5218: END Version_PM;
5219:
5220:

Line 5249: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5245: l_return_Status := OKS_PMS_PVT.Restore_Version(
5246: p_id => l_chr_id,
5247: p_major_version =>l_major_version);
5248:
5249: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5250:
5251: EXCEPTION
5252:
5253: WHEN OTHERS THEN

Line 5255: OKC_API.SET_MESSAGE(

5251: EXCEPTION
5252:
5253: WHEN OTHERS THEN
5254:
5255: OKC_API.SET_MESSAGE(
5256: p_app_name => g_app_name,
5257: p_msg_name => g_unexpected_error,
5258: p_token1 => g_sqlcode_token,
5259: p_token1_value => sqlcode,

Line 5263: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5259: p_token1_value => sqlcode,
5260: p_token2 => g_sqlerrm_token,
5261: p_token2_value => sqlerrm);
5262:
5263: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5264:
5265: END Restore_PM;
5266:
5267:

Line 5291: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5287:
5288: DELETE OKS_PM_ACTIVITIES
5289: WHERE dnz_chr_id = l_chr_id;
5290:
5291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5292:
5293: EXCEPTION
5294:
5295: WHEN OTHERS THEN

Line 5297: OKC_API.SET_MESSAGE(

5293: EXCEPTION
5294:
5295: WHEN OTHERS THEN
5296:
5297: OKC_API.SET_MESSAGE(
5298: p_app_name => g_app_name,
5299: p_msg_name => g_unexpected_error,
5300: p_token1 => g_sqlcode_token,
5301: p_token1_value => sqlcode,

Line 5305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5301: p_token1_value => sqlcode,
5302: p_token2 => g_sqlerrm_token,
5303: p_token2_value => sqlerrm);
5304:
5305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5306:
5307: END Delete_PMHistory;
5308:
5309: PROCEDURE Delete_PMSaved_Version(

Line 5318: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

5314: x_msg_data OUT NOCOPY VARCHAR2,
5315: p_chr_id IN NUMBER) IS
5316:
5317: l_api_version NUMBER := 1;
5318: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
5319: l_return_status VARCHAR2(1);
5320: l_return_msg VARCHAR2(2000);
5321: l_msg_count NUMBER;
5322: l_msg_data VARCHAR2(2000);

Line 5328: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

5324: l_chr_id CONSTANT NUMBER := p_chr_id;
5325:
5326: BEGIN
5327:
5328: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
5329: p_init_msg_list,
5330: '_PUB',
5331: x_return_status);
5332:

Line 5333: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)

5329: p_init_msg_list,
5330: '_PUB',
5331: x_return_status);
5332:
5333: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
5334: THEN
5335: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5336: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
5337: THEN

Line 5335: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5331: x_return_status);
5332:
5333: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
5334: THEN
5335: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5336: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
5337: THEN
5338: raise OKC_API.G_EXCEPTION_ERROR;
5339: ELSIF l_return_status IS NULL

Line 5336: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)

5332:
5333: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR)
5334: THEN
5335: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5336: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
5337: THEN
5338: raise OKC_API.G_EXCEPTION_ERROR;
5339: ELSIF l_return_status IS NULL
5340: THEN

Line 5338: raise OKC_API.G_EXCEPTION_ERROR;

5334: THEN
5335: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5336: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR)
5337: THEN
5338: raise OKC_API.G_EXCEPTION_ERROR;
5339: ELSIF l_return_status IS NULL
5340: THEN
5341: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5342: END IF;

Line 5341: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5337: THEN
5338: raise OKC_API.G_EXCEPTION_ERROR;
5339: ELSIF l_return_status IS NULL
5340: THEN
5341: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5342: END IF;
5343:
5344:
5345: DELETE OKS_PM_SCHEDULES_H

Line 5360: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5356:
5357: x_Return_status:=l_Return_Status;
5358:
5359: EXCEPTION
5360: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5361: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5362: (l_api_name,
5363: G_PKG_NAME,
5364: 'OKC_API.G_RET_STS_ERROR',

Line 5361: x_return_status := OKC_API.HANDLE_EXCEPTIONS

5357: x_Return_status:=l_Return_Status;
5358:
5359: EXCEPTION
5360: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5361: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5362: (l_api_name,
5363: G_PKG_NAME,
5364: 'OKC_API.G_RET_STS_ERROR',
5365: x_msg_count,

Line 5364: 'OKC_API.G_RET_STS_ERROR',

5360: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5361: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5362: (l_api_name,
5363: G_PKG_NAME,
5364: 'OKC_API.G_RET_STS_ERROR',
5365: x_msg_count,
5366: x_msg_data,
5367: '_PUB');
5368: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5368: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5364: 'OKC_API.G_RET_STS_ERROR',
5365: x_msg_count,
5366: x_msg_data,
5367: '_PUB');
5368: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5369: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5370: (l_api_name,
5371: G_PKG_NAME,
5372: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 5369: x_return_status := OKC_API.HANDLE_EXCEPTIONS

5365: x_msg_count,
5366: x_msg_data,
5367: '_PUB');
5368: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5369: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5370: (l_api_name,
5371: G_PKG_NAME,
5372: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5373: x_msg_count,

Line 5372: 'OKC_API.G_RET_STS_UNEXP_ERROR',

5368: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5369: x_return_status := OKC_API.HANDLE_EXCEPTIONS
5370: (l_api_name,
5371: G_PKG_NAME,
5372: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5373: x_msg_count,
5374: x_msg_data,
5375: '_PUB');
5376: WHEN OTHERS THEN

Line 5377: OKC_API.set_message(p_app_name => g_app_name,

5373: x_msg_count,
5374: x_msg_data,
5375: '_PUB');
5376: WHEN OTHERS THEN
5377: OKC_API.set_message(p_app_name => g_app_name,
5378: p_msg_name => g_unexpected_error,
5379: p_token1 => g_sqlcode_token,
5380: p_token1_value => sqlcode,
5381: p_token2 => g_sqlerrm_token,

Line 5383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5379: p_token1 => g_sqlcode_token,
5380: p_token1_value => sqlcode,
5381: p_token2 => g_sqlerrm_token,
5382: p_token2_value => sqlerrm);
5383: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5384: ROLLBACK ;
5385: END Delete_PMSaved_Version;
5386:
5387: /* New procedure for copying PM for coverage template. This procedure is called by

Line 5392: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5388: oks_coverages_pvt.copy_coverage while copying the standard coverage template. */
5389:
5390: PROCEDURE Copy_PM_Template (
5391: p_api_version IN NUMBER,
5392: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5393: x_return_status OUT NOCOPY VARCHAR2,
5394: x_msg_count OUT NOCOPY NUMBER,
5395: x_msg_data OUT NOCOPY VARCHAR2,
5396: p_old_coverage_id IN NUMBER,

Line 5401: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5397: p_new_coverage_id IN NUMBER) IS --instantiated cle id
5398:
5399: ---------------------------------------------------------
5400:
5401: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5402: l_old_cle_id NUMBER;
5403: l_new_cle_id NUMBER;
5404:
5405: -- This function is to insert values into oks_pm_activities

Line 5409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5405: -- This function is to insert values into oks_pm_activities
5406: FUNCTION CREATE_OKS_PM_ACTIVITIES(p_new_cle_id NUMBER,
5407: p_old_cle_id NUMBER) return VARCHAR2 IS
5408:
5409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5410:
5411: BEGIN
5412:
5413: INSERT INTO oks_pm_activities

Line 5466: OKC_API.set_message(G_APP_NAME,

5462: RETURN l_return_status;
5463:
5464: EXCEPTION
5465: WHEN others THEN
5466: OKC_API.set_message(G_APP_NAME,
5467: G_UNEXPECTED_ERROR,
5468: G_SQLCODE_TOKEN,
5469: SQLCODE,
5470: G_SQLERRM_TOKEN,

Line 5472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5468: G_SQLCODE_TOKEN,
5469: SQLCODE,
5470: G_SQLERRM_TOKEN,
5471: SQLERRM);
5472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5473: return x_return_status;
5474:
5475: END CREATE_OKS_PM_ACTIVITIES;
5476:

Line 5481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5477: -- This function is to insert values into oks_pm_stream_levels
5478: FUNCTION CREATE_OKS_PM_STREAM_LEVELS(p_new_cle_id NUMBER,
5479: p_old_cle_id NUMBER) return VARCHAR2 IS
5480:
5481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5482:
5483: BEGIN
5484:
5485: INSERT INTO oks_pm_stream_levels

Line 5553: OKC_API.set_message(G_APP_NAME,

5549: RETURN l_return_status;
5550:
5551: EXCEPTION
5552: WHEN others THEN
5553: OKC_API.set_message(G_APP_NAME,
5554: G_UNEXPECTED_ERROR,
5555: G_SQLCODE_TOKEN,
5556: SQLCODE,
5557: G_SQLERRM_TOKEN,

Line 5559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5555: G_SQLCODE_TOKEN,
5556: SQLCODE,
5557: G_SQLERRM_TOKEN,
5558: SQLERRM);
5559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5560: return x_return_status;
5561:
5562: END CREATE_OKS_PM_STREAM_LEVELS;
5563:

Line 5575: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

5571: l_return_status := CREATE_OKS_PM_ACTIVITIES(p_new_coverage_id,p_old_coverage_id);
5572: IF (G_DEBUG_ENABLED = 'Y') THEN
5573: okc_debug.log('After CREATE_OKS_PM_ACTIVITIES'||l_return_status, 3);
5574: END IF;
5575: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5576: THEN
5577: RAISE G_EXCEPTION_HALT_VALIDATION;
5578: END IF;
5579: l_return_status := CREATE_OKS_PM_STREAM_LEVELS(p_new_coverage_id,p_old_coverage_id);

Line 5584: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);
5582: END IF;
5583:
5584: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5585: THEN
5586: RAISE G_EXCEPTION_HALT_VALIDATION;
5587: END IF;
5588:

Line 5595: OKC_API.set_message(G_APP_NAME,

5591: EXCEPTION
5592: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5593: x_return_status := l_return_status ;
5594: WHEN others THEN
5595: OKC_API.set_message(G_APP_NAME,
5596: G_UNEXPECTED_ERROR,
5597: G_SQLCODE_TOKEN,
5598: SQLCODE,
5599: G_SQLERRM_TOKEN,

Line 5601: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5597: G_SQLCODE_TOKEN,
5598: SQLCODE,
5599: G_SQLERRM_TOKEN,
5600: SQLERRM);
5601: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5602:
5603: END Copy_PM_Template;
5604:
5605: