APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WAVE_EXCEPTIONS_S

Line 16224: SELECT wms_WP_WAVE_exceptions_s.NEXTVAL INTO l_seq_val FROM dual; -- Changed

16220: l_msg := l_msg || l_addl_msg;
16221:
16222: print_debug('message for exception is : ' || l_msg, l_debug);
16223:
16224: SELECT wms_WP_WAVE_exceptions_s.NEXTVAL INTO l_seq_val FROM dual; -- Changed
16225:
16226: WMS_WP_WAVE_EXCEPTIONS_PKG.INSERT_ROW(
16227: -- X_ROWID => l_null, --
16228: X_EXCEPTION_ID => l_seq_val,

Line 16279: (wms_WP_WAVE_exceptions_s.nextval,

16275: last_update_date,
16276: last_updated_by,
16277: last_update_login)
16278: VALUES
16279: (wms_WP_WAVE_exceptions_s.nextval,
16280: p_exception_name,
16281: p_exception_entity,
16282: p_progress_stage,
16283: p_exception_level,

Line 16892: SELECT wms_WP_WAVE_exceptions_s.currval INTO l_seq_val FROM dual; -- Changed

16888: (p_entity = 'Delivery' AND delivery_id = p_entity_value) OR
16889: (p_entity = 'Order' AND order_number = p_entity_value) OR
16890: (p_entity = 'Order Line' AND source_line_id = p_entity_value));
16891:
16892: SELECT wms_WP_WAVE_exceptions_s.currval INTO l_seq_val FROM dual; -- Changed
16893: l_update_exception_id := l_seq_val; -- Changed
16894:
16895: UPDATE wms_wp_wave_exceptions_b
16896: SET ready_to_release = l_readytorelease,

Line 16923: SELECT wms_WP_WAVE_exceptions_s.CURRVAL INTO l_seq_val FROM dual; -- Changed

16919: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16920:
16921: IF (p_take_corrective_measures = 'Yes') THEN
16922: -- call api to take corrective measures
16923: SELECT wms_WP_WAVE_exceptions_s.CURRVAL INTO l_seq_val FROM dual; -- Changed
16924: take_corrective_measures(l_seq_val, -- Changed
16925: p_wave_id,
16926: p_entity,
16927: p_entity_value,