DBA Data[Home] [Help]

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on FND_GLOBAL

Line 1580: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(10));

1576: -- Msg: HZ_API_USE_TAB_CAT = 'There is no usage for '||p_owner_table_name||' table in '||p_class_category||' category.'
1577: ELSE
1578: result := 'Y';
1579: x_column_name := l_column_name;
1580: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(10));
1581: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(32));
1582: l_add_where_clause := RTRIM(l_add_where_clause,';');
1583: x_statement := 'SELECT ' || l_column_name || ' FROM ' || p_owner_table_name || FND_GLOBAL.LOCAL_CHR(10);
1584: IF l_add_where_clause IS NOT NULL THEN

Line 1581: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(32));

1577: ELSE
1578: result := 'Y';
1579: x_column_name := l_column_name;
1580: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(10));
1581: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(32));
1582: l_add_where_clause := RTRIM(l_add_where_clause,';');
1583: x_statement := 'SELECT ' || l_column_name || ' FROM ' || p_owner_table_name || FND_GLOBAL.LOCAL_CHR(10);
1584: IF l_add_where_clause IS NOT NULL THEN
1585: x_statement := x_statement || l_add_where_clause || ' AND ';

Line 1583: x_statement := 'SELECT ' || l_column_name || ' FROM ' || p_owner_table_name || FND_GLOBAL.LOCAL_CHR(10);

1579: x_column_name := l_column_name;
1580: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(10));
1581: l_add_where_clause := RTRIM(l_add_where_clause,FND_GLOBAL.LOCAL_CHR(32));
1582: l_add_where_clause := RTRIM(l_add_where_clause,';');
1583: x_statement := 'SELECT ' || l_column_name || ' FROM ' || p_owner_table_name || FND_GLOBAL.LOCAL_CHR(10);
1584: IF l_add_where_clause IS NOT NULL THEN
1585: x_statement := x_statement || l_add_where_clause || ' AND ';
1586: ELSE
1587: x_statement := x_statement || ' WHERE ';