DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_CVT_PVT

Line 834: l_covtim_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;

830:
831: l_covtz_rec_in oks_ctz_pvt.OksCoverageTimezonesVRecType;
832: l_covtz_rec_out oks_ctz_pvt.OksCoverageTimezonesVRecType;
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;

Line 835: l_covtim_tbl_out oks_cvt_pvt.oks_coverage_times_v_tbl_type;

831: l_covtz_rec_in oks_ctz_pvt.OksCoverageTimezonesVRecType;
832: l_covtz_rec_out oks_ctz_pvt.OksCoverageTimezonesVRecType;
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:

Line 1394: OKS_CVT_PVT.insert_row(

1390: l_covtim_tbl_in(covtim_ctr).program_update_date := NULL;
1391: l_covtim_tbl_in(covtim_ctr).request_id := NULL;
1392: END LOOP;
1393:
1394: OKS_CVT_PVT.insert_row(
1395: p_api_version => l_api_version,
1396: p_init_msg_list => l_init_msg_list,
1397: x_return_status => l_return_status,
1398: x_msg_count => l_msg_count,

Line 1406: okc_debug.log('After OKS_CVT_PVT insert_row'||l_return_status, 2);

1402: END LOOP;
1403:
1404:
1405: IF (G_DEBUG_ENABLED = 'Y') THEN
1406: okc_debug.log('After OKS_CVT_PVT insert_row'||l_return_status, 2);
1407: END IF;
1408:
1409:
1410: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 2386: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

2382: l_scrv_tbl_in oks_Sales_Credit_pub.scrv_tbl_type;
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:

Line 2762: OKS_CVT_PVT.delete_row(

2758: END IF;
2759:
2760: IF l_cvtv_tbl_in.COUNT > 0 THEN
2761:
2762: OKS_CVT_PVT.delete_row(
2763: p_api_version =>l_api_version,
2764: p_init_msg_list =>l_init_msg_list,
2765: x_return_status =>l_return_status,
2766: x_msg_count => l_msg_count,

Line 6875: l_cover_time_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type;

6871:
6872: l_timezone_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
6873: l_timezone_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
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;

Line 6876: l_cover_time_tbl_out oks_cvt_pvt.oks_coverage_times_v_tbl_type;

6872: l_timezone_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
6873: l_timezone_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
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:

Line 7763: OKS_CVT_PVT.INSERT_ROW(p_api_version => l_api_version,

7759: END LOOP;
7760:
7761: IF l_Cover_time_tbl_in.COUNT > 0 Then
7762:
7763: OKS_CVT_PVT.INSERT_ROW(p_api_version => l_api_version,
7764: p_init_msg_list => l_init_msg_list,
7765: x_return_status => l_return_status,
7766: x_msg_count => l_msg_count,
7767: x_msg_data => l_msg_data,

Line 8376: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)

8372: x_timezone_tbl(1).REQUEST_ID := OKC_API.G_MISS_NUM;
8373:
8374: END ;
8375: --=================================================================================
8376: PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type)
8377:
8378: IS
8379: BEGIN
8380: x_cover_time_tbl(1).ID := OKC_API.G_MISS_NUM;

Line 8833: l_return_Status := OKS_CVT_PVT.Create_Version(

8829:
8830: IF l_return_Status <> 'S' THEN
8831: RAISE G_EXCEPTION_HALT_VALIDATION;
8832: END IF;
8833: l_return_Status := OKS_CVT_PVT.Create_Version(
8834: p_id => l_chr_id,
8835: p_major_version =>l_major_version);
8836:
8837: IF l_return_Status <> 'S' THEN

Line 8936: l_return_Status := OKS_CVT_PVT.Restore_Version(

8932:
8933: IF l_return_Status <> 'S' THEN
8934: RAISE G_EXCEPTION_HALT_VALIDATION;
8935: END IF;
8936: l_return_Status := OKS_CVT_PVT.Restore_Version(
8937: p_id => l_chr_id,
8938: p_major_version =>l_major_version);
8939:
8940: IF l_return_Status <> 'S' THEN

Line 9337: l_cov_time_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

9333:
9334: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9335: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9336:
9337: l_cov_time_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9338: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9339: -- END
9340:
9341: -- Reaction Time --

Line 9338: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

9334: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9335: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9336:
9337: l_cov_time_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
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;

Line 10072: OKS_CVT_PVT.update_row(

10068: End LOOP;
10069: End LOOP;
10070: End LOOP;
10071: --If cnt>0 Then
10072: OKS_CVT_PVT.update_row(
10073: p_api_version => l_api_version,
10074: p_init_msg_list => l_init_msg_list,
10075: x_return_status => l_return_status,
10076: x_msg_count => l_msg_count,