APPS.CN_SCA_UTL_PVT dependencies on FND_VSET

Line 35: l_valueset_r fnd_vset.valueset_r;

31:
32: END debugmsg;
33:
34: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
35: l_valueset_r fnd_vset.valueset_r;
36: l_table_r fnd_vset.table_r;
37: l_valueset_dr fnd_vset.valueset_dr;
38: l_select_stmt VARCHAR2(4000);
39: l_select VARCHAR2(4000);

Line 36: l_table_r fnd_vset.table_r;

32: END debugmsg;
33:
34: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
35: l_valueset_r fnd_vset.valueset_r;
36: l_table_r fnd_vset.table_r;
37: l_valueset_dr fnd_vset.valueset_dr;
38: l_select_stmt VARCHAR2(4000);
39: l_select VARCHAR2(4000);
40: l_from VARCHAR2(4000);

Line 37: l_valueset_dr fnd_vset.valueset_dr;

33:
34: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
35: l_valueset_r fnd_vset.valueset_r;
36: l_table_r fnd_vset.table_r;
37: l_valueset_dr fnd_vset.valueset_dr;
38: l_select_stmt VARCHAR2(4000);
39: l_select VARCHAR2(4000);
40: l_from VARCHAR2(4000);
41: l_where VARCHAR2(4000);

Line 44: fnd_vset.get_valueset(l_valueset_id, l_valueset_r, l_valueset_dr);

40: l_from VARCHAR2(4000);
41: l_where VARCHAR2(4000);
42: BEGIN
43: -- get the SQL statement for the record qroup
44: fnd_vset.get_valueset(l_valueset_id, l_valueset_r, l_valueset_dr);
45: l_select := l_valueset_r.table_info.value_column_name ||' column_name, ' ||
46: NVL(l_valueset_r.table_info.id_column_name, 'null') || ' column_id, ' ||
47: NVL(l_valueset_r.table_info.meaning_column_name, 'null') || ' column_meaning';
48: