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_MASSCHANGE_PVT dependencies on OKS_COVERAGE_TIMES_V

Line 930: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

926: -- Old Value: NULL (-9999)
927: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
928: l_stmt := l_select||' ,NULL old_value'||
929: l_from||l_where||
930: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
931: where oct.dnz_chr_id = okh.id
932: and oct.start_hour is null
933: and oct.start_minute is null)
934: AND okh.id = to_number(:update_level_value)';

Line 941: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

937:
938: l_old_value := p_ctr_rec.old_value;
939: l_stmt := l_select||' , :l_old_value old_value'||
940: l_from||l_where||
941: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
942: where oct.dnz_chr_id = okh.id
943: and oct.start_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
944: and oct.start_minute = mod(to_number(:p_ctr_rec_old_value),60))
945: AND okh.id = to_number(:update_level_value)';

Line 957: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

953: -- Old Value: NULL (-9999)
954: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
955: l_stmt := l_select||' ,NULL old_value'||
956: l_from||l_where||
957: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
958: where oct.dnz_chr_id = okh.id
959: and oct.end_hour is null
960: and oct.end_minute is null)
961: AND okh.id = to_number(:update_level_value)';

Line 968: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

964:
965: l_old_value := p_ctr_rec.old_value;
966: l_stmt := l_select||' , :l_old_value old_value'||
967: l_from||l_where||
968: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
969: where oct.dnz_chr_id = okh.id
970: and oct.end_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
971: and oct.end_minute = mod(to_number(:p_ctr_rec_old_value),60))
972: AND okh.id = to_number(:update_level_value)';

Line 2053: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

2049: -- Old Value: NULL (-9999)
2050: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2051: l_stmt := l_select||' ,NULL old_value'||
2052: l_from||l_where||
2053: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
2054: where oct.dnz_chr_id = okh.id
2055: and oct.start_hour is null
2056: and oct.start_minute is null)
2057: AND okh.org_id = to_number(:update_level_value)';

Line 2064: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

2060: -- dbms_output.put_line('Inside else');
2061: l_old_value := p_ctr_rec.old_value;
2062: l_stmt := l_select||' , :l_old_value old_value'||
2063: l_from||l_where||
2064: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
2065: where oct.dnz_chr_id = okh.id
2066: and oct.start_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
2067: and oct.start_minute = mod(to_number(:p_ctr_rec_old_value),60))
2068: AND okh.org_id = to_number(:update_level_value)';

Line 2080: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

2076: -- Old Value: NULL (-9999)
2077: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2078: l_stmt := l_select||' ,NULL old_value'||
2079: l_from||l_where||
2080: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
2081: where oct.dnz_chr_id = okh.id
2082: and oct.end_hour is null
2083: and oct.end_minute is null)
2084: AND okh.org_id = to_number(:update_level_value)';

Line 2090: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

2086: ELSE
2087: l_old_value := p_ctr_rec.old_value;
2088: l_stmt := l_select||' , :l_old_value old_value'||
2089: l_from||l_where||
2090: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
2091: where oct.dnz_chr_id = okh.id
2092: and oct.end_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
2093: and oct.end_minute = mod(to_number(:p_ctr_rec_old_value),60))
2094: AND okh.org_id = to_number(:update_level_value)';

Line 3285: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

3281: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3282: l_stmt := l_select||' ,NULL old_value'||
3283: l_from||',okc_k_party_roles_b okp1 '||
3284: l_where||
3285: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
3286: where oct.dnz_chr_id = okh.id
3287: and oct.start_hour is null
3288: and oct.start_minute is null)
3289: AND okh.org_id = to_number(:update_level_value)';

Line 3297: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

3293: l_old_value := p_ctr_rec.old_value;
3294: l_stmt := l_select||' , :l_old_value old_value'||
3295: l_from||',okc_k_party_roles_b okp1 '||
3296: l_where||
3297: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
3298: where oct.dnz_chr_id = okh.id
3299: and oct.start_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
3300: and oct.start_minute = mod(to_number(:p_ctr_rec_old_value),60))
3301: AND okh.id = okp1.chr_id

Line 3346: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

3342: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3343: l_stmt := l_select||' ,NULL old_value'||
3344: l_from||',okc_k_party_roles_b okp1 '||
3345: l_where||
3346: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
3347: where oct.dnz_chr_id = okh.id
3348: and oct.end_hour is null
3349: and oct.end_minute is null)
3350: AND okh.id = okp1.chr_id

Line 3359: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

3355: l_old_value := p_ctr_rec.old_value;
3356: l_stmt := l_select||' , :l_old_value old_value'||
3357: l_from||',okc_k_party_roles_b okp1 '||
3358: l_where||
3359: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
3360: where oct.dnz_chr_id = okh.id
3361: and oct.end_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
3362: and oct.end_minute = mod(to_number(:p_ctr_rec_old_value),60))
3363: AND okh.id = okp1.chr_id

Line 4507: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

4503: -- Old Value: NULL (-9999)
4504: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4505: l_stmt := l_select||' ,NULL old_value'||
4506: l_from||l_where||
4507: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
4508: where oct.dnz_chr_id = okh.id
4509: and oct.start_hour is null
4510: and oct.start_minute is null)
4511: AND okh.scs_code = :update_level_value';

Line 4518: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

4514: -- dbms_output.put_line('Inside else');
4515: l_old_value := p_ctr_rec.old_value;
4516: l_stmt := l_select||' , :l_old_value old_value'||
4517: l_from||l_where||
4518: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
4519: where oct.dnz_chr_id = okh.id
4520: and oct.start_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
4521: and oct.start_minute = mod(to_number(:p_ctr_rec_old_value),60))
4522: AND okh.scs_code = :update_level_value';

Line 4534: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

4530: -- Old Value: NULL (-9999)
4531: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4532: l_stmt := l_select||' ,NULL old_value'||
4533: l_from||l_where||
4534: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
4535: where oct.dnz_chr_id = okh.id
4536: and oct.end_hour is null
4537: and oct.end_minute is null)
4538: AND okh.scs_code = :update_level_value';

Line 4544: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

4540: ELSE
4541: l_old_value := p_ctr_rec.old_value;
4542: l_stmt := l_select||' , :l_old_value old_value'||
4543: l_from||l_where||
4544: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
4545: where oct.dnz_chr_id = okh.id
4546: and oct.end_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
4547: and oct.end_minute = mod(to_number(:p_ctr_rec_old_value),60))
4548: AND okh.scs_code = :update_level_value';

Line 5792: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

5788: -- Old Value: NULL (-9999)
5789: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5790: l_stmt := l_select||' ,NULL old_value'||
5791: l_from||l_where||
5792: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
5793: where oct.dnz_chr_id = okh.id
5794: and oct.start_hour is null
5795: and oct.start_minute is null)
5796: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5807: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

5803: -- dbms_output.put_line('Inside else');
5804: l_old_value := p_ctr_rec.old_value;
5805: l_stmt := l_select||' , :l_old_value old_value'||
5806: l_from||l_where||
5807: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
5808: where oct.dnz_chr_id = okh.id
5809: and oct.start_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
5810: and oct.start_minute = mod(to_number(:p_ctr_rec_old_value),60))
5811: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5827: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

5823: -- Old Value: NULL (-9999)
5824: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5825: l_stmt := l_select||' ,NULL old_value'||
5826: l_from||l_where||
5827: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
5828: where oct.dnz_chr_id = okh.id
5829: and oct.end_hour is null
5830: and oct.end_minute is null)
5831: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 5840: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct

5836: ELSE
5837: l_old_value := p_ctr_rec.old_value;
5838: l_stmt := l_select||' , :l_old_value old_value'||
5839: l_from||l_where||
5840: ' AND EXISTS (Select ''x'' from oks_coverage_times_v oct
5841: where oct.dnz_chr_id = okh.id
5842: and oct.end_hour = trunc(to_number(:p_ctr_rec_old_value)/60)
5843: and oct.end_minute = mod(to_number(:p_ctr_rec_old_value),60))
5844: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1

Line 6936: oks_coverage_times_v oct

6932: CURSOR Get_cvr_start(p_chr_id IN Number, p_hour IN Number, p_minute IN Number ) IS
6933: SELECT oct.id,oct.OBJECT_VERSION_NUMBER,
6934: oct.start_hour,oct.start_minute,oct.end_hour,oct.end_minute
6935: FROM oks_coverage_timezones_v ctz ,
6936: oks_coverage_times_v oct
6937: WHERE oct.cov_tze_line_id = ctz.id
6938: AND oct.dnz_chr_id = p_chr_id
6939: AND oct.start_hour = p_hour
6940: AND oct.start_minute = p_minute ;

Line 6946: oks_coverage_times_v oct

6942: CURSOR Get_cvr_end(p_chr_id IN Number, p_hour IN Number, p_minute IN Number) IS
6943: SELECT oct.id ,oct.OBJECT_VERSION_NUMBER,
6944: oct.start_hour,oct.start_minute,oct.end_hour,oct.end_minute
6945: FROM oks_coverage_timezones_v ctz ,
6946: oks_coverage_times_v oct
6947: WHERE oct.cov_tze_line_id = ctz.id
6948: AND oct.dnz_chr_id = p_chr_id
6949: AND oct.end_hour = p_hour
6950: AND oct.end_minute = p_minute ;

Line 7194: l_cvt_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type ;

7190: -- This table type is not used in the API.
7191: -- l_igsv_ext_tbl_in okc_time_pub.igsv_ext_tbl_type;
7192: -- l_igsv_ext_tbl_out okc_time_pub.igsv_ext_tbl_type;
7193:
7194: l_cvt_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type ;
7195: l_cvt_tbl_out oks_cvt_pvt.oks_coverage_times_v_tbl_type ;
7196:
7197: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;
7198: l_scrv_tbl_out oks_sales_credit_pub.scrv_tbl_type;

Line 7195: l_cvt_tbl_out oks_cvt_pvt.oks_coverage_times_v_tbl_type ;

7191: -- l_igsv_ext_tbl_in okc_time_pub.igsv_ext_tbl_type;
7192: -- l_igsv_ext_tbl_out okc_time_pub.igsv_ext_tbl_type;
7193:
7194: l_cvt_tbl_in oks_cvt_pvt.oks_coverage_times_v_tbl_type ;
7195: l_cvt_tbl_out oks_cvt_pvt.oks_coverage_times_v_tbl_type ;
7196:
7197: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;
7198: l_scrv_tbl_out oks_sales_credit_pub.scrv_tbl_type;
7199:

Line 10471: p_oks_coverage_times_v_tbl => l_cvt_tbl_in);

10467: p_init_msg_list => l_init_msg_list,
10468: x_return_status => l_return_status,
10469: x_msg_count => l_msg_count,
10470: x_msg_data => l_msg_data,
10471: p_oks_coverage_times_v_tbl => l_cvt_tbl_in);
10472:
10473:
10474: IF l_return_status = G_RET_STS_SUCCESS THEN
10475:

Line 10481: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,

10477: p_init_msg_list => l_init_msg_list,
10478: x_return_status => l_return_status,
10479: x_msg_count => l_msg_count,
10480: x_msg_data => l_msg_data,
10481: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,
10482: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);
10483:
10484:
10485: IF l_return_status = G_RET_STS_SUCCESS THEN

Line 10482: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);

10478: x_return_status => l_return_status,
10479: x_msg_count => l_msg_count,
10480: x_msg_data => l_msg_data,
10481: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,
10482: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);
10483:
10484:
10485: IF l_return_status = G_RET_STS_SUCCESS THEN
10486:

Line 10599: p_oks_coverage_times_v_tbl => l_cvt_tbl_in);

10595: p_init_msg_list => l_init_msg_list,
10596: x_return_status => l_return_status,
10597: x_msg_count => l_msg_count,
10598: x_msg_data => l_msg_data,
10599: p_oks_coverage_times_v_tbl => l_cvt_tbl_in);
10600:
10601:
10602: IF l_return_status = G_RET_STS_SUCCESS THEN
10603:

Line 10609: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,

10605: p_init_msg_list => l_init_msg_list,
10606: x_return_status => l_return_status,
10607: x_msg_count => l_msg_count,
10608: x_msg_data => l_msg_data,
10609: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,
10610: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);
10611:
10612:
10613: IF l_return_status = G_RET_STS_SUCCESS THEN

Line 10610: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);

10606: x_return_status => l_return_status,
10607: x_msg_count => l_msg_count,
10608: x_msg_data => l_msg_data,
10609: p_oks_coverage_times_v_tbl => l_cvt_tbl_in,
10610: x_oks_coverage_times_v_tbl => l_cvt_tbl_out);
10611:
10612:
10613: IF l_return_status = G_RET_STS_SUCCESS THEN
10614: LOG_MESSAGES('COVERAGE_END_TIME update status: '||l_return_status);