DBA Data[Home] [Help]

APPS.OE_CANCEL dependencies on SO_HEADERS

Line 101: -- Update the SO_HEADERS table to reflect that the Order has been

97:
98: ------------------------------------------------------------------------
99: -- procedure UPDATE_HEADER_INFO
100:
101: -- Update the SO_HEADERS table to reflect that the Order has been
102: -- cancelled. This is done by setting the S4 (Cancel Order) column
103: -- to 11 (Complete). Then the lines in the SO_LINES table are also
104: -- updated to reflect the order cancellation. The open_flag is set
105: -- to null, the cancelled_quantity is set to ordered_quantity

Line 147: UPDATE SO_HEADERS

143: --
144: -- Set the S values for the headers, specifically set S4 (Cancel Order) to
145: -- 11 (Complete)
146: --
147: UPDATE SO_HEADERS
148: SET S1 = DECODE(S1,18,'',S1),
149: S1_DATE = DECODE(S1,18,'',S1_DATE),
150: S2 = DECODE(S2,18,'',S2),
151: S2_DATE = DECODE(S2,18,'',S2_DATE),