APPS.OE_UPDATE_ACK_UTIL dependencies on OE_LINE_ACKS

Line 150: from oe_line_acks

146: BEGIN
147: begin
148: select first_ack_code
149: into l_ack_code
150: from oe_line_acks
151: where header_id = p_header_id
152: and line_id = p_line_id
153: and (first_ack_date is null
154: or first_ack_date = l_first_ack_date)

Line 175: UPDATE oe_line_acks

171: , first_ack_date = sysdate
172: , lock_control = lock_control + 1
173: WHERE line_id = p_line_id;
174:
175: UPDATE oe_line_acks
176: SET acknowledgment_flag = 'Y'
177: , first_ack_date = sysdate
178: WHERE header_id = p_header_id
179: AND line_id = p_line_id

Line 182: UPDATE oe_line_acks

178: WHERE header_id = p_header_id
179: AND line_id = p_line_id
180: AND (first_ack_date is null
181: OR first_ack_date = l_first_ack_date);
182: UPDATE oe_line_acks
183: SET acknowledgment_flag = 'Y'
184: , first_ack_date = sysdate
185: WHERE header_id = p_header_id
186: AND line_id is null

Line 210: from oe_line_acks

206: BEGIN
207: begin
208: select last_ack_code
209: into l_ack_code
210: from oe_line_acks
211: where header_id = p_header_id
212: and line_id = p_line_id
213: and first_ack_date is not null
214: and last_ack_date is null

Line 236: UPDATE oe_line_acks

232: , first_ack_code = nvl(first_ack_code, l_ack_code)
233: , first_ack_date = nvl(first_ack_date,sysdate)
234: WHERE line_id = p_line_id;
235:
236: UPDATE oe_line_acks
237: SET acknowledgment_flag = 'Y'
238: , last_ack_date = sysdate
239: WHERE header_id = p_header_id
240: AND line_id = p_line_id

Line 382: From Oe_Line_Acks

378: End_Customer_City,
379: End_Customer_State,
380: End_Customer_Postal_Code,
381: End_Customer_Country
382: From Oe_Line_Acks
383: Where Header_id = p_header_id
384: And Acknowledgment_Flag Is Null
385: For Update;
386:

Line 978: Update Oe_Line_Acks

974: End Loop;
975:
976: -- Insert Line Ack Records
977: FORALL i In l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.last
978: Update Oe_Line_Acks
979: Set line_type = l_line_acks_rec.line_type(i),
980: price_list = l_line_acks_rec.price_list(i),
981: salesrep = l_line_acks_rec.salesrep(i),
982: fob_point = l_line_acks_rec.fob_point(i),