APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_MSG_COMPONENTS

Line 1693: FROM wms_msg_components

1689: left_or_right_padded, padding_character, start_component_delimiter,
1690: end_component_delimiter
1691: FROM (SELECT wmc.*, ROWNUM rnum
1692: FROM (SELECT *
1693: FROM wms_msg_components
1694: WHERE template_id = p_templ_id
1695: ORDER BY sequence_id) wmc
1696: WHERE ROWNUM <= p_comp_no)
1697: WHERE rnum >= p_comp_no;

Line 1803: FROM wms_msg_components

1799: WHERE template_id = p_templ_id;
1800: CURSOR msg_component_records (p_templ_id NUMBER)
1801: IS
1802: SELECT *
1803: FROM wms_msg_components
1804: WHERE template_id = p_templ_id
1805: ORDER BY sequence_id;
1806: l_template_record msg_template_record%ROWTYPE;
1807: l_component_record wms_msg_components%ROWTYPE;

Line 1807: l_component_record wms_msg_components%ROWTYPE;

1803: FROM wms_msg_components
1804: WHERE template_id = p_templ_id
1805: ORDER BY sequence_id;
1806: l_template_record msg_template_record%ROWTYPE;
1807: l_component_record wms_msg_components%ROWTYPE;
1808: l_return_status VARCHAR2 (1);
1809: l_msg_count NUMBER;
1810: l_msg_data VARCHAR2 (240);
1811: l_device_id NUMBER;