DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on OKC_XPRT_RULE_CONDITIONS

Line 687: okc_xprt_rule_conditions rcon,

683: v.variable_datatype variable_datatype,
684: t.LANGUAGE language,
685: t.source_lang source_lang
686: FROM okc_xprt_rule_hdrs_all rhdr,
687: okc_xprt_rule_conditions rcon,
688: okc_bus_variables_b v,
689: okc_bus_variables_tl t
690: WHERE rhdr.rule_id = rcon.rule_id
691: AND rhdr.intent = p_intent

Line 705: okc_xprt_rule_conditions rcon,

701: v.variable_datatype variable_datatype,
702: t.LANGUAGE language,
703: t.source_lang source_lang
704: FROM okc_xprt_rule_hdrs_all rhdr,
705: okc_xprt_rule_conditions rcon,
706: okc_bus_variables_b v,
707: okc_bus_variables_tl t
708: WHERE rhdr.rule_id = rcon.rule_id
709: AND rhdr.intent = p_intent

Line 723: okc_xprt_rule_conditions rcon,

719: q.question_datatype variable_datatype,
720: ql.LANGUAGE language,
721: ql.source_lang source_lang
722: FROM okc_xprt_rule_hdrs_all rhdr,
723: okc_xprt_rule_conditions rcon,
724: okc_xprt_questions_b q,
725: okc_xprt_questions_tl ql
726: WHERE rhdr.rule_id = rcon.rule_id
727: AND rhdr.intent = p_intent

Line 1154: okc_xprt_rule_conditions c,

1150: SELECT DISTINCT DECODE(SUBSTR(c.object_code,1,3),'OKC',c.object_code,'USER$' || c.object_code) variable_code,
1151: v.object_value_code variable_value,
1152: okc_xprt_util_pvt.get_value_display(v.rule_condition_id,v.object_value_code) variable_value_desc
1153: FROM okc_xprt_rule_cond_vals v,
1154: okc_xprt_rule_conditions c,
1155: okc_xprt_rule_hdrs_all r
1156: WHERE v.rule_condition_id = c.rule_condition_id
1157: AND c.rule_id = r.rule_id
1158: AND c.object_type = 'VARIABLE'

Line 1166: TYPE VariableCodeList IS TABLE OF okc_xprt_rule_conditions.object_code%TYPE INDEX BY BINARY_INTEGER;

1162:
1163: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_options';
1164: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1165:
1166: TYPE VariableCodeList IS TABLE OF okc_xprt_rule_conditions.object_code%TYPE INDEX BY BINARY_INTEGER;
1167: TYPE VariableOptionList IS TABLE OF okc_xprt_rule_conditions.object_value_code%TYPE INDEX BY BINARY_INTEGER;
1168: TYPE VariableOptionDesc IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1169: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1170:

Line 1167: TYPE VariableOptionList IS TABLE OF okc_xprt_rule_conditions.object_value_code%TYPE INDEX BY BINARY_INTEGER;

1163: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_options';
1164: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1165:
1166: TYPE VariableCodeList IS TABLE OF okc_xprt_rule_conditions.object_code%TYPE INDEX BY BINARY_INTEGER;
1167: TYPE VariableOptionList IS TABLE OF okc_xprt_rule_conditions.object_value_code%TYPE INDEX BY BINARY_INTEGER;
1168: TYPE VariableOptionDesc IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1169: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1170:
1171: variableCode_tbl VariableCodeList;