833:
834: l_covtim_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;
835: l_covtim_tbl_out oks_cvt_pvt.oks_coverage_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;
834: l_covtim_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;
835: l_covtim_tbl_out oks_cvt_pvt.oks_coverage_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:
1518: l_act_type_tbl_in(1).cle_id := crt_cle_id; --l_rt_cle_id ;
1519: l_act_type_tbl_in(1).dnz_chr_id := g_chr_id;
1520: l_act_type_tbl_in(1).action_type_code := act_type_rec.action_type_code;
1521:
1522: OKS_ACT_PVT.INSERT_ROW(p_api_version => l_api_version,
1523: p_init_msg_list => l_init_msg_list,
1524: x_return_status => l_return_status,
1525: x_msg_count => l_msg_count,
1526: x_msg_data => l_msg_data,
1527: p_oks_action_time_types_v_tbl => l_act_type_tbl_in,
1528: x_oks_action_time_types_v_tbl => l_act_type_tbl_out);
1529:
1530: IF (G_DEBUG_ENABLED = 'Y') THEN
1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);
1532: END IF;
1533:
1534:
1535:
2383:
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:
2819: END IF;
2820:
2821: IF l_actv_tbl_in.COUNT > 0 THEN
2822:
2823: OKS_ACT_PVT.delete_row(
2824: p_api_version => l_api_version,
2825: p_init_msg_list => l_init_msg_list,
2826: x_return_status => l_return_status,
2827: x_msg_count => l_msg_count,
2834: return;
2835: END IF;
2836:
2837: IF (G_DEBUG_ENABLED = 'Y') THEN
2838: okc_debug.log('AFTER OKS_ACT_PVT delete_row', 2);
2839:
2840: END IF;
2841:
2842: END IF;
6874:
6875: l_cover_time_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;
6876: l_cover_time_tbl_out oks_cvt_pvt.oks_coverage_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;
6875: l_cover_time_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;
6876: l_cover_time_tbl_out oks_cvt_pvt.oks_coverage_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:
7873: l_act_pvt_tbl_in(k).DNZ_CHR_ID := l_new_dnz_chr_id ; --Get_Old_Act_Time_Types_Rec.Dnz_Chr_ID;
7874: l_act_pvt_tbl_in(k).ACTION_TYPE_CODE :=Get_Old_Act_Time_Types_Rec.ACTION_TYPE_CODE;
7875: l_act_pvt_tbl_in(k).OBJECT_VERSION_NUMBER := Get_Old_Act_Time_Types_Rec.OBJECT_VERSION_NUMBER;
7876:
7877: oks_act_pvt.insert_row(
7878: p_api_version => l_api_version,
7879: p_init_msg_list => l_init_msg_list,
7880: x_return_status => l_return_status,
7881: x_msg_count => l_msg_count,
7883: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,
7884: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);
7885:
7886: IF (G_DEBUG_ENABLED = 'Y') THEN
7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7888: END IF;
7889:
7890: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7891: RAISE G_EXCEPTION_HALT_VALIDATION;
8404:
8405: END ;
8406: --==========================================================================
8407:
8408: PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType)
8409: IS
8410: BEGIN
8411:
8412: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;
8815:
8816: BEGIN
8817:
8818:
8819: l_return_Status := OKS_ACT_PVT.Create_Version(
8820: p_id => l_chr_id,
8821: p_major_version =>l_major_version);
8822:
8823: IF l_return_Status <> 'S' THEN
8917:
8918: BEGIN
8919:
8920:
8921: l_return_Status := OKS_ACT_PVT.Restore_Version(
8922: p_id => l_chr_id,
8923: p_major_version =>l_major_version);
8924:
8925: IF l_return_Status <> 'S' THEN
9338: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9339: -- END
9340:
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;
9339: -- END
9340:
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:
9761:
9762: End if;
9763: End LOOP;
9764: If cnt1>0 Then
9765: OKS_ACT_PVT.Update_ROW(
9766: p_api_version => l_api_version,
9767: p_init_msg_list => l_init_msg_list,
9768: x_return_status => l_return_status,
9769: x_msg_count => l_msg_count,