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_PM_SCHEDULES_V

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 164: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,

160: p_init_msg_list => l_init_msg_list,
161: x_return_status => l_return_status ,
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

Line 165: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);

161: x_return_status => l_return_status ,
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 ;

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

558: p_init_msg_list => l_init_msg_list,
559: x_return_status => l_return_status,
560: x_msg_count => l_msg_count,
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;

Line 563: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);

559: x_return_status => l_return_status,
560: x_msg_count => l_msg_count,
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

Line 623: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,

619: p_init_msg_list => l_init_msg_list,
620: x_return_status => l_return_status,
621: x_msg_count => l_msg_count,
622: x_msg_data => l_msg_data,
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

Line 624: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);

620: x_return_status => l_return_status,
621: x_msg_count => l_msg_count,
622: x_msg_data => l_msg_data,
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

Line 872: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,

868: p_init_msg_list => l_init_msg_list,
869: x_return_status => l_return_status,
870: x_msg_count => l_msg_count,
871: x_msg_data => l_msg_data,
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);

Line 873: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);

869: x_return_status => l_return_status,
870: x_msg_count => l_msg_count,
871: x_msg_data => l_msg_data,
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;

Line 926: p_oks_pm_schedules_v_tbl => l_pmschvtbl_In,

922: p_init_msg_list => l_init_msg_list,
923: x_return_status => l_return_status,
924: x_msg_count => l_msg_count,
925: x_msg_data => l_msg_data,
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

Line 927: x_oks_pm_schedules_v_tbl => l_pmschvtbl_Out);

923: x_return_status => l_return_status,
924: x_msg_count => l_msg_count,
925: x_msg_data => l_msg_data,
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

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 1499: p_oks_pm_schedules_v_tbl => l_sch_tbl,

1495: p_init_msg_list => l_init_msg_list,
1496: x_return_status => l_return_status ,
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

Line 1500: x_oks_pm_schedules_v_tbl =>l_sch_tbl_out);

1496: x_return_status => l_return_status ,
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,

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 2289: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);

2285: p_init_msg_list => l_init_msg_list,
2286: x_return_status => l_return_status,
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:

Line 2333: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

2329: p_init_msg_list => l_init_msg_list,
2330: x_return_status => l_return_status,
2331: x_msg_count => l_msg_count,
2332: x_msg_data => l_msg_data,
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);

Line 2334: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

2330: x_return_status => l_return_status,
2331: x_msg_count => l_msg_count,
2332: x_msg_data => l_msg_data,
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;

Line 2407: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);

2403: p_init_msg_list => l_init_msg_list,
2404: x_return_status => l_return_status,
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

Line 2592: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

2588: p_init_msg_list => l_init_msg_list,
2589: x_return_status => l_return_status,
2590: x_msg_count => l_msg_count,
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;

Line 2593: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

2589: x_return_status => l_return_status,
2590: x_msg_count => l_msg_count,
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:

Line 2647: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

2643: p_init_msg_list => l_init_msg_list,
2644: x_return_status => l_return_status,
2645: x_msg_count => l_msg_count,
2646: x_msg_data => l_msg_data,
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);

Line 2648: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

2644: x_return_status => l_return_status,
2645: x_msg_count => l_msg_count,
2646: x_msg_data => l_msg_data,
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;

Line 2824: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

2820: p_init_msg_list => l_init_msg_list,
2821: x_return_status => l_return_status,
2822: x_msg_count => l_msg_count,
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;

Line 2825: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

2821: x_return_status => l_return_status,
2822: x_msg_count => l_msg_count,
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

Line 2899: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

2895: p_init_msg_list => l_init_msg_list,
2896: x_return_status => l_return_status,
2897: x_msg_count => l_msg_count,
2898: x_msg_data => l_msg_data,
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);

Line 2900: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

2896: x_return_status => l_return_status,
2897: x_msg_count => l_msg_count,
2898: x_msg_data => l_msg_data,
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;

Line 2946: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

2942: p_init_msg_list => l_init_msg_list,
2943: x_return_status => l_return_status,
2944: x_msg_count => l_msg_count,
2945: x_msg_data => l_msg_data,
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);

Line 2947: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

2943: x_return_status => l_return_status,
2944: x_msg_count => l_msg_count,
2945: x_msg_data => l_msg_data,
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;

Line 3046: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

3042: p_init_msg_list => l_init_msg_list,
3043: x_return_status => l_return_status,
3044: x_msg_count => l_msg_count,
3045: x_msg_data => l_msg_data,
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);

Line 3047: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

3043: x_return_status => l_return_status,
3044: x_msg_count => l_msg_count,
3045: x_msg_data => l_msg_data,
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;

Line 3102: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3098: p_init_msg_list => l_init_msg_list,
3099: x_return_status => l_return_status,
3100: x_msg_count => l_msg_count,
3101: x_msg_data => l_msg_data,
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);

Line 3103: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3099: x_return_status => l_return_status,
3100: x_msg_count => l_msg_count,
3101: x_msg_data => l_msg_data,
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;

Line 3193: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3189: p_init_msg_list => l_init_msg_list,
3190: x_return_status => l_return_status,
3191: x_msg_count => l_msg_count,
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;

Line 3194: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3190: x_return_status => l_return_status,
3191: x_msg_count => l_msg_count,
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

Line 3308: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);

3304: p_init_msg_list => l_init_msg_list,
3305: x_return_status => l_return_status,
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

Line 3388: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3384: p_init_msg_list => l_init_msg_list,
3385: x_return_status => l_return_status,
3386: x_msg_count => l_msg_count,
3387: x_msg_data => l_msg_data,
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);

Line 3389: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3385: x_return_status => l_return_status,
3386: x_msg_count => l_msg_count,
3387: x_msg_data => l_msg_data,
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;

Line 3555: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

3551: p_init_msg_list => l_init_msg_list,
3552: x_return_status => l_return_status,
3553: x_msg_count => l_msg_count,
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;

Line 3556: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

3552: x_return_status => l_return_status,
3553: x_msg_count => l_msg_count,
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

Line 3576: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3572: p_init_msg_list => l_init_msg_list,
3573: x_return_status => l_return_status,
3574: x_msg_count => l_msg_count,
3575: x_msg_data => l_msg_data,
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);

Line 3577: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3573: x_return_status => l_return_status,
3574: x_msg_count => l_msg_count,
3575: x_msg_data => l_msg_data,
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;

Line 3663: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3659: p_init_msg_list => l_init_msg_list,
3660: x_return_status => l_return_status,
3661: x_msg_count => l_msg_count,
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;

Line 3664: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3660: x_return_status => l_return_status,
3661: x_msg_count => l_msg_count,
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:

Line 3749: p_oks_pm_schedules_v_tbl => l_pmschvtbl_Del);

3745: p_init_msg_list => l_init_msg_list,
3746: x_return_status => l_return_status,
3747: x_msg_count => l_msg_count,
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;

Line 3812: p_oks_pm_schedules_v_tbl => l_pmschvtbl_upd,

3808: p_init_msg_list => l_init_msg_list,
3809: x_return_status => l_return_status,
3810: x_msg_count => l_msg_count,
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;

Line 3813: x_oks_pm_schedules_v_tbl => l_pmschvtbl_upd_out);

3809: x_return_status => l_return_status,
3810: x_msg_count => l_msg_count,
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

Line 3906: p_oks_pm_schedules_v_tbl => l_pmschvtbl_ins,

3902: p_init_msg_list => l_init_msg_list,
3903: x_return_status => l_return_status,
3904: x_msg_count => l_msg_count,
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;

Line 3907: x_oks_pm_schedules_v_tbl => l_pmschvtbl_ins_out);

3903: x_return_status => l_return_status,
3904: x_msg_count => l_msg_count,
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:

Line 4648: oks_pm_schedules_v pms

4644: CURSOR l_sch_csr(p_cle_id IN NUMBER) IS
4645:
4646: SELECT pms.id
4647: FROM okc_k_lines_b cle,
4648: oks_pm_schedules_v pms
4649: WHERE cle.id = pms.cle_id
4650: and cle.cle_id=p_cle_id
4651: --added condition
4652: and pms.activity_line_id is null;

Line 4657: FROM oks_pm_schedules_v pms

4653: */
4654: CURSOR l_sch_csr(p_cle_id IN NUMBER) IS
4655:
4656: SELECT pms.id
4657: FROM oks_pm_schedules_v pms
4658: WHERE pms.cle_id = p_cle_id
4659: --added condition
4660: and pms.activity_line_id is null;
4661:

Line 4683: oks_pm_schedules_v pms

4679: /* Modified by JVorugan for Bug:5215180
4680: CURSOR l_actsch_csr(p_cle_id IN NUMBER) IS
4681: SELECT pms.id
4682: FROM okc_k_lines_b cle,
4683: oks_pm_schedules_v pms
4684: WHERE cle.id = pms.cle_id
4685: and cle.cle_id=p_cle_id
4686: and activity_line_id is not null;
4687: */

Line 4690: FROM oks_pm_schedules_v pms

4686: and activity_line_id is not null;
4687: */
4688: CURSOR l_actsch_csr(p_cle_id IN NUMBER) IS
4689: SELECT pms.id
4690: FROM oks_pm_schedules_v pms
4691: WHERE pms.cle_id = p_cle_id
4692: and activity_line_id is not null;
4693:
4694:

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 5044: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);

5040: p_init_msg_list => l_init_msg_list,
5041: x_return_status => l_return_status,
5042: x_msg_count => l_msg_count,
5043: x_msg_data => l_msg_data,
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);