应用 |
Oracle Purchasing |
层 Level |
Function |
||||||
函数名 Funcgtion Name |
MT_POXPOEPO |
表单名 Form Name |
POXPOEPO |
||||||
说明 Description |
有效日期不能重叠 |
||||||||
条件 Condition |
触发器事件 Tirgger Event |
WHEN-VALIDATE-RECORD |
|||||||
触发器对象 Tirgger Object |
PO_SHIPMENTS |
||||||||
条件 Condition |
((select count(*) from PO_LINE_LOCATIONS_all where po_header_id = :PO_SHIPMENTS.PO_HEADER_ID and po_line_id = :PO_SHIPMENTS.PO_LINE_ID and :PO_SHIPMENTS.START_DATE between start_date and nvl(end_date,sysdate)) > 0 OR (select count(*) from PO_LINE_LOCATIONS_all where po_header_id = :PO_SHIPMENTS.PO_HEADER_ID and po_line_id = :PO_SHIPMENTS.PO_LINE_ID and :PO_SHIPMENTS.end_DATE between start_date and nvl(end_date,sysdate) ) > 0) AND :PO_SHIPMENTS.CREATION_DATE IS NULL AND (SELECT COUNT(*) from PO_LINE_LOCATIONS_all where po_header_id = :PO_SHIPMENTS.PO_HEADER_ID and po_line_id = :PO_SHIPMENTS.PO_LINE_ID) >0 |
||||||||
处理模式 Processing Mode |
Not in Enter-Query Mode |
||||||||
上下文 层/值 Contest Level/Value |
Responsibility/***职责 |
||||||||
活动 Actions |
序号 seq |
特性 Type |
说明 Description |
语言 Language |
消息类型 Message Type |
Error |
|||
10 |
Message |
/ |
ALL |
消息文本 Message Type |
有效时间不能重叠!空白表示当前日期! 请确认时间的起止! |
||||
20 |
Builtin |
/ |
ALL |
内置类型 Builtin Type |
RAISE FORM_TIRGGER_FAILURE |
||||
处理模式 |
讯息提醒模式 |
||||||||
作业 |
讯息型态:显示 |
||||||||
讯息内容: 有效时间不能重叠!空白表示当前日期! 请确认时间的起止! |