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 7925: p_oks_action_times_v_tbl => l_acm_pvt_tbl_in,

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

Line 7926: x_oks_action_times_v_tbl => l_acm_pvt_tbl_out);

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

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

8424: x_act_time_tbl(1).last_update_date := OKC_API.G_MISS_DATE;
8425: x_act_time_tbl(1).last_update_login := OKC_API.G_MISS_NUM;
8426: END ;
8427: --===============================================================================
8428: PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type)
8429:
8430: IS
8431: BEGIN
8432:

Line 9026: DELETE OKS_ACTION_TIMES_H

9022:
9023: DELETE OKS_ACTION_TIME_TYPES_H
9024: WHERE dnz_chr_id = l_chr_id;
9025:
9026: DELETE OKS_ACTION_TIMES_H
9027: WHERE dnz_chr_id = l_chr_id;
9028:
9029: DELETE OKS_COVERAGE_TIMES_H
9030: WHERE dnz_chr_id = l_chr_id;

Line 9126: DELETE OKS_ACTION_TIMES_H

9122: DELETE OKS_ACTION_TIME_TYPES_H
9123: WHERE dnz_chr_id = l_chr_id
9124: And major_version = -1;
9125:
9126: DELETE OKS_ACTION_TIMES_H
9127: WHERE dnz_chr_id = l_chr_id
9128: And major_version = -1;
9129:
9130: DELETE OKS_COVERAGE_TIMES_H

Line 9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9341: -- Reaction Time --
9342: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9343: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9344:
9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9347:
9348: -- End Reaction Time --
9349:

Line 9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;

9342: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;
9343: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;
9344:
9345: l_act_time_tbl_in OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9346: l_act_time_tbl_out OKS_ACM_PVT.OKS_ACTION_TIMES_V_TBL_TYPE;
9347:
9348: -- End Reaction Time --
9349:
9350: -- Preffered Resource --

Line 9385: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIMES

9381: Where cle_id = p_id
9382: And Lse_id in (4,17);
9383:
9384: Cursor cur_act_times (p_id NUMBER) IS
9385: Select id,dnz_chr_id,object_version_number from OKS_ACTION_TIMES
9386: where COV_ACTION_TYPE_ID = p_id;
9387:
9388:
9389:

Line 9777: -- Update the oks_action_times_line

9773: End if;
9774:
9775: cnt1 :=0;
9776: -- End Update oks_action_types line
9777: -- Update the oks_action_times_line
9778: for rec_type in cur_act_time_type ( rec_react.id) LOOP
9779: for rec_time in cur_act_times (rec_type.id) LOOP
9780:
9781: If rec_time.dnz_chr_id <>p_dnz_chr_id then

Line 9797: p_oks_action_times_v_tbl => l_act_time_tbl_in,

9793: p_init_msg_list => l_init_msg_list,
9794: x_return_status => l_return_status,
9795: x_msg_count => l_msg_count,
9796: x_msg_data => l_msg_data,
9797: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9798: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9799: End if;
9800: -- End oks_action_times_line
9801: cnt1:=0;

Line 9798: x_oks_action_times_v_tbl => l_act_time_tbl_out);

9794: x_return_status => l_return_status,
9795: x_msg_count => l_msg_count,
9796: x_msg_data => l_msg_data,
9797: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9798: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9799: End if;
9800: -- End oks_action_times_line
9801: cnt1:=0;
9802: END LOOP; -- Reaction Time

Line 9800: -- End oks_action_times_line

9796: x_msg_data => l_msg_data,
9797: p_oks_action_times_v_tbl => l_act_time_tbl_in,
9798: x_oks_action_times_v_tbl => l_act_time_tbl_out);
9799: End if;
9800: -- End oks_action_times_line
9801: cnt1:=0;
9802: END LOOP; -- Reaction Time
9803: End LOOP; -- BP
9804: if cnt>0 Then