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 9359: -- OKs_Pm_schedules

9355: -- OKs_Pm_stream_levels
9356: l_pmlv_tbl_in OKS_PML_PVT.PMLV_TBL_TYPE;
9357: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9358: -- Oks_pm_stream_levels
9359: -- OKs_Pm_schedules
9360: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9361: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9362: -- Oks_Pm_schedules
9363: -- OKS_PM_ACTIVITIES --

Line 9360: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;

9356: l_pmlv_tbl_in OKS_PML_PVT.PMLV_TBL_TYPE;
9357: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9358: -- Oks_pm_stream_levels
9359: -- OKs_Pm_schedules
9360: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9361: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9362: -- Oks_Pm_schedules
9363: -- OKS_PM_ACTIVITIES --
9364: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;

Line 9361: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;

9357: l_pmlv_tbl_out OKS_PML_PVT.PMLV_TBL_TYPE;
9358: -- Oks_pm_stream_levels
9359: -- OKs_Pm_schedules
9360: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9361: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9362: -- Oks_Pm_schedules
9363: -- OKS_PM_ACTIVITIES --
9364: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;
9365: l_pmav_tbl_out OKS_PMA_PVT.pmav_tbl_type;

Line 9362: -- Oks_Pm_schedules

9358: -- Oks_pm_stream_levels
9359: -- OKs_Pm_schedules
9360: l_pms_tbl_in oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9361: l_pms_tbl_out oks_pms_pvt.oks_pm_schedules_v_tbl_type;
9362: -- Oks_Pm_schedules
9363: -- OKS_PM_ACTIVITIES --
9364: l_pmav_tbl_in OKS_PMA_PVT.pmav_tbl_type;
9365: l_pmav_tbl_out OKS_PMA_PVT.pmav_tbl_type;
9366: -- OKS_PM_ACTIVITIES --

Line 9479: from OKS_PM_SCHEDULES

9475: Where cle_id=p_id;
9476:
9477: cursor cur_pm_sch (p_id NUMBER) IS
9478: Select id , dnz_chr_id,OBJECT_VERSION_NUMBER
9479: from OKS_PM_SCHEDULES
9480: Where cle_id=p_id;
9481:
9482: Cursor cur_pm_stream (p_id NUMBER) IS
9483: Select id,dnz_chr_id ,OBJECT_VERSION_NUMBER

Line 9583: -- OKS_PM_SCHEDULES --

9579: cnt :=cnt+1;
9580: End if;
9581: End LOOP;
9582: If cnt>0 Then
9583: -- OKS_PM_SCHEDULES --
9584: OKS_PMS_PVT.update_row(
9585: p_api_version => l_api_version,
9586: p_init_msg_list => l_init_msg_list,
9587: x_return_status => l_return_status,

Line 9590: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,

9586: p_init_msg_list => l_init_msg_list,
9587: x_return_status => l_return_status,
9588: x_msg_count => l_msg_count ,
9589: x_msg_data => l_msg_data ,
9590: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
9591: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
9592: End IF;
9593:
9594: cnt :=0;

Line 9591: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);

9587: x_return_status => l_return_status,
9588: x_msg_count => l_msg_count ,
9589: x_msg_data => l_msg_data ,
9590: p_oks_pm_schedules_v_tbl => l_pms_tbl_in,
9591: x_oks_pm_schedules_v_tbl =>l_pms_tbl_out);
9592: End IF;
9593:
9594: cnt :=0;
9595: For rec_stream in cur_pm_stream (l_coverage_id) LOOP