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_ACTION_TIME_TYPES

Line 37987: DELETE OKS_ACTION_TIME_TYPES

37983: DELETE OKS_ACTION_TIMES
37984: WHERE CLE_ID = L_CLE_ID
37985: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37986:
37987: DELETE OKS_ACTION_TIME_TYPES
37988: WHERE CLE_ID = L_CLE_ID
37989: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37990:
37991: BEGIN

Line 38120: INSERT INTO oks_action_time_types

38116: END;
38117:
38118: BEGIN
38119: IF REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME IS NOT NULL THEN
38120: INSERT INTO oks_action_time_types
38121: (ID,
38122: CLE_ID,
38123: DNZ_CHR_ID,
38124: ACTION_TYPE_CODE,

Line 38151: INSERT INTO oks_action_time_types

38147:
38148: END IF;
38149:
38150: IF REC_RCN_RSN_INFO.RSN_REACT_TIME_NAME IS NOT NULL THEN
38151: INSERT INTO oks_action_time_types
38152: (ID,
38153: CLE_ID,
38154: DNZ_CHR_ID,
38155: ACTION_TYPE_CODE,

Line 38206: oks_action_time_types att

38202: from okc_timevalues_b tim,
38203: okc_react_intervals rin,
38204: okc_rules_b rul,
38205: okc_rule_groups_b rgp,
38206: oks_action_time_types att
38207: where att.cle_id = rgp.cle_id
38208: and rgp.id = rul.rgp_id
38209: and rul.rule_information_category in ('RCN', 'RSN')
38210: and rul.id = rin.rul_id

Line 38304: DELETE OKS_ACTION_TIME_TYPES_H

38300: WHERE CLE_ID = L_CLE_ID
38301: AND DNZ_CHR_ID = L_DNZ_CHR_ID
38302: AND MAJOR_VERSION = L_MAJOR_VERSION;
38303:
38304: DELETE OKS_ACTION_TIME_TYPES_H
38305: WHERE CLE_ID = L_CLE_ID
38306: AND DNZ_CHR_ID = L_DNZ_CHR_ID
38307: AND MAJOR_VERSION = L_MAJOR_VERSION;
38308:

Line 38448: INSERT INTO oks_action_time_types_H

38444: END;
38445:
38446: BEGIN
38447: IF REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME IS NOT NULL THEN
38448: INSERT INTO oks_action_time_types_H
38449: (ID,
38450: CLE_ID,
38451: DNZ_CHR_ID,
38452: ACTION_TYPE_CODE,

Line 38481: INSERT INTO oks_action_time_types_H

38477:
38478: END IF;
38479:
38480: IF REC_RCN_RSN_INFO.RSN_REACT_TIME_NAME IS NOT NULL THEN
38481: INSERT INTO oks_action_time_types_H
38482: (ID,
38483: CLE_ID,
38484: DNZ_CHR_ID,
38485: ACTION_TYPE_CODE,

Line 38538: oks_action_time_types_h att

38534: from okc_timevalues_bh tim,
38535: okc_react_intervals_h rin,
38536: okc_rules_bh rul,
38537: okc_rule_groups_bh rgp,
38538: oks_action_time_types_h att
38539: where att.cle_id = rgp.cle_id
38540: and rgp.id = rul.rgp_id
38541: and rul.rule_information_category in ('RCN', 'RSN')
38542: and rul.id = rin.rul_id