APPS.OKC_XPRT_QUESTION_PVT dependencies on OKC_XPRT_QUESTIONS_TL

Line 50: FROM okc_xprt_questions_b b, okc_xprt_questions_tl t

46: IS
47: CURSOR cur_question_exists
48: IS
49: SELECT 'X'
50: FROM okc_xprt_questions_b b, okc_xprt_questions_tl t
51: WHERE b.question_id = t.question_id
52: AND b.question_type = t.question_type
53: -- AND b.question_intent = p_question_intent
54: AND t.question_type = p_question_type

Line 113: FROM okc_xprt_questions_b b, okc_xprt_questions_tl t

109: IS
110: CURSOR cur_question_exists
111: IS
112: SELECT 'X'
113: FROM okc_xprt_questions_b b, okc_xprt_questions_tl t
114: WHERE b.question_id = t.question_id
115: AND b.question_type = t.question_type
116: AND b.question_intent = p_question_intent
117: AND t.question_type = 'Q'

Line 693: INSERT INTO okc_xprt_questions_tl

689: )
690: -- returning question_id into p_question_id
691: ;
692:
693: INSERT INTO okc_xprt_questions_tl
694: (question_id, question_name, question_type, LANGUAGE,
695: source_lang, description, prompt, created_by,
696: creation_date, last_updated_by, last_update_date,
697: last_update_login)

Line 706: FROM okc_xprt_questions_tl t

702: FROM fnd_languages l
703: WHERE l.installed_flag IN ('I', 'B')
704: AND NOT EXISTS (
705: SELECT NULL
706: FROM okc_xprt_questions_tl t
707: WHERE t.question_id = p_question_id
708: AND t.LANGUAGE = l.language_code);
709: EXCEPTION
710: WHEN OTHERS

Line 933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;

929: l_question_datatype OKC_XPRT_QUESTIONS_B.question_datatype%TYPE;
930: l_value_set_name OKC_XPRT_QUESTIONS_B.value_set_name%TYPE;
931: l_object_version_number NUMBER;
932:
933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;
934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;
935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;
936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;
937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;

Line 934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;

930: l_value_set_name OKC_XPRT_QUESTIONS_B.value_set_name%TYPE;
931: l_object_version_number NUMBER;
932:
933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;
934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;
935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;
936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;
937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;
938:

Line 935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;

931: l_object_version_number NUMBER;
932:
933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;
934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;
935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;
936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;
937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;
938:
939: l_default_value OKC_XPRT_QUESTIONS_B.default_value%TYPE;

Line 936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;

932:
933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;
934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;
935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;
936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;
937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;
938:
939: l_default_value OKC_XPRT_QUESTIONS_B.default_value%TYPE;
940:

Line 937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;

933: l_question_name OKC_XPRT_QUESTIONS_TL.question_name%TYPE;
934: l_source_lang OKC_XPRT_QUESTIONS_TL.source_lang%TYPE;
935: l_lang OKC_XPRT_QUESTIONS_TL.language%TYPE;
936: l_description OKC_XPRT_QUESTIONS_TL.description%TYPE;
937: l_prompt OKC_XPRT_QUESTIONS_TL.prompt%TYPE;
938:
939: l_default_value OKC_XPRT_QUESTIONS_B.default_value%TYPE;
940:
941: l_val_question_name_flag VARCHAR2(1) := 'N';

Line 989: FROM okc_xprt_questions_tl

985:
986:
987: SELECT question_name, language, source_lang, description, prompt
988: INTO l_question_name, l_lang, l_source_lang, l_description, l_prompt
989: FROM okc_xprt_questions_tl
990: WHERE question_id = p_xprt_update_question_rec.qn_const_id
991: AND language =
992: Decode(p_xprt_update_question_rec.lang,OKC_API.G_MISS_CHAR, UserEnv('lang'),
993: NULL,UserEnv('lang')

Line 1246: UPDATE okc_xprt_questions_tl

1242: last_update_login = p_xprt_update_question_rec.last_update_login
1243:
1244: WHERE question_id = p_xprt_update_question_rec.qn_const_id;
1245:
1246: UPDATE okc_xprt_questions_tl
1247: SET question_name = p_xprt_update_question_rec.qn_const_name,
1248: description = p_xprt_update_question_rec.description,
1249: prompt = p_xprt_update_question_rec.prompt,
1250: last_updated_by = p_xprt_update_question_rec.last_updated_by,