APPS.OKC_RUL_PVT dependencies on OKC_DDF_CONTEXTCODE_TMP

Line 46: FROM okc_ddf_contextcode_tmp

42: ,required_flag
43: ,application_column_name
44: ,seq_no
45: ,form_left_prompt
46: FROM okc_ddf_contextcode_tmp
47: WHERE descriptive_flex_context_code = p_context_code
48: ORDER BY seq_no;
49:
50: CURSOR c_descr_flex_col (p_context_code varchar2) IS

Line 6461: FROM okc_ddf_contextcode_tmp

6457: IS
6458:
6459: CURSOR csr_tmp (p_context_code IN VARCHAR2) is
6460: SELECT 'Y'
6461: FROM okc_ddf_contextcode_tmp
6462: WHERE descriptive_flex_context_code = p_context_code;
6463:
6464: l_found VARCHAR2(10) := 'N';
6465: l_app_col_name VARCHAR2(30) := 'RULE_INFORMATION%';

Line 6483: INSERT INTO okc_ddf_contextcode_tmp

6479: -- /striping/
6480: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
6481: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
6482:
6483: INSERT INTO okc_ddf_contextcode_tmp
6484: (descriptive_flex_context_code, end_user_column_name, flex_value_set_id,
6485: required_flag, application_column_name, seq_no, form_left_prompt)
6486: SELECT
6487: descriptive_flex_context_code,

Line 6511: (SELECT 1 FROM okc_ddf_contextcode_tmp

6507: AND B.scs_code = K.scs_code
6508: AND k.id = p_rulv_rec.dnz_chr_id
6509: )
6510: AND NOT EXISTS
6511: (SELECT 1 FROM okc_ddf_contextcode_tmp
6512: WHERE descriptive_flex_context_code =
6513: dfcu.descriptive_flex_context_code
6514: AND application_column_name =
6515: dfcu.application_column_name);