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.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_XPRT_QUESTIONS_TL

Line 750: TYPE TmplQstIdList IS TABLE OF okc_xprt_questions_tl.question_id%TYPE INDEX BY BINARY_INTEGER;

746: l_feature_type NUMBER;
747: l_feature_min_val NUMBER;
748: l_feature_max_val NUMBER;
749:
750: TYPE TmplQstIdList IS TABLE OF okc_xprt_questions_tl.question_id%TYPE INDEX BY BINARY_INTEGER;
751: TYPE TmplQstNameList IS TABLE OF okc_xprt_questions_tl.prompt%TYPE INDEX BY BINARY_INTEGER;
752: TYPE LanguageList IS TABLE OF okc_xprt_questions_tl.language%TYPE INDEX BY BINARY_INTEGER;
753: TYPE SourceLangList IS TABLE OF okc_xprt_questions_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
754:

Line 751: TYPE TmplQstNameList IS TABLE OF okc_xprt_questions_tl.prompt%TYPE INDEX BY BINARY_INTEGER;

747: l_feature_min_val NUMBER;
748: l_feature_max_val NUMBER;
749:
750: TYPE TmplQstIdList IS TABLE OF okc_xprt_questions_tl.question_id%TYPE INDEX BY BINARY_INTEGER;
751: TYPE TmplQstNameList IS TABLE OF okc_xprt_questions_tl.prompt%TYPE INDEX BY BINARY_INTEGER;
752: TYPE LanguageList IS TABLE OF okc_xprt_questions_tl.language%TYPE INDEX BY BINARY_INTEGER;
753: TYPE SourceLangList IS TABLE OF okc_xprt_questions_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
754:
755: TmplQstId_tbl TmplQstIdList;

Line 752: TYPE LanguageList IS TABLE OF okc_xprt_questions_tl.language%TYPE INDEX BY BINARY_INTEGER;

748: l_feature_max_val NUMBER;
749:
750: TYPE TmplQstIdList IS TABLE OF okc_xprt_questions_tl.question_id%TYPE INDEX BY BINARY_INTEGER;
751: TYPE TmplQstNameList IS TABLE OF okc_xprt_questions_tl.prompt%TYPE INDEX BY BINARY_INTEGER;
752: TYPE LanguageList IS TABLE OF okc_xprt_questions_tl.language%TYPE INDEX BY BINARY_INTEGER;
753: TYPE SourceLangList IS TABLE OF okc_xprt_questions_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
754:
755: TmplQstId_tbl TmplQstIdList;
756: TmplQstName_tbl TmplQstNameList;

Line 753: TYPE SourceLangList IS TABLE OF okc_xprt_questions_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

749:
750: TYPE TmplQstIdList IS TABLE OF okc_xprt_questions_tl.question_id%TYPE INDEX BY BINARY_INTEGER;
751: TYPE TmplQstNameList IS TABLE OF okc_xprt_questions_tl.prompt%TYPE INDEX BY BINARY_INTEGER;
752: TYPE LanguageList IS TABLE OF okc_xprt_questions_tl.language%TYPE INDEX BY BINARY_INTEGER;
753: TYPE SourceLangList IS TABLE OF okc_xprt_questions_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
754:
755: TmplQstId_tbl TmplQstIdList;
756: TmplQstName_tbl TmplQstNameList;
757: language_tbl LanguageList;

Line 765: FROM okc_xprt_questions_tl q,

761: SELECT q.question_id,
762: DECODE(q.prompt,NULL,q.question_name,q.prompt),
763: q.language,
764: q.source_lang
765: FROM okc_xprt_questions_tl q,
766: okc_xprt_question_orders o
767: WHERE q.question_id = o.question_id
768: AND o.question_rule_status IN ('ACTIVE','PENDINGPUB')
769: AND o.template_id = p_template_id;

Line 1353: FROM okc_xprt_questions_tl

1349:
1350: -- Question Name to be displayed in case of error
1351: CURSOR csr_qst_name IS
1352: SELECT question_name
1353: FROM okc_xprt_questions_tl
1354: WHERE question_id = p_question_id
1355: AND language = USERENV('LANG');
1356:
1357: -- get the list of installed languages

Line 1390: l_question_name okc_xprt_questions_tl.question_name%TYPE;

1386: l_sql_stmt LONG;
1387: l_sequence_sql_stmt LONG;
1388: l_error_message VARCHAR2(4000);
1389: l_valueset_type fnd_flex_value_sets.validation_type%TYPE;
1390: l_question_name okc_xprt_questions_tl.question_name%TYPE;
1391: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1392:
1393: TYPE cur_typ IS REF CURSOR;
1394: c_cursor cur_typ;