APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on FND_DSQL

Line 1745: FND_DSQL.Add_Text(p_prefix);

1741: -- element. --
1742: --------------------------------------------------------
1743: IF (i = p_col_metadata_array.FIRST) THEN
1744: IF (p_use_binds) THEN
1745: FND_DSQL.Add_Text(p_prefix);
1746: END IF;
1747: l_col_string := l_col_string || p_prefix;
1748: ELSE
1749: IF (p_use_binds) THEN

Line 1750: FND_DSQL.Add_Text(l_separator);

1746: END IF;
1747: l_col_string := l_col_string || p_prefix;
1748: ELSE
1749: IF (p_use_binds) THEN
1750: FND_DSQL.Add_Text(l_separator);
1751: END IF;
1752: l_col_string := l_col_string || l_separator;
1753: END IF;
1754:

Line 1792: FND_DSQL.Add_Text(l_col_name);

1788: -- 4). Add this column's info to the list --
1789: --------------------------------------------
1790: IF (UPPER(p_mode) = 'NAMES') THEN
1791: IF (p_use_binds) THEN
1792: FND_DSQL.Add_Text(l_col_name);
1793: END IF;
1794: l_col_string := l_col_string || l_col_name;
1795:
1796: ELSIF (UPPER(p_mode) = 'VALUES' OR UPPER(p_mode) = 'VALUES_ALL_CC') THEN

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

1795:
1796: ELSIF (UPPER(p_mode) = 'VALUES' OR UPPER(p_mode) = 'VALUES_ALL_CC') THEN
1797: IF (l_col_value IS NULL) THEN
1798: IF (p_use_binds) THEN
1799: FND_DSQL.Add_Text('NULL');
1800: END IF;
1801: l_col_string := l_col_string || 'NULL';
1802: ELSE
1803: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN

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

1815:
1816: ELSIF (UPPER(p_mode) = 'EQUALS') THEN
1817: IF (l_col_value IS NULL) THEN
1818: IF (p_use_binds) THEN
1819: FND_DSQL.Add_Text(l_col_name || ' IS NULL');
1820: END IF;
1821: l_col_string := l_col_string || l_col_name || ' IS NULL';
1822: ELSE
1823: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN

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

1821: l_col_string := l_col_string || l_col_name || ' IS NULL';
1822: ELSE
1823: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1824: IF (p_use_binds) THEN
1825: FND_DSQL.Add_Text(l_col_name || ' = ');
1826: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));
1827: END IF;
1828: l_col_string := l_col_string || l_col_name || ' = ' || l_col_value;
1829: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN

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

1827: END IF;
1828: l_col_string := l_col_string || l_col_name || ' = ' || l_col_value;
1829: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1830: IF (p_use_binds) THEN
1831: FND_DSQL.Add_Text(l_col_name || ' = ');
1832: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);
1833: END IF;
1834: l_col_string := l_col_string ||l_col_name || ' = ''' || l_col_value || '''';
1835: END IF;

Line 1868: FND_DSQL.Add_Text(l_separator);

1864: -- Append the separator to the previous list element --
1865: -------------------------------------------------------
1866: IF (LENGTH(l_col_string) > 0) THEN
1867: IF (p_use_binds) THEN
1868: FND_DSQL.Add_Text(l_separator);
1869: END IF;
1870: l_col_string := l_col_string || l_separator;
1871: ELSE
1872: IF (p_use_binds) THEN

Line 1873: FND_DSQL.Add_Text(p_prefix);

1869: END IF;
1870: l_col_string := l_col_string || l_separator;
1871: ELSE
1872: IF (p_use_binds) THEN
1873: FND_DSQL.Add_Text(p_prefix);
1874: END IF;
1875: l_col_string := l_col_string || p_prefix;
1876: END IF;
1877:

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

1909:
1910: EXIT WHEN (l_is_last_element);
1911:
1912: l_prev_string_index := l_string_index + 1;
1913: FND_DSQL.Add_Text(', ');
1914:
1915: END LOOP;
1916:
1917: END IF;