APPS.CN_SCA_CRRULEATTR_PVT dependencies on FND_FLEX_VALUE_SETS

Line 32: -- l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

28: -- l_api_name CONSTANT VARCHAR2(30) := 'Get_Credit_Rule_Attr';
29: -- l_api_version CONSTANT NUMBER := 1.0;
30: --
31: -- l_counter NUMBER;
32: -- l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
33: -- l_user_src_name VARCHAR2(50);
34: --
35: -- CURSOR get_value_set_name(x number) IS
36: -- SELECT flex_value_set_name

Line 37: -- FROM fnd_flex_value_Sets

33: -- l_user_src_name VARCHAR2(50);
34: --
35: -- CURSOR get_value_set_name(x number) IS
36: -- SELECT flex_value_set_name
37: -- FROM fnd_flex_value_Sets
38: -- WHERE flex_value_set_id = x;
39:
40: -- CURSOR get_user_src_name(x_src_name VARCHAR2) IS
41: -- SELECT /*+ ORDERED*/ a.user_name from cn_objects b, cn_objects a

Line 161: -- --select flex_value_set_name into x_credit_rule_attr(l_counter).value_set_name from fnd_flex_value_Sets where flex_value_Set_id = l_credit_rule_attr.VALUE_SET_ID;

157: -- OPEN get_value_set_name(l_credit_rule_attr_search.VALUE_SET_ID);
158: -- FETCH get_value_set_name INTO l_value_set_name;
159: --
160: -- close get_value_set_name;
161: -- --select flex_value_set_name into x_credit_rule_attr(l_counter).value_set_name from fnd_flex_value_Sets where flex_value_Set_id = l_credit_rule_attr.VALUE_SET_ID;
162: -- x_credit_rule_attr(l_counter).value_set_name := l_value_set_name;
163: -- END IF;
164: --
165: --

Line 198: -- --select flex_value_set_name into x_credit_rule_attr(l_counter).value_set_name from fnd_flex_value_Sets where flex_value_Set_id = l_credit_rule_attr.VALUE_SET_ID;

194: -- OPEN get_value_set_name(l_credit_rule_attr.VALUE_SET_ID);
195: -- FETCH get_value_set_name INTO l_value_set_name;
196: --
197: -- close get_value_set_name;
198: -- --select flex_value_set_name into x_credit_rule_attr(l_counter).value_set_name from fnd_flex_value_Sets where flex_value_Set_id = l_credit_rule_attr.VALUE_SET_ID;
199: -- x_credit_rule_attr(l_counter).value_set_name := l_value_set_name;
200: -- END IF;
201: --
202: -- l_counter := l_counter + 1;

Line 289: -- FROM fnd_flex_value_Sets

285:
286:
287: /*-- CURSOR get_value_set_id IS
288: -- SELECT nvl(flex_value_set_id,0)
289: -- FROM fnd_flex_value_Sets
290: -- WHERE flex_value_set_name = p_credit_rule_attr_rec.value_set_name;*/
291:
292:
293: BEGIN

Line 512: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

508: l_null_date CONSTANT DATE := to_date('31-12-3000','DD-MM-YYYY');
509: l_dummy NUMBER;
510: l_old_ovn NUMBER;
511: -- l_sca_rule_attribute_id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE;
512: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;
514:
515: -- CURSOR get_value_set_id IS
516: -- SELECT flex_value_set_id

Line 517: -- FROM fnd_flex_value_Sets

513: l_trx_source_column cn_sca_rule_attributes.trx_src_column_name%TYPE;
514:
515: -- CURSOR get_value_set_id IS
516: -- SELECT flex_value_set_id
517: -- FROM fnd_flex_value_Sets
518: -- WHERE flex_value_set_name = p_credit_rule_attr_rec.value_set_name;
519:
520: BEGIN
521: