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_TIMEZONES_V

Line 478: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

474: -- Old Value: NULL (-9999)
475: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
476: l_stmt := l_select||' ,NULL old_value'||
477: l_from||l_where||
478: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
479: WHERE ctz.dnz_chr_id = okh.id
480: AND ctz.timezone_id IS NULL )
481: AND okh.id = to_number(:update_level_value)';
482:

Line 489: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

485:
486: l_old_value := p_ctr_rec.old_value;
487: l_stmt := l_select||' , :l_old_value old_value'||
488: l_from||
489: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
490: WHERE ctz.dnz_chr_id = okh.id
491: AND ctz.timezone_id IS NOT NULL )
492: AND okh.id = to_number(:update_level_value)';
493: -- Old Value: Other than NULL or ALL

Line 499: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

495:
496: l_old_value := p_ctr_rec.old_value;
497: l_stmt := l_select||' , :l_old_value old_value'||
498: l_from||
499: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
500: WHERE ctz.dnz_chr_id = okh.id
501: AND ctz.timezone_id = to_number(:p_ctr_rec_old_value))
502: AND okh.id = to_number(:update_level_value)';
503:

Line 1620: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

1616: -- Old Value: NULL (-9999)
1617: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1618: l_stmt := l_select||' ,NULL old_value'||
1619: l_from||l_where||
1620: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
1621: WHERE ctz.dnz_chr_id = okh.id
1622: AND ctz.timezone_id IS NULL )
1623: AND okh.org_id = to_number(:update_level_value)';
1624:

Line 1631: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

1627:
1628: l_old_value := p_ctr_rec.old_value;
1629: l_stmt := l_select||' , :l_old_value old_value'||
1630: l_from||
1631: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
1632: WHERE ctz.dnz_chr_id = okh.id
1633: AND ctz.timezone_id IS NOT NULL )
1634: AND okh.org_id = to_number(:update_level_value)';
1635: -- Old Value: Other than NULL or ALL

Line 1641: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

1637:
1638: l_old_value := p_ctr_rec.old_value;
1639: l_stmt := l_select||' , :l_old_value old_value'||
1640: l_from||
1641: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
1642: WHERE ctz.dnz_chr_id = okh.id
1643: AND ctz.timezone_id = to_number(:p_ctr_rec_old_value))
1644: AND okh.org_id = to_number(:update_level_value)';
1645:

Line 2763: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

2759: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2760: l_stmt := l_select||' ,NULL old_value'||
2761: l_from||',okc_k_party_roles_v okp1'||
2762: l_where||
2763: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
2764: WHERE ctz.dnz_chr_id = okh.id
2765: AND ctz.timezone_id IS NULL )
2766: AND okh.id = okp1.chr_id
2767: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2776: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

2772:
2773: l_old_value := p_ctr_rec.old_value;
2774: l_stmt := l_select||' , :l_old_value old_value'||
2775: l_from||',okc_k_party_roles_v okp1'||
2776: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
2777: WHERE ctz.dnz_chr_id = okh.id
2778: AND ctz.timezone_id IS NOT NULL )
2779: AND okh.id = okp1.chr_id
2780: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2788: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

2784:
2785: l_old_value := p_ctr_rec.old_value;
2786: l_stmt := l_select||' , :l_old_value old_value'||
2787: l_from||',okc_k_party_roles_v okp1'||
2788: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
2789: WHERE ctz.dnz_chr_id = okh.id
2790: AND ctz.timezone_id = to_number(:p_ctr_rec_old_value))
2791: AND okh.id = okp1.chr_id
2792: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 4061: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

4057: -- Old Value: NULL (-9999)
4058: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4059: l_stmt := l_select||' ,NULL old_value'||
4060: l_from||l_where||
4061: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
4062: WHERE ctz.dnz_chr_id = okh.id
4063: AND ctz.timezone_id IS NULL )
4064: AND okh.scs_code = :update_level_value' ;
4065:

Line 4072: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

4068:
4069: l_old_value := p_ctr_rec.old_value;
4070: l_stmt := l_select||' , :l_old_value old_value'||
4071: l_from||
4072: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
4073: WHERE ctz.dnz_chr_id = okh.id
4074: AND ctz.timezone_id IS NOT NULL )
4075: AND okh.scs_code = :update_level_value' ;
4076: -- Old Value: Other than NULL or ALL

Line 4082: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

4078:
4079: l_old_value := p_ctr_rec.old_value;
4080: l_stmt := l_select||' , :l_old_value old_value'||
4081: l_from||
4082: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
4083: WHERE ctz.dnz_chr_id = okh.id
4084: AND ctz.timezone_id = to_number(:p_ctr_rec_old_value))
4085: AND okh.scs_code = :update_level_value' ;
4086:

Line 5245: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

5241: -- Old Value: NULL (-9999)
5242: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5243: l_stmt := l_select||' ,NULL old_value'||
5244: l_from||l_where||
5245: ' AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
5246: WHERE ctz.dnz_chr_id = okh.id
5247: AND ctz.timezone_id IS NULL )
5248: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5249: WHERE okg1.included_chr_id is not null

Line 5259: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

5255:
5256: l_old_value := p_ctr_rec.old_value;
5257: l_stmt := l_select||' , :l_old_value old_value'||
5258: l_from||
5259: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
5260: WHERE ctz.dnz_chr_id = okh.id
5261: AND ctz.timezone_id IS NOT NULL )
5262: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5263: WHERE okg1.included_chr_id is not null

Line 5272: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz

5268:
5269: l_old_value := p_ctr_rec.old_value;
5270: l_stmt := l_select||' , :l_old_value old_value'||
5271: l_from||
5272: l_where||'AND EXISTS (SELECT ''x'' from oks_coverage_timezones_v ctz
5273: WHERE ctz.dnz_chr_id = okh.id
5274: AND ctz.timezone_id = to_number(:p_ctr_rec_old_value))
5275: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5276: WHERE okg1.included_chr_id is not null

Line 6935: FROM oks_coverage_timezones_v ctz ,

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

Line 6945: FROM oks_coverage_timezones_v ctz ,

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

Line 6955: FROM oks_coverage_timezones_V oct

6951:
6952: -- The following cusrsor is for checking the coverage time overlap
6953: CURSOR Get_cvr_timezone(p_chr_id IN Number) IS
6954: SELECT oct.id id
6955: FROM oks_coverage_timezones_V oct
6956: WHERE oct.dnz_chr_id = p_chr_id;
6957:
6958: CURSOR Get_timezone(p_chr_id IN Number , p_old_value IN Varchar2) IS
6959: SELECT oct.id id,oct.OBJECT_VERSION_NUMBER,oct.cle_id cle_id

Line 6960: FROM oks_coverage_timezones_V oct

6956: WHERE oct.dnz_chr_id = p_chr_id;
6957:
6958: CURSOR Get_timezone(p_chr_id IN Number , p_old_value IN Varchar2) IS
6959: SELECT oct.id id,oct.OBJECT_VERSION_NUMBER,oct.cle_id cle_id
6960: FROM oks_coverage_timezones_V oct
6961: WHERE oct.dnz_chr_id = p_chr_id
6962: AND oct.timezone_id = p_old_value ;
6963:
6964: CURSOR Get_Acct_Rule(p_chr_id IN Number, p_old_value IN Varchar2) IS

Line 9918: p_oks_coverage_timezones_v_tbl => l_ctz_tblType_in);

9914: p_init_msg_list => l_init_msg_list,
9915: x_return_status => l_return_status,
9916: x_msg_count => l_msg_count,
9917: x_msg_data => l_msg_data,
9918: p_oks_coverage_timezones_v_tbl => l_ctz_tblType_in);
9919:
9920: IF l_return_status = G_RET_STS_SUCCESS THEN
9921:
9922: OKS_CTZ_PVT.update_row(

Line 9928: p_oks_coverage_timezones_v_tbl => l_ctz_tblType_in,

9924: p_init_msg_list => l_init_msg_list,
9925: x_return_status => l_return_status,
9926: x_msg_count => l_msg_count,
9927: x_msg_data => l_msg_data,
9928: p_oks_coverage_timezones_v_tbl => l_ctz_tblType_in,
9929: x_oks_coverage_timezones_v_tbl => l_ctz_tblType_out);
9930:
9931:
9932: IF l_return_status = G_RET_STS_SUCCESS THEN

Line 9929: x_oks_coverage_timezones_v_tbl => l_ctz_tblType_out);

9925: x_return_status => l_return_status,
9926: x_msg_count => l_msg_count,
9927: x_msg_data => l_msg_data,
9928: p_oks_coverage_timezones_v_tbl => l_ctz_tblType_in,
9929: x_oks_coverage_timezones_v_tbl => l_ctz_tblType_out);
9930:
9931:
9932: IF l_return_status = G_RET_STS_SUCCESS THEN
9933: LOG_MESSAGES('Coverage Timezone update status: '||l_return_status);