DBA Data[Home] [Help]

APPS.OKS_PM_PROGRAMS_PVT dependencies on OKS_PMA_PVT

Line 330: l_pmarulv_tbl_out oks_pma_pvt.pmav_tbl_type;

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

Line 334: l_pmarulvrec_Out oks_pma_pvt.pmav_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;
337:
338:

Line 335: l_pmarulvrec_In oks_pma_pvt.pmav_rec_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;
337:
338:
339: l_Rule_Id NUMBER;

Line 336: l_pmarulv_tbl oks_pma_pvt.pmav_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;
337:
338:
339: l_Rule_Id NUMBER;
340: l_pmlrulv_tbl oks_pml_pvt.pmlv_tbl_type;

Line 653: /*CK 09/27 oks_pma_pvt.insert_row(

649: l_pmarulv_tbl(pma_ctr).CLE_ID := p_cle_id;
650: l_pmarulv_tbl(pma_ctr).DNZ_CHR_ID := l_chr_id;
651: --
652:
653: /*CK 09/27 oks_pma_pvt.insert_row(
654: p_api_version => l_api_version,
655: p_init_msg_list => l_init_msg_list,
656: x_return_status =>l_return_status,
657: x_msg_count =>l_msg_count,

Line 686: oks_pma_pvt.insert_row(

682:
683: EXIT WHEN cu_act_stream_levels%NOTFOUND;
684: END LOOP;
685: CLOSE cu_act_stream_levels;
686: oks_pma_pvt.insert_row(
687: p_api_version => l_api_version,
688: p_init_msg_list => l_init_msg_list,
689: x_return_status =>l_return_status,
690: x_msg_count =>l_msg_count,

Line 695: okc_debug.log('After oks_pma_pvt insert_row', 3);

691: x_msg_data =>l_msg_data,
692: p_pmav_rec =>l_pmarulv_tbl(pma_ctr),
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

Line 890: oks_pma_pvt.update_row(

886: Raise G_EXCEPTION_HALT_VALIDATION;
887: END IF;
888:
889: /*ck 09/27
890: oks_pma_pvt.update_row(
891: p_api_version => l_api_version,
892: p_init_msg_list => l_init_msg_list,
893: x_return_status =>l_return_status,
894: x_msg_count =>l_msg_count,

Line 1393: l_pmarulv_rec oks_pma_pvt.pmav_rec_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';
1397: l_return_status VARCHAR2(1);

Line 1394: l_pmarulv_rec_out oks_pma_pvt.pmav_rec_type;

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';
1397: l_return_status VARCHAR2(1);
1398: l_msg_count NUMBER;

Line 1517: oks_pma_pvt.update_row(

1513: CLOSE cu_obj_version;
1514: l_pmarulv_rec.id :=p_pma_tbl(l_pma_index).activity_line_id;
1515: l_pmarulv_rec.SCH_EXISTS_YN := 'Y';
1516: l_pmarulv_rec.OBJECT_VERSION_NUMBER:=l_object_version_number;
1517: oks_pma_pvt.update_row(
1518: p_api_version => l_api_version,
1519: p_init_msg_list => l_init_msg_list,
1520: x_return_status =>l_return_status,
1521: x_msg_count =>l_msg_count,

Line 4205: l_source_pma_tbl oks_pma_pvt.pmav_tbl_type;

4201: tgt_pma_index NUMBER :=0;
4202: src_pma_index1 NUMBER :=0;
4203: tgt_pma_index1 NUMBER :=0;
4204:
4205: l_source_pma_tbl oks_pma_pvt.pmav_tbl_type;
4206: l_target_pma_tbl oks_pma_pvt.pmav_tbl_type;
4207:
4208: G_MISMATCH EXCEPTION ;
4209: --07/28/2004

Line 4206: l_target_pma_tbl oks_pma_pvt.pmav_tbl_type;

4202: src_pma_index1 NUMBER :=0;
4203: tgt_pma_index1 NUMBER :=0;
4204:
4205: l_source_pma_tbl oks_pma_pvt.pmav_tbl_type;
4206: l_target_pma_tbl oks_pma_pvt.pmav_tbl_type;
4207:
4208: G_MISMATCH EXCEPTION ;
4209: --07/28/2004
4210: l_pma_match VARCHAR2(1);

Line 4959: l_pmav_tbl OKS_PMA_PVT.pmav_tbl_type ;

4955:
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;

Line 4987: OKS_PMA_PVT.delete_row(

4983: l_pmav_tbl(l_pma_index).id:= CR_GET_PMA.ID;
4984: END LOOP ;
4985:
4986: IF l_pmav_tbl.count <> 0 then
4987: OKS_PMA_PVT.delete_row(
4988: p_api_version => l_api_version,
4989: p_init_msg_list => l_init_msg_list,
4990: x_return_status => l_return_status,
4991: x_msg_count => l_msg_count,

Line 4996: okc_debug.log('After OKS_PMA_PVT delete_row', 3);

4992: x_msg_data => l_msg_data,
4993: p_pmav_tbl => l_pmav_tbl);
4994: END IF ;
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;

Line 5190: l_return_Status := OKS_PMA_PVT.Create_Version(

5186:
5187: BEGIN
5188:
5189:
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(

Line 5237: l_return_Status := OKS_PMA_PVT.Restore_Version(

5233:
5234: BEGIN
5235:
5236:
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(