APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on WMS_MSG_COMPONENTS

Line 1683: FROM wms_msg_components

1679: left_or_right_padded, padding_character, start_component_delimiter,
1680: end_component_delimiter
1681: FROM (SELECT wmc.*, ROWNUM rnum
1682: FROM (SELECT *
1683: FROM wms_msg_components
1684: WHERE template_id = p_templ_id
1685: ORDER BY sequence_id) wmc
1686: WHERE ROWNUM <= p_comp_no)
1687: WHERE rnum >= p_comp_no;

Line 1793: FROM wms_msg_components

1789: WHERE template_id = p_templ_id;
1790: CURSOR msg_component_records (p_templ_id NUMBER)
1791: IS
1792: SELECT *
1793: FROM wms_msg_components
1794: WHERE template_id = p_templ_id
1795: ORDER BY sequence_id;
1796: l_template_record msg_template_record%ROWTYPE;
1797: l_component_record wms_msg_components%ROWTYPE;

Line 1797: l_component_record wms_msg_components%ROWTYPE;

1793: FROM wms_msg_components
1794: WHERE template_id = p_templ_id
1795: ORDER BY sequence_id;
1796: l_template_record msg_template_record%ROWTYPE;
1797: l_component_record wms_msg_components%ROWTYPE;
1798: l_return_status VARCHAR2 (1);
1799: l_msg_count NUMBER;
1800: l_msg_data VARCHAR2 (240);
1801: l_device_id NUMBER;