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 7873: oks_act_pvt.insert_row(

7869: l_act_pvt_tbl_in(k).DNZ_CHR_ID := l_new_dnz_chr_id ; --Get_Old_Act_Time_Types_Rec.Dnz_Chr_ID;
7870: l_act_pvt_tbl_in(k).ACTION_TYPE_CODE :=Get_Old_Act_Time_Types_Rec.ACTION_TYPE_CODE;
7871: l_act_pvt_tbl_in(k).OBJECT_VERSION_NUMBER := Get_Old_Act_Time_Types_Rec.OBJECT_VERSION_NUMBER;
7872:
7873: oks_act_pvt.insert_row(
7874: p_api_version => l_api_version,
7875: p_init_msg_list => l_init_msg_list,
7876: x_return_status => l_return_status,
7877: x_msg_count => l_msg_count,

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

7879: p_oks_action_time_types_v_tbl => l_act_pvt_tbl_in,
7880: x_oks_action_time_types_v_tbl => l_act_pvt_tbl_out);
7881:
7882: IF (G_DEBUG_ENABLED = 'Y') THEN
7883: okc_debug.log('After oks_act_pvt insert_row'||l_return_status, 2);
7884: END IF;
7885:
7886: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7887: RAISE G_EXCEPTION_HALT_VALIDATION;

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

8394:
8395: END ;
8396: --==========================================================================
8397:
8398: PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType)
8399: IS
8400: BEGIN
8401:
8402: x_act_time_tbl(1).id := OKC_API.G_MISS_NUM;

Line 8809: l_return_Status := OKS_ACT_PVT.Create_Version(

8805:
8806: BEGIN
8807:
8808:
8809: l_return_Status := OKS_ACT_PVT.Create_Version(
8810: p_id => l_chr_id,
8811: p_major_version =>l_major_version);
8812:
8813: IF l_return_Status <> 'S' THEN

Line 8911: l_return_Status := OKS_ACT_PVT.Restore_Version(

8907:
8908: BEGIN
8909:
8910:
8911: l_return_Status := OKS_ACT_PVT.Restore_Version(
8912: p_id => l_chr_id,
8913: p_major_version =>l_major_version);
8914:
8915: IF l_return_Status <> 'S' THEN

Line 9332: l_act_type_tbl_in OKS_ACT_PVT.OksActionTimeTypesVTblType;

9328: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9329: -- END
9330:
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;

Line 9333: l_act_type_tbl_out OKS_ACT_PVT.OksActionTimeTypesVTblType;

9329: -- END
9330:
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:

Line 9755: OKS_ACT_PVT.Update_ROW(

9751:
9752: End if;
9753: End LOOP;
9754: If cnt1>0 Then
9755: OKS_ACT_PVT.Update_ROW(
9756: p_api_version => l_api_version,
9757: p_init_msg_list => l_init_msg_list,
9758: x_return_status => l_return_status,
9759: x_msg_count => l_msg_count,