APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on FND_DSQL

Line 1634: FND_DSQL.Add_Text(p_prefix);

1630: -- element. --
1631: --------------------------------------------------------
1632: IF (i = p_col_metadata_array.FIRST) THEN
1633: IF (p_use_binds) THEN
1634: FND_DSQL.Add_Text(p_prefix);
1635: END IF;
1636: l_col_string := l_col_string || p_prefix;
1637: ELSE
1638: IF (p_use_binds) THEN

Line 1639: FND_DSQL.Add_Text(l_separator);

1635: END IF;
1636: l_col_string := l_col_string || p_prefix;
1637: ELSE
1638: IF (p_use_binds) THEN
1639: FND_DSQL.Add_Text(l_separator);
1640: END IF;
1641: l_col_string := l_col_string || l_separator;
1642: END IF;
1643:

Line 1681: FND_DSQL.Add_Text(l_col_name);

1677: -- 4). Add this column's info to the list --
1678: --------------------------------------------
1679: IF (UPPER(p_mode) = 'NAMES') THEN
1680: IF (p_use_binds) THEN
1681: FND_DSQL.Add_Text(l_col_name);
1682: END IF;
1683: l_col_string := l_col_string || l_col_name;
1684:
1685: ELSIF (UPPER(p_mode) = 'VALUES' OR UPPER(p_mode) = 'VALUES_ALL_CC') THEN

Line 1688: FND_DSQL.Add_Text('NULL');

1684:
1685: ELSIF (UPPER(p_mode) = 'VALUES' OR UPPER(p_mode) = 'VALUES_ALL_CC') THEN
1686: IF (l_col_value IS NULL) THEN
1687: IF (p_use_binds) THEN
1688: FND_DSQL.Add_Text('NULL');
1689: END IF;
1690: l_col_string := l_col_string || 'NULL';
1691: ELSE
1692: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN

Line 1708: FND_DSQL.Add_Text(l_col_name || ' IS NULL');

1704:
1705: ELSIF (UPPER(p_mode) = 'EQUALS') THEN
1706: IF (l_col_value IS NULL) THEN
1707: IF (p_use_binds) THEN
1708: FND_DSQL.Add_Text(l_col_name || ' IS NULL');
1709: END IF;
1710: l_col_string := l_col_string || l_col_name || ' IS NULL';
1711: ELSE
1712: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN

Line 1714: FND_DSQL.Add_Text(l_col_name || ' = ');

1710: l_col_string := l_col_string || l_col_name || ' IS NULL';
1711: ELSE
1712: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1713: IF (p_use_binds) THEN
1714: FND_DSQL.Add_Text(l_col_name || ' = ');
1715: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));
1716: END IF;
1717: l_col_string := l_col_string || l_col_name || ' = ' || l_col_value;
1718: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN

Line 1720: FND_DSQL.Add_Text(l_col_name || ' = ');

1716: END IF;
1717: l_col_string := l_col_string || l_col_name || ' = ' || l_col_value;
1718: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1719: IF (p_use_binds) THEN
1720: FND_DSQL.Add_Text(l_col_name || ' = ');
1721: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);
1722: END IF;
1723: l_col_string := l_col_string ||l_col_name || ' = ''' || l_col_value || '''';
1724: END IF;

Line 1757: FND_DSQL.Add_Text(l_separator);

1753: -- Append the separator to the previous list element --
1754: -------------------------------------------------------
1755: IF (LENGTH(l_col_string) > 0) THEN
1756: IF (p_use_binds) THEN
1757: FND_DSQL.Add_Text(l_separator);
1758: END IF;
1759: l_col_string := l_col_string || l_separator;
1760: ELSE
1761: IF (p_use_binds) THEN

Line 1762: FND_DSQL.Add_Text(p_prefix);

1758: END IF;
1759: l_col_string := l_col_string || l_separator;
1760: ELSE
1761: IF (p_use_binds) THEN
1762: FND_DSQL.Add_Text(p_prefix);
1763: END IF;
1764: l_col_string := l_col_string || p_prefix;
1765: END IF;
1766:

Line 1802: FND_DSQL.Add_Text(', ');

1798:
1799: EXIT WHEN (l_is_last_element);
1800:
1801: l_prev_string_index := l_string_index + 1;
1802: FND_DSQL.Add_Text(', ');
1803:
1804: END LOOP;
1805:
1806: END IF;