DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKS_COVERAGE_TIMES_V

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 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 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 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 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 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: