eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COVERAGES_PVT dependencies on OKS_COVERAGE_TIMES

Line 729: FROM oks_coverage_times

725: ,THURSDAY_YN
726: ,FRIDAY_YN
727: ,SATURDAY_YN
728: ,SUNDAY_YN
729: FROM oks_coverage_times
730: WHERE COV_TZE_LINE_ID = p_cov_tz_id;
731: -------------------------------------------------------------------------------
732:
733:

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 1400: p_oks_coverage_times_v_tbl => l_covtim_tbl_in,

1396: p_init_msg_list => l_init_msg_list,
1397: x_return_status => l_return_status,
1398: x_msg_count => l_msg_count,
1399: x_msg_data => l_msg_data,
1400: p_oks_coverage_times_v_tbl => l_covtim_tbl_in,
1401: x_oks_coverage_times_v_tbl => l_covtim_tbl_out);
1402: END LOOP;
1403:
1404:

Line 1401: x_oks_coverage_times_v_tbl => l_covtim_tbl_out);

1397: x_return_status => l_return_status,
1398: x_msg_count => l_msg_count,
1399: x_msg_data => l_msg_data,
1400: p_oks_coverage_times_v_tbl => l_covtim_tbl_in,
1401: x_oks_coverage_times_v_tbl => l_covtim_tbl_out);
1402: END LOOP;
1403:
1404:
1405: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2339: FROM OKS_COVERAGE_TIMES

2335:
2336:
2337: CURSOR Cov_Time_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2338: SELECT ID,DNZ_CHR_ID
2339: FROM OKS_COVERAGE_TIMES
2340: WHERE COV_TZE_LINE_ID = p_id
2341: AND dnz_chr_id =p_dnz_chr_id;
2342:
2343: CURSOR Action_type_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS

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 2768: p_oks_coverage_times_v_tbl =>l_cvtv_tbl_in);

2764: p_init_msg_list =>l_init_msg_list,
2765: x_return_status =>l_return_status,
2766: x_msg_count => l_msg_count,
2767: x_msg_data => l_msg_data,
2768: p_oks_coverage_times_v_tbl =>l_cvtv_tbl_in);
2769:
2770:
2771:
2772: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 4500: OKS_COVERAGE_TIMES covtm

4496: covtm.sunday_yn sunday_yn
4497: FROM OKC_K_LINES_B lines,
4498: OKC_K_ITEMS items,
4499: OKS_COVERAGE_TIMEZONES covtz,
4500: OKS_COVERAGE_TIMES covtm
4501: WHERE lines.id = p_id
4502: AND lines.lse_id IN (3,16,21)
4503: AND lines.dnz_chr_id = items.dnz_chr_id
4504: AND items.cle_id = lines.id

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 7396: FROM OKS_COVERAGE_TIMES TIMES

7392: times.friday_yn friday_yn,
7393: times.saturday_yn saturday_yn,
7394: times.sunday_yn sunday_yn,
7395: times.object_version_number object_version_number
7396: FROM OKS_COVERAGE_TIMES TIMES
7397: WHERE TIMES.COV_TZE_LINE_ID = p_cle_id
7398: AND TIMES.DNZ_CHR_ID = p_dnz_chr_id;
7399:
7400: CURSOR CUR_GET_NEW_BUSI_PROC_ID(p_cle_id IN NUMBER, p_busi_proc_id IN NUMBER)

Line 7768: p_oks_coverage_times_v_tbl => l_cover_time_tbl_in,

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,
7768: p_oks_coverage_times_v_tbl => l_cover_time_tbl_in,
7769: x_oks_coverage_times_v_tbl => l_cover_time_tbl_out);
7770:
7771: END IF;
7772:

Line 7769: x_oks_coverage_times_v_tbl => l_cover_time_tbl_out);

7765: x_return_status => l_return_status,
7766: x_msg_count => l_msg_count,
7767: x_msg_data => l_msg_data,
7768: p_oks_coverage_times_v_tbl => l_cover_time_tbl_in,
7769: x_oks_coverage_times_v_tbl => l_cover_time_tbl_out);
7770:
7771: END IF;
7772:
7773: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

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 8486: FROM OKS_COVERAGE_TIMES_V

8482: CURSOR Cur_monday(l_tze_id IN NUMBER) IS
8483:
8484: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8485: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8486: FROM OKS_COVERAGE_TIMES_V
8487: WHERE COV_TZE_LINE_ID = l_tze_id
8488: AND MONDAY_YN = 'Y' ;
8489:
8490:

Line 8495: FROM OKS_COVERAGE_TIMES_V

8491:
8492: CURSOR Cur_tuesday(l_tze_id IN NUMBER) IS
8493: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8494: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8495: FROM OKS_COVERAGE_TIMES_V
8496: WHERE COV_TZE_LINE_ID = l_tze_id
8497: AND TUESDAY_YN = 'Y' ;
8498:
8499:

Line 8503: FROM OKS_COVERAGE_TIMES_V

8499:
8500: CURSOR Cur_wednesday(l_tze_id IN NUMBER) IS
8501: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8502: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8503: FROM OKS_COVERAGE_TIMES_V
8504: WHERE COV_TZE_LINE_ID = l_tze_id
8505: AND WEDNESDAY_YN = 'Y' ;
8506:
8507:

Line 8511: FROM OKS_COVERAGE_TIMES_V

8507:
8508: CURSOR Cur_thursday(l_tze_id IN NUMBER) IS
8509: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8510: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8511: FROM OKS_COVERAGE_TIMES_V
8512: WHERE COV_TZE_LINE_ID = l_tze_id
8513: AND THURSDAY_YN = 'Y' ;
8514:
8515:

Line 8519: FROM OKS_COVERAGE_TIMES_V

8515:
8516: CURSOR Cur_friday(l_tze_id IN NUMBER) IS
8517: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8518: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8519: FROM OKS_COVERAGE_TIMES_V
8520: WHERE COV_TZE_LINE_ID = l_tze_id
8521: AND FRIDAY_YN = 'Y' ;
8522:
8523:

Line 8528: FROM OKS_COVERAGE_TIMES_V

8524:
8525: CURSOR Cur_saturday(l_tze_id IN NUMBER) IS
8526: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8527: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8528: FROM OKS_COVERAGE_TIMES_V
8529: WHERE COV_TZE_LINE_ID = l_tze_id
8530: AND SATURDAY_YN = 'Y' ;
8531:
8532:

Line 8536: FROM OKS_COVERAGE_TIMES_V

8532:
8533: CURSOR Cur_sunday(l_tze_id IN NUMBER) IS
8534: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
8535: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
8536: FROM OKS_COVERAGE_TIMES_V
8537: WHERE COV_TZE_LINE_ID = l_tze_id
8538: AND SUNDAY_YN = 'Y' ;
8539:
8540: --Define cursors for other days.

Line 9029: DELETE OKS_COVERAGE_TIMES_H

9025:
9026: DELETE OKS_ACTION_TIMES_H
9027: WHERE dnz_chr_id = l_chr_id;
9028:
9029: DELETE OKS_COVERAGE_TIMES_H
9030: WHERE dnz_chr_id = l_chr_id;
9031:
9032: DELETE OKS_COVERAGE_TIMEZONES_H
9033: WHERE dnz_chr_id = l_chr_id;

Line 9130: DELETE OKS_COVERAGE_TIMES_H

9126: DELETE OKS_ACTION_TIMES_H
9127: WHERE dnz_chr_id = l_chr_id
9128: And major_version = -1;
9129:
9130: DELETE OKS_COVERAGE_TIMES_H
9131: WHERE dnz_chr_id = l_chr_id
9132: And major_version = -1;
9133:
9134: DELETE OKS_COVERAGE_TIMEZONES_H

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 9407: SELECT id,dnz_chr_id,object_version_number from OKS_COVERAGE_TIMES

9403: CURSOR csr_TZ_id(l_cle_id NUMBER) IS
9404: SELECT id,dnz_chr_id,object_version_number from OKS_COVERAGE_TIMEZONES
9405: WHERE cle_id = l_cle_id;
9406: CURSOR csr_Times_id(l_cle_id NUMBER) IS
9407: SELECT id,dnz_chr_id,object_version_number from OKS_COVERAGE_TIMES
9408: WHERE cov_tze_line_id = l_cle_id;
9409:
9410: -- End Time Zone --
9411:

Line 10078: p_oks_coverage_times_v_tbl => l_cov_time_tbl_in,

10074: p_init_msg_list => l_init_msg_list,
10075: x_return_status => l_return_status,
10076: x_msg_count => l_msg_count,
10077: x_msg_data => l_msg_data,
10078: p_oks_coverage_times_v_tbl => l_cov_time_tbl_in,
10079: x_oks_coverage_times_v_tbl =>l_cov_time_tbl_out);
10080: -- End if;
10081: -- End Times --
10082:

Line 10079: x_oks_coverage_times_v_tbl =>l_cov_time_tbl_out);

10075: x_return_status => l_return_status,
10076: x_msg_count => l_msg_count,
10077: x_msg_data => l_msg_data,
10078: p_oks_coverage_times_v_tbl => l_cov_time_tbl_in,
10079: x_oks_coverage_times_v_tbl =>l_cov_time_tbl_out);
10080: -- End if;
10081: -- End Times --
10082:
10083: