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_PMS_PVT

Line 127: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;

123: oks_pm_schedules pms
124: where
125: rule_information_category ='PML'
126: and pml.id =pms.rule_id;
127: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
128: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'V_POPULATE_ACTIVITIES';
131:

Line 128: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;

124: where
125: rule_information_category ='PML'
126: and pml.id =pms.rule_id;
127: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
128: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'V_POPULATE_ACTIVITIES';
131:
132: l_return_status VARCHAR2(1);

Line 158: OKS_PMS_PVT.update_row(

154: l_pms_tbl_in(ctr).id := cr_pm_schedule.id;
155: l_pms_tbl_in(ctr).pmp_rule_id := cr_pm_schedule.pmp_rule_id;
156: ctr := ctr+1;
157: END LOOP;
158: OKS_PMS_PVT.update_row(
159: p_api_version => l_api_version,
160: p_init_msg_list => l_init_msg_list,
161: x_return_status => l_return_status ,
162: x_msg_count => l_msg_count ,

Line 331: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

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: --
334: l_pmarulvrec_Out oks_pma_pvt.pmav_rec_type;
335: l_pmarulvrec_In oks_pma_pvt.pmav_rec_type;

Line 332: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

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: --
334: l_pmarulvrec_Out oks_pma_pvt.pmav_rec_type;
335: l_pmarulvrec_In oks_pma_pvt.pmav_rec_type;
336: l_pmarulv_tbl oks_pma_pvt.pmav_tbl_type;

Line 556: OKS_PMS_PVT.insert_row

552: l_pmschvtbl_In(j).schedule_date_to := NULL;
553: l_pmschvtbl_In(j).stream_line_id := l_pmlrulvrec_Out.id;
554: END LOOP;
555: -- Insert program schedules
556: OKS_PMS_PVT.insert_row
557: (p_api_version => l_api_version,
558: p_init_msg_list => l_init_msg_list,
559: x_return_status => l_return_status,
560: x_msg_count => l_msg_count,

Line 565: okc_debug.log('After OKS_PMS_PVT insert_row', 3);

561: x_msg_data => l_msg_data,
562: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
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

Line 617: OKS_PMS_PVT.insert_row

613: exit;
614: END IF;
615: END LOOP;
616: /*CK RUL -- Insert program schedules
617: OKS_PMS_PVT.insert_row
618: (p_api_version => l_api_version,
619: p_init_msg_list => l_init_msg_list,
620: x_return_status => l_return_status,
621: x_msg_count => l_msg_count,

Line 866: OKS_PMS_PVT.insert_row

862: l_pmschvtbl_In(j).schedule_date_to := NULL;
863: l_pmschvtbl_In(j).stream_line_id := l_pmlrulvrec_Out.id;
864: l_pmschvtbl_In(j).activity_line_id := l_pmarulvrec_Out.id;
865: END LOOP;
866: OKS_PMS_PVT.insert_row
867: (p_api_version => l_api_version,
868: p_init_msg_list => l_init_msg_list,
869: x_return_status => l_return_status,
870: x_msg_count => l_msg_count,

Line 876: okc_debug.log('After act OKS_PMS_PVT insert_row', 3);

872: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,
873: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);
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

Line 920: OKS_PMS_PVT.insert_row

916:
917: pma_ctr :=pma_ctr+1;
918: END LOOP;
919: /* -- Insert act schedules
920: OKS_PMS_PVT.insert_row
921: (p_api_version => l_api_version,
922: p_init_msg_list => l_init_msg_list,
923: x_return_status => l_return_status,
924: x_msg_count => l_msg_count,

Line 986: x_pmschv_tbl OUT NOCOPY pmsch_refresh_tbl_type)-- OKS_PMS_PVT.oks_pm_schedules_v_tbl_type)

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;
990: l_api_version CONSTANT NUMBER := 1.0;

Line 995: l_pmschvtbl_In pmsch_refresh_tbl_type; --OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

991: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
992: l_return_status VARCHAR2(1);
993: l_msg_count NUMBER;
994: l_msg_data VARCHAR2(4000):='msg_data: ';
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;

Line 1387: p_sch_tbl IN OKS_PMS_PVT.oks_pm_schedules_v_tbl_type,

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
1391: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;

Line 1403: l_sch_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

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;
1407: l_pma_index NUMBER;

Line 1404: l_sch_tbl_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

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;
1407: l_pma_index NUMBER;
1408: l_sch_index NUMBER;

Line 1493: OKS_PMS_PVT.insert_row(

1489: END IF;
1490: l_sch_indexin := l_sch_indexin +1;
1491:
1492: END LOOP;
1493: OKS_PMS_PVT.insert_row(
1494: p_api_version => l_api_version,
1495: p_init_msg_list => l_init_msg_list,
1496: x_return_status => l_return_status ,
1497: x_msg_count => l_msg_count ,

Line 1909: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1905: l_msg_count NUMBER;
1906: l_msg_data VARCHAR2(2000):=null;
1907: -- l_pmprulvrec_Out OKC_RULE_PUB.rulv_rec_type;
1908: -- l_pmlrulvrec_Out OKC_RULE_PUB.rulv_rec_type;
1909: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1906: l_msg_data VARCHAR2(2000):=null;
1907: -- l_pmprulvrec_Out OKC_RULE_PUB.rulv_rec_type;
1908: -- l_pmlrulvrec_Out OKC_RULE_PUB.rulv_rec_type;
1909: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1908: -- l_pmlrulvrec_Out OKC_RULE_PUB.rulv_rec_type;
1909: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1909: l_pmschvtbl_In OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1910: l_pmschvtbl_Out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1911: l_cov_rec okc_contract_pub.clev_rec_type;
1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1912: l_pmschvtbl_Del OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

Line 1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1913: l_pmschvtbl_Upd OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1921:

Line 1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1914: l_pmschvtbl_Upd_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1921:
1922:

Line 1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1915: l_pmschvrec_prv OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1921:
1922:
1923:

Line 1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;

1916: l_pmschv_start OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1917: l_pmschv_end OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1918: l_pmschvtbl_Ins OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1919: l_pmschvtbl_Ins_out OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1920: l_pmschv_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type;
1921:
1922:
1923:
1924: l_Rule_Id NUMBER;

Line 2283: OKS_PMS_PVT.delete_row(

2279: END LOOP;
2280:
2281: END IF;
2282:
2283: OKS_PMS_PVT.delete_row(
2284: p_api_version => l_api_version,
2285: p_init_msg_list => l_init_msg_list,
2286: x_return_status => l_return_status,
2287: x_msg_count => l_msg_count,

Line 2291: okc_debug.log('After oks_pms_pvt delete_row', 3);

2287: x_msg_count => l_msg_count,
2288: x_msg_data => l_msg_data,
2289: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
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

Line 2327: OKS_PMS_PVT.insert_row(

2323: Raise G_EXCEPTION_HALT_VALIDATION;
2324: END IF;
2325:
2326:
2327: OKS_PMS_PVT.insert_row(
2328: p_api_version => l_api_version,
2329: p_init_msg_list => l_init_msg_list,
2330: x_return_status => l_return_status,
2331: x_msg_count => l_msg_count,

Line 2337: okc_debug.log('After oks_pms_pvt insert_row', 3);

2333: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2334: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2335:
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

Line 2401: OKS_PMS_PVT.delete_row(

2397: END LOOP;
2398:
2399: IF l_pmschvtbl_Del.COUNT > 0 THEN
2400:
2401: OKS_PMS_PVT.delete_row(
2402: p_api_version => l_api_version,
2403: p_init_msg_list => l_init_msg_list,
2404: x_return_status => l_return_status,
2405: x_msg_count => l_msg_count,

Line 2409: okc_debug.log('After oks_pms_pvt delete_row', 3);

2405: x_msg_count => l_msg_count,
2406: x_msg_data => l_msg_data,
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,

Line 2586: OKS_PMS_PVT.insert_row(

2582:
2583:
2584: IF l_pmschvtbl_ins.COUNT > 0 THEN
2585:
2586: OKS_PMS_PVT.insert_row(
2587: p_api_version => l_api_version,
2588: p_init_msg_list => l_init_msg_list,
2589: x_return_status => l_return_status,
2590: x_msg_count => l_msg_count,

Line 2595: okc_debug.log('After oks_pms_pvt insert_row', 3);

2591: x_msg_data => l_msg_data,
2592: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2593: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
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

Line 2641: OKS_PMS_PVT.update_row(

2637: l_pmschvtbl_Upd(pms_upd_ctr).schedule_date_to := trunc(p_new_end_date);
2638: END IF;
2639:
2640: IF l_pmschvtbl_Upd.COUNT > 0 THEN
2641: OKS_PMS_PVT.update_row(
2642: p_api_version => l_api_version,
2643: p_init_msg_list => l_init_msg_list,
2644: x_return_status => l_return_status,
2645: x_msg_count => l_msg_count,

Line 2651: okc_debug.log('After oks_pms_pvt update_row', 3);

2647: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
2648: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
2649:
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

Line 2818: OKS_PMS_PVT.insert_row(

2814:
2815:
2816: IF l_pmschvtbl_ins.COUNT > 0 THEN
2817:
2818: OKS_PMS_PVT.insert_row(
2819: p_api_version => l_api_version,
2820: p_init_msg_list => l_init_msg_list,
2821: x_return_status => l_return_status,
2822: x_msg_count => l_msg_count,

Line 2827: okc_debug.log('After oks_pms_pvt insert_row', 3);

2823: x_msg_data => l_msg_data,
2824: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
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,

Line 2893: OKS_PMS_PVT.insert_row(

2889:
2890:
2891: IF l_pmschvtbl_Ins.COUNT > 0 THEN
2892:
2893: OKS_PMS_PVT.insert_row(
2894: p_api_version => l_api_version,
2895: p_init_msg_list => l_init_msg_list,
2896: x_return_status => l_return_status,
2897: x_msg_count => l_msg_count,

Line 2903: okc_debug.log('After oks_pms_pvt insert_row', 3);

2899: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
2900: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
2901:
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

Line 2940: OKS_PMS_PVT.update_row(

2936:
2937: END LOOP;
2938:
2939: IF l_pmschvtbl_Upd.COUNT > 0 THEN
2940: OKS_PMS_PVT.update_row(
2941: p_api_version => l_api_version,
2942: p_init_msg_list => l_init_msg_list,
2943: x_return_status => l_return_status,
2944: x_msg_count => l_msg_count,

Line 2950: okc_debug.log('After oks_pms_pvt update_row', 3);

2946: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
2947: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
2948:
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

Line 3040: OKS_PMS_PVT.insert_row(

3036:
3037:
3038: IF l_pmschvtbl_Ins.COUNT > 0 THEN
3039:
3040: OKS_PMS_PVT.insert_row(
3041: p_api_version => l_api_version,
3042: p_init_msg_list => l_init_msg_list,
3043: x_return_status => l_return_status,
3044: x_msg_count => l_msg_count,

Line 3050: okc_debug.log('After oks_pms_pvt insert_row', 3);

3046: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
3047: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
3048:
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

Line 3096: OKS_PMS_PVT.update_row(

3092: END IF;
3093:
3094:
3095: IF l_pmschvtbl_Upd.COUNT > 0 THEN
3096: OKS_PMS_PVT.update_row(
3097: p_api_version => l_api_version,
3098: p_init_msg_list => l_init_msg_list,
3099: x_return_status => l_return_status,
3100: x_msg_count => l_msg_count,

Line 3106: okc_debug.log('After oks_pms_pvt update_row', 3);

3102: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3103: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
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,

Line 3187: OKS_PMS_PVT.update_row(

3183: END IF;
3184:
3185:
3186: IF l_pmschvtbl_Upd.COUNT > 0 THEN
3187: OKS_PMS_PVT.update_row(
3188: p_api_version => l_api_version,
3189: p_init_msg_list => l_init_msg_list,
3190: x_return_status => l_return_status,
3191: x_msg_count => l_msg_count,

Line 3196: okc_debug.log('After oks_pms_pvt update_row', 3);

3192: x_msg_data => l_msg_data,
3193: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
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,

Line 3302: OKS_PMS_PVT.delete_row(

3298: END LOOP;
3299: END LOOP;
3300:
3301: IF l_pmschvtbl_Del.COUNT > 0 THEN
3302: OKS_PMS_PVT.delete_row(
3303: p_api_version => l_api_version,
3304: p_init_msg_list => l_init_msg_list,
3305: x_return_status => l_return_status,
3306: x_msg_count => l_msg_count,

Line 3310: okc_debug.log('After oks_pms_pvt delete_row', 3);

3306: x_msg_count => l_msg_count,
3307: x_msg_data => l_msg_data,
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,

Line 3382: OKS_PMS_PVT.update_row(

3378: EXIT;
3379: END IF;
3380: END LOOP;
3381:
3382: OKS_PMS_PVT.update_row(
3383: p_api_version => l_api_version,
3384: p_init_msg_list => l_init_msg_list,
3385: x_return_status => l_return_status,
3386: x_msg_count => l_msg_count,

Line 3392: okc_debug.log('After oks_pms_pvt update_row', 3);

3388: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3389: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
3390:
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

Line 3549: OKS_PMS_PVT.insert_row(

3545: -1*(to_number(l_pmlrulv_tbl_start(1).frequency))));
3546:
3547: END LOOP;
3548:
3549: OKS_PMS_PVT.insert_row(
3550: p_api_version => l_api_version,
3551: p_init_msg_list => l_init_msg_list,
3552: x_return_status => l_return_status,
3553: x_msg_count => l_msg_count,

Line 3558: okc_debug.log('After oks_pms_pvt insert_row', 3);

3554: x_msg_data => l_msg_data,
3555: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
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,

Line 3570: OKS_PMS_PVT.update_row(

3566:
3567: Raise G_EXCEPTION_HALT_VALIDATION;
3568: END IF;
3569:
3570: OKS_PMS_PVT.update_row(
3571: p_api_version => l_api_version,
3572: p_init_msg_list => l_init_msg_list,
3573: x_return_status => l_return_status,
3574: x_msg_count => l_msg_count,

Line 3580: okc_debug.log('After oks_pms_pvt update_row', 3);

3576: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3577: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
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,

Line 3657: OKS_PMS_PVT.update_row(

3653: EXIT;
3654: END IF;
3655: END LOOP;
3656:
3657: OKS_PMS_PVT.update_row(
3658: p_api_version => l_api_version,
3659: p_init_msg_list => l_init_msg_list,
3660: x_return_status => l_return_status,
3661: x_msg_count => l_msg_count,

Line 3666: okc_debug.log('After oks_pms_pvt update_row', 3);

3662: x_msg_data => l_msg_data,
3663: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
3664: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);
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

Line 3743: OKS_PMS_PVT.delete_row(

3739: END IF;
3740: END LOOP;
3741: END LOOP;
3742:
3743: OKS_PMS_PVT.delete_row(
3744: p_api_version => l_api_version,
3745: p_init_msg_list => l_init_msg_list,
3746: x_return_status => l_return_status,
3747: x_msg_count => l_msg_count,

Line 3752: okc_debug.log('After oks_pms_pvt delete_row', 3);

3748: x_msg_data => l_msg_data,
3749: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);
3750:
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

Line 3806: OKS_PMS_PVT.update_row(

3802: END IF;
3803:
3804:
3805:
3806: OKS_PMS_PVT.update_row(
3807: p_api_version => l_api_version,
3808: p_init_msg_list => l_init_msg_list,
3809: x_return_status => l_return_status,
3810: x_msg_count => l_msg_count,

Line 3815: okc_debug.log('After oks_pms_pvt update_row', 3);

3811: x_msg_data => l_msg_data,
3812: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,
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,

Line 3900: OKS_PMS_PVT.insert_row(

3896:
3897: l_next_sch_date := NULL;
3898:
3899:
3900: OKS_PMS_PVT.insert_row(
3901: p_api_version => l_api_version,
3902: p_init_msg_list => l_init_msg_list,
3903: x_return_status => l_return_status,
3904: x_msg_count => l_msg_count,

Line 3909: okc_debug.log('After oks_pms_pvt insert_row', 3);

3905: x_msg_data => l_msg_data,
3906: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,
3907: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);
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

Line 4961: l_pm_schedules_v_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type ;

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;
4965: l_api_version CONSTANT NUMBER := 1.0;

Line 5038: OKS_PMS_PVT.delete_row(

5034: l_pm_schedules_v_tbl(l_sch_index).id:= CR_GET_SCH.ID;
5035: END LOOP ;
5036:
5037: IF l_pm_schedules_v_tbl.count <> 0 then
5038: OKS_PMS_PVT.delete_row(
5039: p_api_version => l_api_version,
5040: p_init_msg_list => l_init_msg_list,
5041: x_return_status => l_return_status,
5042: x_msg_count => l_msg_count,

Line 5048: okc_debug.log('After OKS_PMS_PVT delete_row', 3);

5044: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);
5045: END IF ;
5046:
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;

Line 5198: l_return_Status := OKS_PMS_PVT.Create_Version(

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(
5199: p_id => l_chr_id,
5200: p_major_version =>l_major_version);
5201:
5202: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 5245: l_return_Status := OKS_PMS_PVT.Restore_Version(

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(
5246: p_id => l_chr_id,
5247: p_major_version =>l_major_version);
5248:
5249: x_return_status := OKC_API.G_RET_STS_SUCCESS;