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_RULE_MIGRATE dependencies on OKS_COVERAGE_TIMES

Line 37748: DELETE OKS_COVERAGE_TIMES

37744: IF(l_check_var is null) THEN
37745: Delete from oks_k_lines_b where cle_id = L_Cle_ID;
37746: END IF;
37747:
37748: DELETE OKS_COVERAGE_TIMES
37749: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES
37750: WHERE CLE_ID = L_CLE_ID AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37751: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37752:

Line 37784: insert into oks_coverage_times oct (

37780: and rgp.cle_id = L_CLE_ID;
37781:
37782:
37783:
37784: insert into oks_coverage_times oct (
37785: id, cov_tze_line_id, dnz_chr_id, start_hour, start_minute,
37786: end_hour, end_minute, monday_yn, tuesday_yn, wednesday_yn,
37787: thursday_yn, friday_yn, saturday_yn, sunday_yn, created_by,
37788: creation_date, last_updated_by, last_update_date,

Line 37838: DELETE OKS_COVERAGE_TIMES_H

37834:
37835: Delete from oks_k_lines_bh where cle_id = P_Cle_ID and major_version = L_MAJOR_VERSION;
37836: END IF;
37837:
37838: DELETE OKS_COVERAGE_TIMES_H
37839: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES_H
37840: WHERE CLE_ID = L_CLE_ID AND MAJOR_VERSION = L_MAJOR_VERSION
37841: AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37842: AND MAJOR_VERSION = L_MAJOR_VERSION

Line 37877: INSERT INTO OKS_COVERAGE_TIMES_H oct (

37873: and rgp.major_version = l_major_version;
37874:
37875:
37876:
37877: INSERT INTO OKS_COVERAGE_TIMES_H oct (
37878: id, cov_tze_line_id, dnz_chr_id, start_hour, start_minute,
37879: end_hour, end_minute, monday_yn, tuesday_yn, wednesday_yn,
37880: thursday_yn, friday_yn, saturday_yn, sunday_yn, created_by,
37881: creation_date, last_updated_by, last_update_date,