APPS.OKC_RUL_PVT dependencies on OKC_RLD_PVT

Line 566: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);

562: RAISE G_EXCEPTION_HALT_VALIDATION;
563: END IF;
564:
565: -- /striping/
566: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
567: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
568:
569: /* The following part has been changed to check for DFF in case of rule templates */
570: -- check for descriptive flex, it must be defined

Line 567: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);

563: END IF;
564:
565: -- /striping/
566: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
567: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
568:
569: /* The following part has been changed to check for DFF in case of rule templates */
570: -- check for descriptive flex, it must be defined
571: IF (p_rulv_rec.rgp_id IS NULL OR

Line 1189: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);

1185: -- bug 1857663
1186: -- FROM clause missing in the sql_stmt constructed below
1187:
1188: -- /striping/
1189: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
1190: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
1191:
1192: sql_stmt := 'SELECT ''x'' ' ||
1193: ' FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu ' ||

Line 1190: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);

1186: -- FROM clause missing in the sql_stmt constructed below
1187:
1188: -- /striping/
1189: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
1190: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
1191:
1192: sql_stmt := 'SELECT ''x'' ' ||
1193: ' FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu ' ||
1194: -- ' WHERE dfcu.descriptive_flexfield_name = ' || -- /striping/

Line 6480: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);

6476: RETURN;
6477: END IF;
6478:
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,

Line 6481: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);

6477: END IF;
6478:
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)

Line 6565: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);

6561: RETURN;
6562: END IF;
6563:
6564: -- /striping/
6565: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
6566: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
6567:
6568: INSERT INTO okc_obj_ddf_ctxcode_tmp
6569: (descriptive_flex_context_code, dummy_col, seq_no, form_left_prompt)

Line 6566: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);

6562: END IF;
6563:
6564: -- /striping/
6565: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
6566: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
6567:
6568: INSERT INTO okc_obj_ddf_ctxcode_tmp
6569: (descriptive_flex_context_code, dummy_col, seq_no, form_left_prompt)
6570: SELECT