APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on DUAL

Line 1627: FROM DUAL;

1623: a literal string like 'START' or 'END' for the runtime message parsing to happen correctly
1624: */
1625: SELECT SUBSTR (l_string, 1, 1), SUBSTR (l_string, -1, 1)
1626: INTO l_begin, l_end
1627: FROM DUAL;
1628: IF (l_begin = '''' AND l_end = '''')
1629: THEN
1630: l_output := RTRIM (LTRIM (l_string, ''''), '''');
1631: --DBMS_OUTPUT.put_line ('l_output=' || l_output);

Line 1641: FROM DUAL;

1637: l_char_count := l_char_count + 1;
1638: --We assume that , will be the delimiter always here
1639: SELECT INSTR (l_string, ',', 1, l_char_count)
1640: INTO l_instr_output
1641: FROM DUAL;
1642: SELECT SUBSTR (l_string,
1643: l_start_position,
1644: ( DECODE (l_instr_output,
1645: 0, LENGTH (l_string)+1,

Line 1652: FROM DUAL;

1648: - l_start_position
1649: )
1650: )
1651: INTO l_ascii_value
1652: FROM DUAL;
1653: l_output := l_output || fnd_global.local_chr (l_ascii_value);
1654: l_start_position := l_instr_output + 1;
1655: END LOOP;
1656: RETURN l_output;

Line 1985: FROM DUAL;

1981: LOOP
1982: l_no_of_msg_comps := l_no_of_msg_comps + 1;
1983: SELECT INSTR (l_msg, l_param_delimiter, 1, l_no_of_msg_comps)
1984: INTO l_instr_output
1985: FROM DUAL;
1986: SELECT SUBSTR (l_msg,
1987: l_start_position,
1988: ( DECODE (l_instr_output,
1989: 0, LENGTH (l_msg) + 1,

Line 1996: FROM DUAL;

1992: - l_start_position
1993: )
1994: )
1995: INTO l_msg_component
1996: FROM DUAL;
1997: DECLARE
1998: BEGIN
1999: wms_carousel_integration_pvt.get_component_details
2000: (p_device_id => l_device_id,

Line 2057: FROM DUAL;

2053: l_start_position,
2054: l_comp_record.component_length
2055: )
2056: INTO l_substr_output
2057: FROM DUAL;
2058: /*
2059: LOG (p_device_id, 'l_substr_output: ''' || l_substr_output
2060: || ''''
2061: );

Line 2140: FROM DUAL;

2136: --LOG(p_device_id, 'l_delimiter: '||l_delimiter);
2137: --LOG(p_device_id, 'l_occurrence: '||l_occurrence);
2138: SELECT INSTR (l_msg, l_delimiter, 1, l_occurrence)
2139: INTO l_instr_output
2140: FROM DUAL;
2141: --LOG(p_device_id, 'l_instr_output: '||l_instr_output);
2142: SELECT SUBSTR (l_msg,
2143: l_start_position,
2144: ( DECODE (l_instr_output,

Line 2152: FROM DUAL;

2148: - l_start_position
2149: )
2150: )
2151: INTO l_msg_component
2152: FROM DUAL;
2153: --LOG('p_device_id, l_msg_component: '||l_msg_component);
2154: BEGIN
2155: wms_carousel_integration_pvt.get_component_details
2156: (p_device_id => l_device_id,