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_ACTION_TIMES

Line 751: FROM OKS_ACTION_TIMES

747: WED_DURATION,
748: THU_DURATION,
749: FRI_DURATION,
750: SAT_DURATION
751: FROM OKS_ACTION_TIMES
752: WHERE cov_action_type_id = p_cov_act_type_id ;
753: -------------------------------------------------------------------------------
754: -- Fix for Bug:4703431. Modified by jvorugan
755: CURSOR CUR_GET_ORG_ID(p_contract_id IN NUMBER) is

Line 840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

836:
837: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
838: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
839:
840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;
842:
843: covtim_ctr NUMBER := 0;
844: acttim_ctr NUMBER := 0;

Line 841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;

837: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
838: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
839:
840: l_act_time_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
841: l_act_time_tbl_out OKS_ACM_PVT.oks_action_times_v_tbl_type;
842:
843: covtim_ctr NUMBER := 0;
844: acttim_ctr NUMBER := 0;
845: l_cov_templ_yn VARCHAR2(1) := 'Y';

Line 1566: p_oks_action_times_v_tbl => l_act_time_tbl_in,

1562: p_init_msg_list => l_init_msg_list,
1563: x_return_status => l_return_status,
1564: x_msg_count => l_msg_count,
1565: x_msg_data => l_msg_data,
1566: p_oks_action_times_v_tbl => l_act_time_tbl_in,
1567: x_oks_action_times_v_tbl => l_act_time_tbl_out);
1568:
1569: IF (G_DEBUG_ENABLED = 'Y') THEN
1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

Line 1567: x_oks_action_times_v_tbl => l_act_time_tbl_out);

1563: x_return_status => l_return_status,
1564: x_msg_count => l_msg_count,
1565: x_msg_data => l_msg_data,
1566: p_oks_action_times_v_tbl => l_act_time_tbl_in,
1567: x_oks_action_times_v_tbl => l_act_time_tbl_out);
1568:
1569: IF (G_DEBUG_ENABLED = 'Y') THEN
1570: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
1571: END IF;

Line 2351: FROM OKS_ACTION_TIMES

2347: AND dnz_chr_id =p_dnz_chr_id;
2348:
2349: CURSOR Action_times_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2350: SELECT ID,DNZ_CHR_ID
2351: FROM OKS_ACTION_TIMES
2352: WHERE COV_ACTION_TYPE_ID = p_id
2353: AND dnz_chr_id =p_dnz_chr_id;
2354:
2355: CURSOR Bill_Rate_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS

Line 2388: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

2384: l_klev_tbl_in oks_kln_pvt.klnv_tbl_type;
2385: l_tzev_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType;
2386: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
2387: l_actv_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
2388: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
2389: l_brsv_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;
2390:
2391:
2392: l_api_version CONSTANT NUMBER := 1.0;

Line 2807: p_oks_action_times_v_tbl => l_acmv_tbl_in);

2803: p_init_msg_list => l_init_msg_list,
2804: x_return_status => l_return_status,
2805: x_msg_count => l_msg_count,
2806: x_msg_data => l_msg_data,
2807: p_oks_action_times_v_tbl => l_acmv_tbl_in);
2808:
2809:
2810: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2811: return;

Line 4536: OKS_ACTION_TIMES acm

4532: NVL(acm.sat_duration,0) sat_duration
4533: FROM OKC_K_LINES_B lines,
4534: OKS_K_LINES_V oksl,
4535: OKS_ACTION_TIME_TYPES act,
4536: OKS_ACTION_TIMES acm
4537: WHERE lines.cle_id = p_cle_id
4538: AND lines.lse_id IN (4,17,22)
4539: AND oksl.cle_id = lines.id
4540: AND act.cle_id = lines.id

Line 6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;

6877:
6878: l_act_pvt_tbl_in oks_act_pvt.OksActionTimeTypesVTblType;
6879: l_act_pvt_tbl_out oks_act_pvt.OksActionTimeTypesVTblType;
6880:
6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;
6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;
6883:
6884: l_new_Bp_line_Id NUMBER := NULL;
6885: l_new_TimeZone_Id NUMBER := NULL;

Line 6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;

6878: l_act_pvt_tbl_in oks_act_pvt.OksActionTimeTypesVTblType;
6879: l_act_pvt_tbl_out oks_act_pvt.OksActionTimeTypesVTblType;
6880:
6881: l_acm_pvt_tbl_in oks_acm_pvt.oks_action_times_v_tbl_type;
6882: l_acm_pvt_tbl_out oks_acm_pvt.oks_action_times_v_tbl_type;
6883:
6884: l_new_Bp_line_Id NUMBER := NULL;
6885: l_new_TimeZone_Id NUMBER := NULL;
6886: l_new_contract_line_id NUMBER;

Line 7133: FROM OKS_ACTION_TIMES

7129: FRI_DURATION,
7130: SAT_DURATION,
7131: SECURITY_GROUP_ID,
7132: OBJECT_VERSION_NUMBER
7133: FROM OKS_ACTION_TIMES
7134: WHERE COV_ACTION_TYPE_ID = p_act_pvt_ID
7135: AND DNZ_CHR_ID = P_Act_Dnz_Chr_ID;
7136:
7137: -- Get Old And new Billing Types

Line 7921: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,

7917: p_init_msg_list => l_init_msg_list,
7918: x_return_status => l_return_status,
7919: x_msg_count => l_msg_count,
7920: x_msg_data => l_msg_data,
7921: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,
7922: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);
7923:
7924: IF (G_DEBUG_ENABLED = 'Y') THEN
7925: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);

Line 7922: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);

7918: x_return_status => l_return_status,
7919: x_msg_count => l_msg_count,
7920: x_msg_data => l_msg_data,
7921: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,
7922: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);
7923:
7924: IF (G_DEBUG_ENABLED = 'Y') THEN
7925: okc_debug.log('After OKS_ACM_PVT insert_row'||l_return_status, 2);
7926: END IF;

Line 8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)

8414: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8415: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8416: END ;
8417: --===============================================================================
8418: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8419:
8420: IS
8421: BEGIN
8422:

Line 9016: DELETE OKS_ACTION_TIMES_H

9012:
9013: DELETE OKS_ACTION_TIME_TYPES_H
9014: WHERE dnz_chr_id = l_chr_id;
9015:
9016: DELETE OKS_ACTION_TIMES_H
9017: WHERE dnz_chr_id = l_chr_id;
9018:
9019: DELETE OKS_COVERAGE_TIMES_H
9020: WHERE dnz_chr_id = l_chr_id;

Line 9116: DELETE OKS_ACTION_TIMES_H

9112: DELETE OKS_ACTION_TIME_TYPES_H
9113: WHERE dnz_chr_id = l_chr_id
9114: And major_version = -1;
9115:
9116: DELETE OKS_ACTION_TIMES_H
9117: WHERE dnz_chr_id = l_chr_id
9118: And major_version = -1;
9119:
9120: DELETE OKS_COVERAGE_TIMES_H

Line 9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9331: -- Reaction Time --
9332: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9333: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9334:
9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9337:
9338: -- End Reaction Time --
9339:

Line 9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9332: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9333: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9334:
9335: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9336: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9337:
9338: -- End Reaction Time --
9339:
9340: -- Preffered Resource --

Line 9375: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIMES

9371: Where cle_id = p_id
9372: And Lse_id in (4,17);
9373:
9374: Cursor cur_act_times (p_id NUMBER) IS
9375: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIMES
9376: where COV_ACTION_TYPE_ID = p_id;
9377:
9378:
9379:

Line 9767: -- Update the oks_action_times_line

9763: End if;
9764:
9765: cnt1 :=0;
9766: -- End Update oks_action_types line
9767: -- Update the oks_action_times_line
9768: for rec_type in cur_act_time_type ( rec_react.id) LOOP
9769: for rec_time in cur_act_times (rec_type.id) LOOP
9770:
9771: If rec_time.dnz_chr_id <>p_dnz_chr_id then

Line 9787: p_oks_action_times_v_tbl => l_act_time_tbl_in,

9783: p_init_msg_list => l_init_msg_list,
9784: x_return_status => l_return_status,
9785: x_msg_count => l_msg_count,
9786: x_msg_data => l_msg_data,
9787: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9788: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9789: End if;
9790: -- End oks_action_times_line
9791: cnt1:=0;

Line 9788: x_oks_action_times_v_tbl => l_act_time_tbl_out);

9784: x_return_status => l_return_status,
9785: x_msg_count => l_msg_count,
9786: x_msg_data => l_msg_data,
9787: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9788: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9789: End if;
9790: -- End oks_action_times_line
9791: cnt1:=0;
9792: END LOOP; -- Reaction Time

Line 9790: -- End oks_action_times_line

9786: x_msg_data => l_msg_data,
9787: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9788: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9789: End if;
9790: -- End oks_action_times_line
9791: cnt1:=0;
9792: END LOOP; -- Reaction Time
9793: End LOOP; -- BP
9794: if cnt>0 Then