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_COVERAGES_PVT dependencies on OKS_PM_SCHEDULES

Line 2279: SELECT ID FROM OKS_PM_SCHEDULES

2275: WHERE cod_Id = P_cod_Id;
2276:
2277: --03/16/04 chkrishn removed for rules rearchitecture
2278: /* CURSOR CUR_GET_SCH(p_cov_id IN NUMBER) IS
2279: SELECT ID FROM OKS_PM_SCHEDULES
2280: WHERE CLE_ID = p_cov_id;
2281:
2282: l_pm_schedules_v_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type ;
2283: l_sch_index NUMBER := 0;*/

Line 2282: l_pm_schedules_v_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type ;

2278: /* CURSOR CUR_GET_SCH(p_cov_id IN NUMBER) IS
2279: SELECT ID FROM OKS_PM_SCHEDULES
2280: WHERE CLE_ID = p_cov_id;
2281:
2282: l_pm_schedules_v_tbl OKS_PMS_PVT.oks_pm_schedules_v_tbl_type ;
2283: l_sch_index NUMBER := 0;*/
2284:
2285: CURSOR CUR_GET_BRS_ID(p_service_line_id IN NUMBER) IS
2286: SELECT BRS.ID BRS_LINE_ID

Line 3083: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);

3079: p_init_msg_list => l_init_msg_list,
3080: x_return_status => l_return_status,
3081: x_msg_count => l_msg_count,
3082: x_msg_data => l_msg_data,
3083: p_oks_pm_schedules_v_tbl => l_pm_schedules_v_tbl);
3084: END IF ;
3085:
3086: IF NOT nvl(l_return_status,'S') = OKC_API.G_RET_STS_SUCCESS THEN
3087: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 9369: -- OKs_Pm_schedules

9365: -- OKs_Pm_stream_levels
9366: l_pmlv_tbl_in OKS_PML_PVT.PMLV_TBL_TYPE;
9367: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9368: -- Oks_pm_stream_levels
9369: -- OKs_Pm_schedules
9370: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9371: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9372: -- Oks_Pm_schedules
9373: -- OKS_PM_ACTIVITIES --

Line 9370: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;

9366: l_pmlv_tbl_in OKS_PML_PVT.PMLV_TBL_TYPE;
9367: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9368: -- Oks_pm_stream_levels
9369: -- OKs_Pm_schedules
9370: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9371: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9372: -- Oks_Pm_schedules
9373: -- OKS_PM_ACTIVITIES --
9374: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;

Line 9371: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;

9367: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9368: -- Oks_pm_stream_levels
9369: -- OKs_Pm_schedules
9370: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9371: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9372: -- Oks_Pm_schedules
9373: -- OKS_PM_ACTIVITIES --
9374: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;
9375: l_pmav_tbl_out OKS_PMA_PVT.pmav_tbl_type;

Line 9372: -- Oks_Pm_schedules

9368: -- Oks_pm_stream_levels
9369: -- OKs_Pm_schedules
9370: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9371: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9372: -- Oks_Pm_schedules
9373: -- OKS_PM_ACTIVITIES --
9374: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;
9375: l_pmav_tbl_out OKS_PMA_PVT.pmav_tbl_type;
9376: -- OKS_PM_ACTIVITIES --

Line 9489: from OKS_PM_SCHEDULES

9485: Where cle_id=p_id;
9486:
9487: cursor cur_pm_sch (p_id NUMBER) IS
9488: Select id , dnz_chr_id,OBJECT_VERSION_NUMBER
9489: from OKS_PM_SCHEDULES
9490: Where cle_id=p_id;
9491:
9492: Cursor cur_pm_stream (p_id NUMBER) IS
9493: Select id,dnz_chr_id ,OBJECT_VERSION_NUMBER

Line 9593: -- OKS_PM_SCHEDULES --

9589: cnt :=cnt+1;
9590: End if;
9591: End LOOP;
9592: If cnt>0 Then
9593: -- OKS_PM_SCHEDULES --
9594: OKS_PMS_PVT.update_row(
9595: p_api_version => l_api_version,
9596: p_init_msg_list => l_init_msg_list,
9597: x_return_status => l_return_status,

Line 9600: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,

9596: p_init_msg_list => l_init_msg_list,
9597: x_return_status => l_return_status,
9598: x_msg_count => l_msg_count ,
9599: x_msg_data => l_msg_data ,
9600: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
9601: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
9602: End IF;
9603:
9604: cnt :=0;

Line 9601: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);

9597: x_return_status => l_return_status,
9598: x_msg_count => l_msg_count ,
9599: x_msg_data => l_msg_data ,
9600: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
9601: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
9602: End IF;
9603:
9604: cnt :=0;
9605: For rec_stream in cur_pm_stream (l_coverage_id) LOOP