DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_ACT_PVT

Line 837: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;

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;

Line 838: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;

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:

Line 1522: OKS_ACT_PVT.INSERT_ROW(p_api_version => l_api_version,

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,

Line 1531: okc_debug.log('After OKS_ACT_PVT INSERT_ROW'||l_return_status, 2);

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:

Line 2387: l_actv_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;

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:

Line 2823: OKS_ACT_PVT.delete_row(

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,

Line 2838: okc_debug.log('AFTER OKS_ACT_PVT delete_row', 2);

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;

Line 6878: l_act_pvt_tbl_in oks_act_pvt.OksActionTimeTypesVTblType;

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;

Line 6879: l_act_pvt_tbl_out oks_act_pvt.OksActionTimeTypesVTblType;

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:

Line 7877: oks_act_pvt.insert_row(

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,

Line 7887: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);

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;

Line 8408: PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType)

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;

Line 8819: l_return_Status := OKS_ACT_PVT.Create_Version(

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

Line 8921: l_return_Status := OKS_ACT_PVT.Restore_Version(

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

Line 9342: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;

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;

Line 9343: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;

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:

Line 9765: OKS_ACT_PVT.Update_ROW(

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,