DBA Data[Home] [Help]

APPS.OKS_RULE_MIGRATE dependencies on OKS_ACTION_TIME_TYPES_H

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