APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on DUAL

Line 1637: FROM DUAL;

1633: a literal string like 'START' or 'END' for the runtime message parsing to happen correctly
1634: */
1635: SELECT SUBSTR (l_string, 1, 1), SUBSTR (l_string, -1, 1)
1636: INTO l_begin, l_end
1637: FROM DUAL;
1638: IF (l_begin = '''' AND l_end = '''')
1639: THEN
1640: l_output := RTRIM (LTRIM (l_string, ''''), '''');
1641: --DBMS_OUTPUT.put_line ('l_output=' || l_output);

Line 1651: FROM DUAL;

1647: l_char_count := l_char_count + 1;
1648: --We assume that , will be the delimiter always here
1649: SELECT INSTR (l_string, ',', 1, l_char_count)
1650: INTO l_instr_output
1651: FROM DUAL;
1652: SELECT SUBSTR (l_string,
1653: l_start_position,
1654: ( DECODE (l_instr_output,
1655: 0, LENGTH (l_string)+1,

Line 1662: FROM DUAL;

1658: - l_start_position
1659: )
1660: )
1661: INTO l_ascii_value
1662: FROM DUAL;
1663: l_output := l_output || fnd_global.local_chr (l_ascii_value);
1664: l_start_position := l_instr_output + 1;
1665: END LOOP;
1666: RETURN l_output;

Line 1995: FROM DUAL;

1991: LOOP
1992: l_no_of_msg_comps := l_no_of_msg_comps + 1;
1993: SELECT INSTR (l_msg, l_param_delimiter, 1, l_no_of_msg_comps)
1994: INTO l_instr_output
1995: FROM DUAL;
1996: SELECT SUBSTR (l_msg,
1997: l_start_position,
1998: ( DECODE (l_instr_output,
1999: 0, LENGTH (l_msg) + 1,

Line 2006: FROM DUAL;

2002: - l_start_position
2003: )
2004: )
2005: INTO l_msg_component
2006: FROM DUAL;
2007: DECLARE
2008: BEGIN
2009: wms_carousel_integration_pvt.get_component_details
2010: (p_device_id => l_device_id,

Line 2067: FROM DUAL;

2063: l_start_position,
2064: l_comp_record.component_length
2065: )
2066: INTO l_substr_output
2067: FROM DUAL;
2068: /*
2069: LOG (p_device_id, 'l_substr_output: ''' || l_substr_output
2070: || ''''
2071: );

Line 2150: FROM DUAL;

2146: --LOG(p_device_id, 'l_delimiter: '||l_delimiter);
2147: --LOG(p_device_id, 'l_occurrence: '||l_occurrence);
2148: SELECT INSTR (l_msg, l_delimiter, 1, l_occurrence)
2149: INTO l_instr_output
2150: FROM DUAL;
2151: --LOG(p_device_id, 'l_instr_output: '||l_instr_output);
2152: SELECT SUBSTR (l_msg,
2153: l_start_position,
2154: ( DECODE (l_instr_output,

Line 2162: FROM DUAL;

2158: - l_start_position
2159: )
2160: )
2161: INTO l_msg_component
2162: FROM DUAL;
2163: --LOG('p_device_id, l_msg_component: '||l_msg_component);
2164: BEGIN
2165: wms_carousel_integration_pvt.get_component_details
2166: (p_device_id => l_device_id,