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 OKS_PML_PVT

Line 329: l_pmlrulvrec_Out oks_pml_pvt.pmlv_rec_type;

325: l_msg_data VARCHAR2(2000):=null;
326: l_duration number;
327: l_timeunit varchar2(30);
328: --
329: l_pmlrulvrec_Out oks_pml_pvt.pmlv_rec_type;
330: l_pmarulv_tbl_out oks_pma_pvt.pmav_tbl_type;
331: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
332: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
333: --

Line 340: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;

336: l_pmarulv_tbl oks_pma_pvt.pmav_tbl_type;
337:
338:
339: l_Rule_Id NUMBER;
340: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
341: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
342: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
343: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
344: l_sort_ret_status VARCHAR2(1) := 'S';

Line 341: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;

337:
338:
339: l_Rule_Id NUMBER;
340: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
341: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
342: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
343: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
344: l_sort_ret_status VARCHAR2(1) := 'S';
345: x_sch_ret_status VARCHAR2(1) := 'S';

Line 519: oks_pml_pvt.insert_row(

515: -- End of changes by Jvorugan
516:
517:
518: --Insert program stream levels
519: oks_pml_pvt.insert_row(
520: p_api_version => l_api_version,
521: p_init_msg_list => l_init_msg_list,
522: x_return_status =>l_return_status,
523: x_msg_count =>l_msg_count,

Line 528: okc_debug.log('After oks_pml_pvt insert_row', 3);

524: x_msg_data =>l_msg_data,
525: p_pmlv_rec =>l_pmlrulv_tbl(pml_ctr),
526: x_pmlv_rec =>l_pmlrulvrec_Out);
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

Line 830: oks_pml_pvt.insert_row(

826: END IF;
827: -- End of changes by Jvorugan
828:
829:
830: oks_pml_pvt.insert_row(
831: p_api_version => l_api_version,
832: p_init_msg_list => l_init_msg_list,
833: x_return_status =>l_return_status,
834: x_msg_count =>l_msg_count,

Line 839: okc_debug.log('After act oks_pml_pvt insert_row', 3);

835: x_msg_data =>l_msg_data,
836: p_pmlv_rec =>l_pmlrulv_tbl(pml_ctr),
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

Line 984: p_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,

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,
984: p_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,
985: x_pmlrulv_tbl OUT NOCOPY oks_pml_pvt.pmlv_tbl_type,
986: x_pmschv_tbl OUT NOCOPY pmsch_refresh_tbl_type)-- OKS_PMS_PVT.oks_pm_schedules_v_tbl_type)
987: IS
988:

Line 985: x_pmlrulv_tbl OUT NOCOPY oks_pml_pvt.pmlv_tbl_type,

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,
984: p_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,
985: x_pmlrulv_tbl OUT NOCOPY oks_pml_pvt.pmlv_tbl_type,
986: x_pmschv_tbl OUT NOCOPY pmsch_refresh_tbl_type)-- OKS_PMS_PVT.oks_pm_schedules_v_tbl_type)
987: IS
988:
989: l_pms_tbl pms_tbl_type;

Line 999: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;

995: l_pmschvtbl_In pmsch_refresh_tbl_type; --OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
996:
997: l_Rule_Id NUMBER;
998:
999: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
1000: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
1001: l_pmlrulv_tbl_02 oks_pml_pvt.pmlv_tbl_type;
1002: l_sort_ret_status VARCHAR2(1) := 'S';
1003: x_sch_ret_status VARCHAR2(1) := 'S';

Line 1000: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;

996:
997: l_Rule_Id NUMBER;
998:
999: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
1000: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
1001: l_pmlrulv_tbl_02 oks_pml_pvt.pmlv_tbl_type;
1002: l_sort_ret_status VARCHAR2(1) := 'S';
1003: x_sch_ret_status VARCHAR2(1) := 'S';
1004: x_periods NUMBER;

Line 1001: l_pmlrulv_tbl_02 oks_pml_pvt.pmlv_tbl_type;

997: l_Rule_Id NUMBER;
998:
999: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
1000: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
1001: l_pmlrulv_tbl_02 oks_pml_pvt.pmlv_tbl_type;
1002: l_sort_ret_status VARCHAR2(1) := 'S';
1003: x_sch_ret_status VARCHAR2(1) := 'S';
1004: x_periods NUMBER;
1005: x_pms_tbl pms_tbl_type;

Line 1020: (P_Input_Tab IN oks_pml_pvt.pmlv_tbl_type

1016: l_timeunit varchar2(30);
1017:
1018:
1019: PROCEDURE Sort_PML_seq
1020: (P_Input_Tab IN oks_pml_pvt.pmlv_tbl_type
1021: ,X_Output_Tab OUT NOCOPY oks_pml_pvt.pmlv_tbl_type
1022: ,X_Return_Status OUT NOCOPY VARCHAR2) IS
1023:
1024: Lx_Sort_Tab oks_pml_pvt.pmlv_tbl_type:= P_Input_Tab;

Line 1021: ,X_Output_Tab OUT NOCOPY oks_pml_pvt.pmlv_tbl_type

1017:
1018:
1019: PROCEDURE Sort_PML_seq
1020: (P_Input_Tab IN oks_pml_pvt.pmlv_tbl_type
1021: ,X_Output_Tab OUT NOCOPY oks_pml_pvt.pmlv_tbl_type
1022: ,X_Return_Status OUT NOCOPY VARCHAR2) IS
1023:
1024: Lx_Sort_Tab oks_pml_pvt.pmlv_tbl_type:= P_Input_Tab;
1025: Lx_Return_Status VARCHAR2(1) := 'S';

Line 1024: Lx_Sort_Tab oks_pml_pvt.pmlv_tbl_type:= P_Input_Tab;

1020: (P_Input_Tab IN oks_pml_pvt.pmlv_tbl_type
1021: ,X_Output_Tab OUT NOCOPY oks_pml_pvt.pmlv_tbl_type
1022: ,X_Return_Status OUT NOCOPY VARCHAR2) IS
1023:
1024: Lx_Sort_Tab oks_pml_pvt.pmlv_tbl_type:= P_Input_Tab;
1025: Lx_Return_Status VARCHAR2(1) := 'S';
1026:
1027: Li_TableIdx_Out BINARY_INTEGER;
1028: Li_TableIdx_In BINARY_INTEGER;

Line 1030: Lx_Temp_Seq oks_pml_pvt.pmlv_rec_type;

1026:
1027: Li_TableIdx_Out BINARY_INTEGER;
1028: Li_TableIdx_In BINARY_INTEGER;
1029:
1030: Lx_Temp_Seq oks_pml_pvt.pmlv_rec_type;
1031:
1032: Lv_Composit_Val1 NUMBER;
1033: Lv_Composit_Val2 NUMBER;
1034:

Line 1386: p_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,

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,
1387: p_sch_tbl IN OKS_PMS_PVT.oks_pm_schedules_v_tbl_type,
1388: p_pma_tbl IN pma_tbl_type,
1389: p_is_template IN VARCHAR2)
1390: IS

Line 1391: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;

1387: p_sch_tbl IN OKS_PMS_PVT.oks_pm_schedules_v_tbl_type,
1388: p_pma_tbl IN pma_tbl_type,
1389: p_is_template IN VARCHAR2)
1390: IS
1391: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
1392: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
1393: l_pmarulv_rec oks_pma_pvt.pmav_rec_type;
1394: l_pmarulv_rec_out oks_pma_pvt.pmav_rec_type;
1395: l_api_version CONSTANT NUMBER := 1.0;

Line 1392: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;

1388: p_pma_tbl IN pma_tbl_type,
1389: p_is_template IN VARCHAR2)
1390: IS
1391: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;
1392: l_pmlrulv_tbl_out oks_pml_pvt.pmlv_tbl_type;
1393: l_pmarulv_rec oks_pma_pvt.pmav_rec_type;
1394: l_pmarulv_rec_out oks_pma_pvt.pmav_rec_type;
1395: l_api_version CONSTANT NUMBER := 1.0;
1396: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';

Line 1402: l_pmlrulvrec_Out oks_pml_pvt.pmlv_rec_type;

1398: l_msg_count NUMBER;
1399: l_msg_data VARCHAR2(2000):=null;
1400: l_msg_index_out Number;
1401: l_api_name CONSTANT VARCHAR2(30) := 'populate schedule';
1402: l_pmlrulvrec_Out oks_pml_pvt.pmlv_rec_type;
1403: l_sch_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1404: l_sch_tbl_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1405: l_pml_index NUMBER;
1406: l_pml_indexin NUMBER;

Line 1451: oks_pml_pvt.insert_row(

1447: l_pmlrulv_tbl(l_pml_index).dnz_chr_id := p_pmlrulv_tbl(l_pml_indexin).dnz_chr_id ;
1448: l_pmlrulv_tbl(l_pml_index).ACTIVITY_LINE_ID := p_pma_tbl(l_pma_index).activity_line_id;
1449:
1450:
1451: oks_pml_pvt.insert_row(
1452: p_api_version => l_api_version,
1453: p_init_msg_list => l_init_msg_list,
1454: x_return_status =>l_return_status,
1455: x_msg_count =>l_msg_count,

Line 1860: l_pmlrulv_tbl OKS_PML_PVT.pmlv_tbl_type;

1856: ORDER BY ACTIVITY_LINE_ID,SEQUENCE_NUMBER;
1857:
1858:
1859: l_pm_tbl pm_tbl_type;
1860: l_pmlrulv_tbl OKS_PML_PVT.pmlv_tbl_type;
1861: l_rulv_tbl_in OKS_PML_PVT.pmlv_tbl_type;
1862: l_rulv_Tbl_Out OKS_PML_PVT.pmlv_tbl_type;
1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;
1864:

Line 1861: l_rulv_tbl_in OKS_PML_PVT.pmlv_tbl_type;

1857:
1858:
1859: l_pm_tbl pm_tbl_type;
1860: l_pmlrulv_tbl OKS_PML_PVT.pmlv_tbl_type;
1861: l_rulv_tbl_in OKS_PML_PVT.pmlv_tbl_type;
1862: l_rulv_Tbl_Out OKS_PML_PVT.pmlv_tbl_type;
1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;
1864:
1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;

Line 1862: l_rulv_Tbl_Out OKS_PML_PVT.pmlv_tbl_type;

1858:
1859: l_pm_tbl pm_tbl_type;
1860: l_pmlrulv_tbl OKS_PML_PVT.pmlv_tbl_type;
1861: l_rulv_tbl_in OKS_PML_PVT.pmlv_tbl_type;
1862: l_rulv_Tbl_Out OKS_PML_PVT.pmlv_tbl_type;
1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;
1864:
1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;

Line 1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;

1859: l_pm_tbl pm_tbl_type;
1860: l_pmlrulv_tbl OKS_PML_PVT.pmlv_tbl_type;
1861: l_rulv_tbl_in OKS_PML_PVT.pmlv_tbl_type;
1862: l_rulv_Tbl_Out OKS_PML_PVT.pmlv_tbl_type;
1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;
1864:
1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;
1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;

Line 1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;

1863: l_pmlrulv_tbl_del OKS_PML_PVT.pmlv_tbl_type;
1864:
1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;
1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;
1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;

Line 1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;

1864:
1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;
1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;
1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;

Line 1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;

1865: -- l_pmlrulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;
1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;
1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;
1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;

Line 1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;

1866: -- l_pmlrulv_tbl_out OKC_RULE_PUB.rulv_tbl_type;
1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;
1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;
1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;
1874:

Line 1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;

1867: l_pmlrulv_tbl_ins OKS_PML_PVT.pmlv_tbl_type;
1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;
1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;
1874:
1875:

Line 1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;

1868: l_pmlrulv_tbl_ins_out OKS_PML_PVT.pmlv_tbl_type;
1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;
1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;
1874:
1875:
1876:

Line 1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;

1869: l_pmlrulv_tbl_upd OKS_PML_PVT.pmlv_tbl_type;
1870: l_pmlrulv_tbl_upd_out OKS_PML_PVT.pmlv_tbl_type;
1871: l_pmlrulv_tbl_rfr OKS_PML_PVT.pmlv_tbl_type;
1872: l_pmlrulv_tbl_start OKS_PML_PVT.pmlv_tbl_type;
1873: l_pmlrulv_tbl_end OKS_PML_PVT.pmlv_tbl_type;
1874:
1875:
1876:
1877: l_rule_act_tbl OKS_PM_PROGRAMS_PVT.rule_act_tbl;

Line 2304: oks_pml_pvt.delete_row(

2300:
2301: Raise G_EXCEPTION_HALT_VALIDATION;
2302: END IF;
2303:
2304: oks_pml_pvt.delete_row(
2305: p_api_version => l_api_version,
2306: p_init_msg_list => l_init_msg_list,
2307: x_return_status => l_return_status,
2308: x_msg_count => l_msg_count,

Line 2313: okc_debug.log('After oks_pml_pvt delete_row', 3);

2309: x_msg_data => l_msg_data,
2310: p_pmlv_tbl => l_pmlrulv_tbl_del);
2311:
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

Line 2350: oks_pml_pvt.insert_row(

2346:
2347: Raise G_EXCEPTION_HALT_VALIDATION;
2348: END IF;
2349:
2350: oks_pml_pvt.insert_row(
2351: p_api_version => l_api_version,
2352: p_init_msg_list => l_init_msg_list,
2353: x_return_status => l_return_status,
2354: x_msg_count => l_msg_count,

Line 2360: okc_debug.log('After oks_pml_pvt insert_row', 3);

2356: p_pmlv_tbl => l_pmlrulv_tbl_ins,
2357: x_pmlv_tbl => l_pmlrulv_tbl_ins_out);
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,

Line 2424: oks_pml_pvt.delete_row(

2420:
2421: END IF;
2422:
2423: IF l_pmlrulv_tbl_del.COUNT > 0 THEN
2424: oks_pml_pvt.delete_row(
2425: p_api_version => l_api_version,
2426: p_init_msg_list => l_init_msg_list,
2427: x_return_status => l_return_status,
2428: x_msg_count => l_msg_count,

Line 2433: okc_debug.log('After oks_pml_pvt delete_row', 3);

2429: x_msg_data => l_msg_data,
2430: p_pmlv_tbl => l_pmlrulv_tbl_del);
2431:
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

Line 3255: oks_pml_pvt.update_row(

3251: l_pmlrulv_tbl_upd(pml_upd_ctr) := l_pmlrulv_tbl_end(1);
3252: l_pmlrulv_tbl_upd(pml_upd_ctr).object_version_number :=l_pmlrulv_tbl_end(1).object_version_number;
3253: END IF;
3254:
3255: oks_pml_pvt.update_row(
3256: p_api_version => l_api_version,
3257: p_init_msg_list => l_init_msg_list,
3258: x_return_status => l_return_status,
3259: x_msg_count => l_msg_count,

Line 3264: okc_debug.log('After oks_pml_pvt update_row', 3);

3260: x_msg_data => l_msg_data,
3261: p_pmlv_tbl => l_pmlrulv_tbl_upd,
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,

Line 3325: oks_pml_pvt.delete_row(

3321:
3322: END IF;
3323:
3324: IF l_pmlrulv_tbl_del.COUNT > 0 THEN
3325: oks_pml_pvt.delete_row(
3326: p_api_version => l_api_version,
3327: p_init_msg_list => l_init_msg_list,
3328: x_return_status => l_return_status,
3329: x_msg_count => l_msg_count,

Line 3334: okc_debug.log('After oks_pml_pvt delete_row', 3);

3330: x_msg_data => l_msg_data,
3331: p_pmlv_tbl => l_pmlrulv_tbl_del);
3332:
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

Line 3610: oks_pml_pvt.update_row(

3606:
3607: pml_upd_ctr := pml_upd_ctr + 1;
3608: l_pmlrulv_tbl_upd(pml_upd_ctr) := l_pmlrulv_tbl_start(1);
3609:
3610: oks_pml_pvt.update_row(
3611: p_api_version => l_api_version,
3612: p_init_msg_list => l_init_msg_list,
3613: x_return_status => l_return_status,
3614: x_msg_count => l_msg_count,

Line 3619: okc_debug.log('After oks_pml_pvt update_row', 3);

3615: x_msg_data => l_msg_data,
3616: p_pmlv_tbl => l_pmlrulv_tbl_upd,
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,

Line 3696: oks_pml_pvt.update_row(

3692:
3693: pml_upd_ctr := pml_upd_ctr + 1;
3694: l_pmlrulv_tbl_upd(pml_upd_ctr) := l_pmlrulv_tbl_start(1);
3695:
3696: oks_pml_pvt.update_row(
3697: p_api_version => l_api_version,
3698: p_init_msg_list => l_init_msg_list,
3699: x_return_status => l_return_status,
3700: x_msg_count => l_msg_count,

Line 3706: okc_debug.log('After oks_pml_pvt update_row', 3);

3702: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3703: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3704:
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

Line 3765: oks_pml_pvt.delete_row(

3761:
3762: Raise G_EXCEPTION_HALT_VALIDATION;
3763: END IF;
3764:
3765: oks_pml_pvt.delete_row(
3766: p_api_version => l_api_version,
3767: p_init_msg_list => l_init_msg_list,
3768: x_return_status => l_return_status,
3769: x_msg_count => l_msg_count,

Line 3828: oks_pml_pvt.update_row(

3824: Raise G_EXCEPTION_HALT_VALIDATION;
3825: END IF;
3826:
3827:
3828: oks_pml_pvt.update_row(
3829: p_api_version => l_api_version,
3830: p_init_msg_list => l_init_msg_list,
3831: x_return_status => l_return_status,
3832: x_msg_count => l_msg_count,

Line 3925: oks_pml_pvt.update_row(

3921:
3922:
3923: END IF;
3924:
3925: oks_pml_pvt.update_row(
3926: p_api_version => l_api_version,
3927: p_init_msg_list => l_init_msg_list,
3928: x_return_status => l_return_status,
3929: x_msg_count => l_msg_count,

Line 3935: okc_debug.log('After oks_pml_pvt update_row', 3);

3931: p_pmlv_tbl => l_pmlrulv_tbl_upd,
3932: x_pmlv_tbl => l_pmlrulv_tbl_upd_out);
3933:
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

Line 4075: l_source_pml_tbl oks_pml_pvt.pmlv_tbl_type;

4071: src_pml_index NUMBER :=0;
4072: tgt_pml_index NUMBER :=0;
4073: src_pml_index1 NUMBER :=0;
4074: tgt_pml_index1 NUMBER := 0;
4075: l_source_pml_tbl oks_pml_pvt.pmlv_tbl_type;
4076: l_target_pml_tbl oks_pml_pvt.pmlv_tbl_type;
4077: l_pml_match VARCHAR2(1);
4078: G_MISMATCH EXCEPTION ;
4079:

Line 4076: l_target_pml_tbl oks_pml_pvt.pmlv_tbl_type;

4072: tgt_pml_index NUMBER :=0;
4073: src_pml_index1 NUMBER :=0;
4074: tgt_pml_index1 NUMBER := 0;
4075: l_source_pml_tbl oks_pml_pvt.pmlv_tbl_type;
4076: l_target_pml_tbl oks_pml_pvt.pmlv_tbl_type;
4077: l_pml_match VARCHAR2(1);
4078: G_MISMATCH EXCEPTION ;
4079:
4080: BEGIN

Line 4960: l_pmlv_tbl OKS_PML_PVT.pmlv_tbl_type ;

4956: CURSOR CU_GET_SCH IS
4957: SELECT ID FROM OKS_PM_SCHEDULES
4958: WHERE CLE_ID = p_cle_id;
4959: l_pmav_tbl OKS_PMA_PVT.pmav_tbl_type ;
4960: l_pmlv_tbl OKS_PML_PVT.pmlv_tbl_type ;
4961: l_pm_schedules_v_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type ;
4962: l_pma_index NUMBER :=0;
4963: l_pml_index NUMBER :=0;
4964: l_sch_index NUMBER :=0;

Line 5012: OKS_PML_PVT.delete_row(

5008: l_pmlv_tbl(l_pml_index).id:= CR_GET_PML.ID;
5009: END LOOP ;
5010:
5011: IF l_pmlv_tbl.count <> 0 then
5012: OKS_PML_PVT.delete_row(
5013: p_api_version => l_api_version,
5014: p_init_msg_list => l_init_msg_list,
5015: x_return_status => l_return_status,
5016: x_msg_count => l_msg_count,

Line 5022: okc_debug.log('After OKS_PML_PVT delete_row', 3);

5018: p_pmlv_tbl => l_pmlv_tbl);
5019: END IF ;
5020:
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;

Line 5194: l_return_Status := OKS_PML_PVT.Create_Version(

5190: l_return_Status := OKS_PMA_PVT.Create_Version(
5191: p_id => l_chr_id,
5192: p_major_version =>l_major_version);
5193:
5194: l_return_Status := OKS_PML_PVT.Create_Version(
5195: p_id => l_chr_id,
5196: p_major_version =>l_major_version);
5197:
5198: l_return_Status := OKS_PMS_PVT.Create_Version(

Line 5241: l_return_Status := OKS_PML_PVT.Restore_Version(

5237: l_return_Status := OKS_PMA_PVT.Restore_Version(
5238: p_id => l_chr_id,
5239: p_major_version =>l_major_version);
5240:
5241: l_return_Status := OKS_PML_PVT.Restore_Version(
5242: p_id => l_chr_id,
5243: p_major_version =>l_major_version);
5244:
5245: l_return_Status := OKS_PMS_PVT.Restore_Version(