DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_USER_ATTRS_DATA_PVT

Line 122: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);

118: ) IS
119: BEGIN
120: null;
121: -- sri_debug('EGOPEFCB '||msg);
122: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);
123: END code_debug;
124:
125: ----------------------------------------------------------------------
126: PROCEDURE Reset_Cache_And_Globals

Line 1694: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));

1690: l_col_string := l_col_string || 'NULL';
1691: ELSE
1692: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1693: IF (p_use_binds) THEN
1694: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));
1695: END IF;
1696: l_col_string := l_col_string || l_col_value;
1697: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1698: IF (p_use_binds) THEN

Line 1699: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);

1695: END IF;
1696: l_col_string := l_col_string || l_col_value;
1697: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1698: IF (p_use_binds) THEN
1699: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);
1700: END IF;
1701: l_col_string := l_col_string ||''''|| l_col_value ||'''';
1702: END IF;
1703: END IF;

Line 1715: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));

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
1719: IF (p_use_binds) THEN

Line 1721: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);

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;
1725: END IF;

Line 1790: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_next_element));

1786: l_next_element := SUBSTR(p_col_name_value_pairs(l_col_values_index).VALUE
1787: ,l_prev_string_index
1788: ,l_string_index - l_prev_string_index);
1789: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1790: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_next_element));
1791: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1792: l_val_begin_pos := INSTR(l_next_element, '''') + 1;
1793: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>
1794: SUBSTR(l_next_element,l_val_begin_pos,

Line 1793: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>

1789: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1790: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_next_element));
1791: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1792: l_val_begin_pos := INSTR(l_next_element, '''') + 1;
1793: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>
1794: SUBSTR(l_next_element,l_val_begin_pos,
1795: INSTR(l_next_element, '''', -1, 1) - l_val_begin_pos)
1796: );
1797: END IF;