Update Line Type Personalization in Requisition form

Update Line Type Personalization in Requisition form

present condition

:LINES.QUANTITY is null and

:LINES.CREATION_DATE >to_date('26-APR-2011' ,'DD-MON-YYYY') or

:LINES.CREATION_DATE is null

exists condition

:LINES.CREATION_DATE >to_date('26-APR-2011' ,'DD-MON-YYYY') or

:LINES.CREATION_DATE is null

PO Line Update in PO

seq - 62

Description  - Update PO Line Type

Trigger Event - WHEN-NEW-ITEM-INSTANCE

Trigger Object - PO_LINES.ITEM_NUMBER_MIR

Condition –

:PO_LINES.CREATION_DATE >to_date(' 26-APR-2011' ,'DD-MON-YYYY') or

:PO_LINES.CREATION_DATE is null

Processing Mode – Both

seq – 10

Type – Property

Object Type – Item

Target Object – PO_LINES.LINE_TYPE

Property Value – VALUE

Value -- =APPS.xxidea_get_po_line_type(:PO_LINES.ITEM_ID)

Promised Date

 

seq - 63

Description  - Promised Date Restriction

Trigger Event - WHEN-NEW-ITEM-INSTANCE

Trigger Object - PO_LINES.TRANSACTION_REASON

Condition –

trunc(to_date(:po_lines.promised_date,'DD-MON-YY HH24:MI:SS')) < trunc(to_date(:po_lines.creation_date,'DD-MON-YY HH24:MI:SS'))

and

:po_headers.doc_type_name ='Standard Purchase Order'

and

:PO_LINES.CREATION_DATE >to_date(' 24-MAY-2011' ,'DD-MON-YYYY')

Processing Mode – Both

 

seq – 10

Type – Message

Message Type – Error

Message Text -- Promise Date must be Equal to or Greater than Line creation date.

Seq – 11

Type – Builtin

Builtin  Type --  GO_ITEM

Argument -- PO_LINES.PROMISED_DATE

Promised Date Mandatory for each line

Seq – 73

Description -- Promised Date must be Equal to or Greater than Creation Date

Trigger Event -- WHEN-NEW-RECORD-INSTANCE

Trigger Object -- PO_APPROVE

Condition  --   APPS.xxidea_get_line_count_promised(:PO_HEADERS.PO_HEADER_ID)>0

Processing Mode – Not in Enter-Query Mode

Seq – 10

Type – Type

Builtin Type – GO_ITEM

Argument -- PO_LINES.PROMISED_DATE

Seq – 11

Type – Message

Message Type – Error

Message Text -- Promise Date must be Equal to or Greater than Line creation date on all Lines.

Free Of Cost

Seq – 64.1

Description -- FOC  - Market Price Mandatory when click on ok

Trigger Event -- WHEN-NEW-ITEM-INSTANCE

Trigger Object -- PO_LINES.LINE_NUM

Condition –

:PO_LINES.TRANSACTION_REASON_CODE IN ('FOC-Y')

AND :PO_HEADERS.DOC_TYPE_NAME = 'Standard Purchase Order'

Processing Mode – Both

Seq – 10

Type – Builtin

Builtin Type – GO_ITEM

Argument -- PO_LINES.LIST_PRICE_PER_UNIT