DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_CTZ_PVT

Line 828: l_covtz_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;

824:
825: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
826: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
827:
828: l_covtz_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
829: l_covtz_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
830:
831: l_covtz_rec_in oks_ctz_pvt.OksCoverageTimezonesVRecType;
832: l_covtz_rec_out oks_ctz_pvt.OksCoverageTimezonesVRecType;

Line 829: l_covtz_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;

825: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
826: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
827:
828: l_covtz_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
829: l_covtz_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
830:
831: l_covtz_rec_in oks_ctz_pvt.OksCoverageTimezonesVRecType;
832: l_covtz_rec_out oks_ctz_pvt.OksCoverageTimezonesVRecType;
833:

Line 831: l_covtz_rec_in oks_ctz_pvt.OksCoverageTimezonesVRecType;

827:
828: l_covtz_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
829: l_covtz_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
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;

Line 832: l_covtz_rec_out oks_ctz_pvt.OksCoverageTimezonesVRecType;

828: l_covtz_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
829: l_covtz_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;
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:

Line 1347: OKS_CTZ_PVT.insert_row(

1343: l_covtz_tbl_in(1).cle_id := txg_cle_id;
1344: l_covtz_tbl_in(1).default_yn := cov_tz_rec.default_yn;
1345: l_covtz_tbl_in(1).timezone_id := cov_tz_rec.timezone_id;
1346: l_covtz_tbl_in(1).dnz_chr_id := g_chr_id;
1347: OKS_CTZ_PVT.insert_row(
1348: p_api_version => l_api_version,
1349: p_init_msg_list => l_init_msg_list,
1350: x_return_status => l_return_status,
1351: x_msg_count => l_msg_count,

Line 1358: okc_debug.log('After OKS_CTZ_PVT insert_row'||l_return_status, 2);

1354: x_oks_coverage_timezones_v_tbl => l_covtz_tbl_out);
1355:
1356:
1357: IF (G_DEBUG_ENABLED = 'Y') THEN
1358: okc_debug.log('After OKS_CTZ_PVT insert_row'||l_return_status, 2);
1359: END IF;
1360:
1361:
1362: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 2385: l_tzev_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType;

2381: l_codv_tbl_in oks_Order_Details_pub.codv_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;

Line 2778: OKS_CTZ_PVT.delete_row(

2774: END IF;
2775: END IF;
2776:
2777: IF l_tzev_tbl_in.COUNT > 0 THEN
2778: OKS_CTZ_PVT.delete_row(
2779: p_api_version => l_api_version,
2780: p_init_msg_list => l_init_msg_list,
2781: x_return_status => l_return_status,
2782: x_msg_count => l_msg_count,

Line 2794: okc_debug.log('AFTER OKS_CTZ_PVT delete_row', 2);

2790:
2791: END IF;
2792:
2793: IF (G_DEBUG_ENABLED = 'Y') THEN
2794: okc_debug.log('AFTER OKS_CTZ_PVT delete_row', 2);
2795:
2796: END IF;
2797:
2798:

Line 6872: l_timezone_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;

6868: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
6869: l_billrate_sch_tbl_in oks_brs_pvt.OksBillrateSchedulesVTblType;
6870: l_billrate_sch_tbl_out oks_brs_pvt.OksBillrateSchedulesVTblType;
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;

Line 6873: l_timezone_tbl_out oks_ctz_pvt.OksCoverageTimezonesVTblType;

6869: l_billrate_sch_tbl_in oks_brs_pvt.OksBillrateSchedulesVTblType;
6870: l_billrate_sch_tbl_out oks_brs_pvt.OksBillrateSchedulesVTblType;
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:

Line 7716: OKS_CTZ_PVT.INSERT_ROW(p_api_version => l_api_version,

7712: l_timezone_tbl_in(m).DNZ_CHR_ID := l_new_dnz_chr_id;
7713:
7714:
7715: -- create the time zone record here
7716: OKS_CTZ_PVT.INSERT_ROW(p_api_version => l_api_version,
7717: p_init_msg_list => l_init_msg_list,
7718: x_return_status => l_return_status,
7719: x_msg_count => l_msg_count,
7720: x_msg_data => l_msg_data,

Line 7726: okc_debug.log('After OKS_CTZ_PVT INSERT_ROW'||l_return_status, 2);

7722: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);
7723:
7724:
7725: IF (G_DEBUG_ENABLED = 'Y') THEN
7726: okc_debug.log('After OKS_CTZ_PVT INSERT_ROW'||l_return_status, 2);
7727: END IF;
7728:
7729: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
7730: IF l_timezone_tbl_out.COUNT > 0 THEN

Line 8344: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)

8340: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8341: END ;
8342:
8343: --================================================================================
8344: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8345: IS
8346:
8347: BEGIN
8348: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;

Line 8830: l_return_Status := OKS_CTZ_PVT.Create_Version(

8826:
8827: IF l_return_Status <> 'S' THEN
8828: RAISE G_EXCEPTION_HALT_VALIDATION;
8829: END IF;
8830: l_return_Status := OKS_CTZ_PVT.Create_Version(
8831: p_id => l_chr_id,
8832: p_major_version =>l_major_version);
8833: IF l_return_Status <> 'S' THEN
8834: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8933: l_return_Status := OKS_CTZ_PVT.Restore_Version(

8929:
8930: IF l_return_Status <> 'S' THEN
8931: RAISE G_EXCEPTION_HALT_VALIDATION;
8932: END IF;
8933: l_return_Status := OKS_CTZ_PVT.Restore_Version(
8934: p_id => l_chr_id,
8935: p_major_version =>l_major_version);
8936:
8937: IF l_return_Status <> 'S' THEN

Line 9324: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;

9320: -- OKS_K_LINES_B
9321: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type ;
9322: l_klnv_tbl_out oks_contract_line_pub.klnv_tbl_type ;
9323:
9324: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9325: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9326:
9327: l_cov_time_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9328: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

Line 9325: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;

9321: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type ;
9322: l_klnv_tbl_out oks_contract_line_pub.klnv_tbl_type ;
9323:
9324: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9325: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;
9326:
9327: l_cov_time_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9328: l_cov_time_tbl_out OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
9329: -- END

Line 10035: OKS_CTZ_PVT.UPDATE_ROW(

10031: End LOOP;
10032: End LOOP;
10033: if cnt>0 then
10034:
10035: OKS_CTZ_PVT.UPDATE_ROW(
10036: p_api_version => l_api_version,
10037: p_init_msg_list => l_init_msg_list,
10038: x_return_status => l_return_status,
10039: x_msg_count => l_msg_count,