DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 689: okc_bus_variables_tl t

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
692: AND rcon.object_type = 'VARIABLE'
693: AND rhdr.status_code NOT IN ('DRAFT','INACTIVE')

Line 707: okc_bus_variables_tl t

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
710: AND rcon.object_value_type = 'VARIABLE'
711: AND rhdr.status_code NOT IN ('DRAFT','INACTIVE')

Line 755: TYPE VariableNameList IS TABLE OF okc_bus_variables_tl.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER;

751:
752: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_features';
753:
754: TYPE VariableCodeList IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
755: TYPE VariableNameList IS TABLE OF okc_bus_variables_tl.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER;
756: --TYPE VariableDatatypeList IS TABLE OF okc_bus_variables_b.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
757: TYPE VariableDatatypeList IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER; -- changed for R12
758: TYPE LanguageList IS TABLE OF okc_bus_variables_tl.language%TYPE INDEX BY BINARY_INTEGER;
759: TYPE SourceLangList IS TABLE OF okc_bus_variables_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

Line 758: TYPE LanguageList IS TABLE OF okc_bus_variables_tl.language%TYPE INDEX BY BINARY_INTEGER;

754: TYPE VariableCodeList IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
755: TYPE VariableNameList IS TABLE OF okc_bus_variables_tl.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER;
756: --TYPE VariableDatatypeList IS TABLE OF okc_bus_variables_b.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
757: TYPE VariableDatatypeList IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER; -- changed for R12
758: TYPE LanguageList IS TABLE OF okc_bus_variables_tl.language%TYPE INDEX BY BINARY_INTEGER;
759: TYPE SourceLangList IS TABLE OF okc_bus_variables_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
760: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
761:
762:

Line 759: TYPE SourceLangList IS TABLE OF okc_bus_variables_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

755: TYPE VariableNameList IS TABLE OF okc_bus_variables_tl.VARIABLE_NAME%TYPE INDEX BY BINARY_INTEGER;
756: --TYPE VariableDatatypeList IS TABLE OF okc_bus_variables_b.VARIABLE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
757: TYPE VariableDatatypeList IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER; -- changed for R12
758: TYPE LanguageList IS TABLE OF okc_bus_variables_tl.language%TYPE INDEX BY BINARY_INTEGER;
759: TYPE SourceLangList IS TABLE OF okc_bus_variables_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
760: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
761:
762:
763: variableCode_tbl VariableCodeList;