eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RULEATTRIBUTE_PVT dependencies on FND_VSET

Line 1538: l_valueset_r fnd_vset.valueset_r;

1534: );
1535: END;
1536:
1537: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
1538: l_valueset_r fnd_vset.valueset_r;
1539: l_table_r fnd_vset.table_r;
1540: l_valueset_dr fnd_vset.valueset_dr;
1541: l_select_stmt VARCHAR2(4000);
1542: l_select VARCHAR2(4000);

Line 1539: l_table_r fnd_vset.table_r;

1535: END;
1536:
1537: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
1538: l_valueset_r fnd_vset.valueset_r;
1539: l_table_r fnd_vset.table_r;
1540: l_valueset_dr fnd_vset.valueset_dr;
1541: l_select_stmt VARCHAR2(4000);
1542: l_select VARCHAR2(4000);
1543: l_from VARCHAR2(4000);

Line 1540: l_valueset_dr fnd_vset.valueset_dr;

1536:
1537: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS
1538: l_valueset_r fnd_vset.valueset_r;
1539: l_table_r fnd_vset.table_r;
1540: l_valueset_dr fnd_vset.valueset_dr;
1541: l_select_stmt VARCHAR2(4000);
1542: l_select VARCHAR2(4000);
1543: l_from VARCHAR2(4000);
1544: l_where VARCHAR2(4000);

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

1543: l_from VARCHAR2(4000);
1544: l_where VARCHAR2(4000);
1545: BEGIN
1546: -- get the SQL statement for the record qroup
1547: fnd_vset.get_valueset(l_valueset_id, l_valueset_r, l_valueset_dr);
1548: l_select := l_valueset_r.table_info.value_column_name ||' column_name, ' ||
1549: NVL(l_valueset_r.table_info.id_column_name, 'null') || ' column_id, ' ||
1550: NVL(l_valueset_r.table_info.meaning_column_name, 'null') || ' column_meaning';
1551:

Line 1579: l_valueset_r fnd_vset.valueset_r;

1575: x_select OUT NOCOPY VARCHAR2,
1576: x_from OUT NOCOPY VARCHAR2,
1577: x_where OUT NOCOPY VARCHAR2) IS
1578:
1579: l_valueset_r fnd_vset.valueset_r;
1580: l_table_r fnd_vset.table_r;
1581: l_valueset_dr fnd_vset.valueset_dr;
1582: l_select_stmt VARCHAR2(4000);
1583: l_valueset_id cn_objects.value_set_id%TYPE;

Line 1580: l_table_r fnd_vset.table_r;

1576: x_from OUT NOCOPY VARCHAR2,
1577: x_where OUT NOCOPY VARCHAR2) IS
1578:
1579: l_valueset_r fnd_vset.valueset_r;
1580: l_table_r fnd_vset.table_r;
1581: l_valueset_dr fnd_vset.valueset_dr;
1582: l_select_stmt VARCHAR2(4000);
1583: l_valueset_id cn_objects.value_set_id%TYPE;
1584:

Line 1581: l_valueset_dr fnd_vset.valueset_dr;

1577: x_where OUT NOCOPY VARCHAR2) IS
1578:
1579: l_valueset_r fnd_vset.valueset_r;
1580: l_table_r fnd_vset.table_r;
1581: l_valueset_dr fnd_vset.valueset_dr;
1582: l_select_stmt VARCHAR2(4000);
1583: l_valueset_id cn_objects.value_set_id%TYPE;
1584:
1585: l_count NUMBER := 0;

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

1603: FETCH c_get_valueset_id INTO l_valueset_id;
1604: IF c_get_valueset_id%FOUND THEN
1605:
1606: -- get the SQL statement for the record qroup
1607: fnd_vset.get_valueset(l_valueset_id, l_valueset_r, l_valueset_dr);
1608:
1609: IF l_valueset_r.table_info.where_clause IS NULL
1610: THEN
1611: x_select := NVL(l_valueset_r.table_info.id_column_name,