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 8354: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)

8350: x_klnv_tbl(1).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
8351: END ;
8352:
8353: --================================================================================
8354: PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType)
8355: IS
8356:
8357: BEGIN
8358: x_timezone_tbl(1).ID := OKC_API.G_MISS_NUM;

Line 8840: l_return_Status := OKS_CTZ_PVT.Create_Version(

8836:
8837: IF l_return_Status <> 'S' THEN
8838: RAISE G_EXCEPTION_HALT_VALIDATION;
8839: END IF;
8840: l_return_Status := OKS_CTZ_PVT.Create_Version(
8841: p_id => l_chr_id,
8842: p_major_version =>l_major_version);
8843: IF l_return_Status <> 'S' THEN
8844: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 8943: l_return_Status := OKS_CTZ_PVT.Restore_Version(

8939:
8940: IF l_return_Status <> 'S' THEN
8941: RAISE G_EXCEPTION_HALT_VALIDATION;
8942: END IF;
8943: l_return_Status := OKS_CTZ_PVT.Restore_Version(
8944: p_id => l_chr_id,
8945: p_major_version =>l_major_version);
8946:
8947: IF l_return_Status <> 'S' THEN

Line 9334: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;

9330: -- OKS_K_LINES_B
9331: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type ;
9332: l_klnv_tbl_out oks_contract_line_pub.klnv_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;

Line 9335: l_timezone_tbl_out OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;

9331: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type ;
9332: l_klnv_tbl_out oks_contract_line_pub.klnv_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

Line 10045: OKS_CTZ_PVT.UPDATE_ROW(

10041: End LOOP;
10042: End LOOP;
10043: if cnt>0 then
10044:
10045: OKS_CTZ_PVT.UPDATE_ROW(
10046: p_api_version => l_api_version,
10047: p_init_msg_list => l_init_msg_list,
10048: x_return_status => l_return_status,
10049: x_msg_count => l_msg_count,