DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on OKC_XPRT_RULE_OUTCOMES

Line 118: FROM okc_xprt_rule_outcomes

114:
115: CURSOR csr_rule_outcomes IS
116: SELECT object_type,
117: object_value_id
118: FROM okc_xprt_rule_outcomes
119: WHERE rule_id = p_rule_id;
120:
121: l_api_name CONSTANT VARCHAR2(30) := 'build_statement_rule';
122: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;

Line 136: l_object_type_outcome okc_xprt_rule_outcomes.object_type%TYPE;

132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;
135:
136: l_object_type_outcome okc_xprt_rule_outcomes.object_type%TYPE;
137: l_object_value_id okc_xprt_rule_outcomes.object_value_id%TYPE;
138:
139: l_clause_prefix VARCHAR2(4000);
140: l_system_var_prefix VARCHAR2(4000);

Line 137: l_object_value_id okc_xprt_rule_outcomes.object_value_id%TYPE;

133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;
135:
136: l_object_type_outcome okc_xprt_rule_outcomes.object_type%TYPE;
137: l_object_value_id okc_xprt_rule_outcomes.object_value_id%TYPE;
138:
139: l_clause_prefix VARCHAR2(4000);
140: l_system_var_prefix VARCHAR2(4000);
141: l_question_prefix VARCHAR2(4000);