DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_USER_ATTRS_DATA_PVT

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

127: ) IS
128: BEGIN
129: null;
130: -- sri_debug('EGOPEFCB '||msg);
131: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);
132: -- dbms_output.put_line(msg);
133: END code_debug;
134:
135: --

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

1801: l_col_string := l_col_string || 'NULL';
1802: ELSE
1803: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1804: IF (p_use_binds) THEN
1805: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_col_value));
1806: END IF;
1807: l_col_string := l_col_string || l_col_value;
1808: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1809: IF (p_use_binds) THEN

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

1806: END IF;
1807: l_col_string := l_col_string || l_col_value;
1808: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1809: IF (p_use_binds) THEN
1810: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => l_col_value);
1811: END IF;
1812: l_col_string := l_col_string ||''''|| l_col_value ||'''';
1813: END IF;
1814: END IF;

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

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

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

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

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

1897: l_next_element := SUBSTR(p_col_name_value_pairs(l_col_values_index).VALUE
1898: ,l_prev_string_index
1899: ,l_string_index - l_prev_string_index);
1900: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1901: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_next_element));
1902: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1903: l_val_begin_pos := INSTR(l_next_element, '''') + 1;
1904: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>
1905: SUBSTR(l_next_element,l_val_begin_pos,

Line 1904: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>

1900: IF (l_col_type = 'NUMBER' OR l_col_type = 'INTEGER') THEN
1901: EGO_USER_ATTRS_DATA_PVT.Add_Bind(p_value => TO_NUMBER(l_next_element));
1902: ELSIF (l_col_type = 'VARCHAR' OR l_col_type = 'VARCHAR2') THEN
1903: l_val_begin_pos := INSTR(l_next_element, '''') + 1;
1904: EGO_USER_ATTRS_DATA_PVT.Add_Bind( p_value =>
1905: SUBSTR(l_next_element,l_val_begin_pos,
1906: INSTR(l_next_element, '''', -1, 1) - l_val_begin_pos)
1907: );
1908: END IF;