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_TIMEZONES

Line 710: FROM oks_coverage_timezones

706: ID
707: ,CLE_ID
708: ,DEFAULT_YN
709: ,TIMEZONE_ID
710: FROM oks_coverage_timezones
711: WHERE cle_id = p_cle_id;
712: -------------------------------------------------------------------------------
713: CURSOR Get_cov_times(p_cov_tz_id IN Number) IS
714: SELECT

Line 1353: p_oks_coverage_timezones_v_tbl => l_covtz_tbl_in,

1349: p_init_msg_list => l_init_msg_list,
1350: x_return_status => l_return_status,
1351: x_msg_count => l_msg_count,
1352: x_msg_data => l_msg_data,
1353: p_oks_coverage_timezones_v_tbl => l_covtz_tbl_in,
1354: x_oks_coverage_timezones_v_tbl => l_covtz_tbl_out);
1355:
1356:
1357: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1354: x_oks_coverage_timezones_v_tbl => l_covtz_tbl_out);

1350: x_return_status => l_return_status,
1351: x_msg_count => l_msg_count,
1352: x_msg_data => l_msg_data,
1353: p_oks_coverage_timezones_v_tbl => l_covtz_tbl_in,
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);

Line 2332: FROM oks_coverage_timezones

2328: AND dnz_chr_id = p_dnz_chr_id;
2329:
2330: CURSOR Time_Zone_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2331: SELECT ID,CLE_ID,DNZ_CHR_ID
2332: FROM oks_coverage_timezones
2333: WHERE cle_id = p_iD
2334: AND dnz_chr_id =p_dnz_chr_id;
2335:
2336:

Line 2784: p_oks_coverage_timezones_v_tbl => l_tzev_tbl_in);

2780: p_init_msg_list => l_init_msg_list,
2781: x_return_status => l_return_status,
2782: x_msg_count => l_msg_count,
2783: x_msg_data => l_msg_data,
2784: p_oks_coverage_timezones_v_tbl => l_tzev_tbl_in);
2785:
2786:
2787: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2788: return;

Line 4499: OKS_COVERAGE_TIMEZONES covtz,

4495: covtm.saturday_yn saturday_yn,
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

Line 5418: FROM OKS_COVERAGE_TIMEZONES

5414: l_dummy VARCHAR2(1) := NULL;
5415:
5416: CURSOR Check_CovTime_Zone(l_cle_id IN NUMBER,l_timezone_id IN NUMBER) IS
5417: SELECT 'X'
5418: FROM OKS_COVERAGE_TIMEZONES
5419: WHERE cle_id = l_cle_id
5420: AND timezone_id = l_timezone_id;
5421:
5422: BEGIN

Line 7357: oks_coverage_timezones tze

7353: tze.dnz_chr_id tze_dnz_chr_id,tze.object_version_number tze_object_version_number,
7354: to_number(items.object1_id1) busi_proc_id
7355: FROM OKC_K_LINES_B lines1,
7356: okc_k_items items,
7357: oks_coverage_timezones tze
7358: WHERE lines1.id = p_id
7359: AND lines1.cle_id = p_cle_id
7360: AND lines1.lse_id IN (3,16,21)
7361: AND items.cle_id = lines1.id

Line 7375: FROM oks_coverage_timezones tze

7371: CURSOR CUR_GET_OLD_COV_TZ(p_bp_line_id IN NUMBER) IS
7372: SELECT tze.id timezone_line_id, tze.cle_id timezone_cle_id,
7373: tze.timezone_id timezone_id,tze.default_yn default_yn,
7374: tze.dnz_chr_id tze_dnz_chr_id,tze.object_version_number tze_object_version_number
7375: FROM oks_coverage_timezones tze
7376: WHERE tze.cle_id = p_bp_line_id;
7377:
7378:
7379:

Line 7721: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,

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,
7721: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,
7722: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);
7723:
7724:
7725: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 7722: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);

7718: x_return_status => l_return_status,
7719: x_msg_count => l_msg_count,
7720: x_msg_data => l_msg_data,
7721: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,
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);

Line 9032: DELETE OKS_COVERAGE_TIMEZONES_H

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;
9034:
9035: DELETE OKS_BILLRATE_SCHEDULES_H
9036: WHERE dnz_chr_id = l_chr_id;

Line 9134: DELETE OKS_COVERAGE_TIMEZONES_H

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
9135: WHERE dnz_chr_id = l_chr_id
9136: And major_version = -1;
9137:
9138: DELETE OKS_BILLRATE_SCHEDULES_H

Line 9404: SELECT id,dnz_chr_id,object_version_number from OKS_COVERAGE_TIMEZONES

9400:
9401:
9402: -- Time Zone --
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;

Line 10051: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,

10047: p_init_msg_list => l_init_msg_list,
10048: x_return_status => l_return_status,
10049: x_msg_count => l_msg_count,
10050: x_msg_data => l_msg_data,
10051: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,
10052: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);
10053: End if ;
10054: cnt:=0;
10055:

Line 10052: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);

10048: x_return_status => l_return_status,
10049: x_msg_count => l_msg_count,
10050: x_msg_data => l_msg_data,
10051: p_oks_coverage_timezones_v_tbl => l_timezone_tbl_in,
10052: x_oks_coverage_timezones_v_tbl => l_timezone_tbl_out);
10053: End if ;
10054: cnt:=0;
10055:
10056: -- End Time Zone--