APPS.OE_UPDATE_ACK_UTIL dependencies on OE_LINE_ACKS

Line 151: from oe_line_acks

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

Line 176: UPDATE oe_line_acks

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

Line 183: UPDATE oe_line_acks

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

Line 211: from oe_line_acks

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

Line 237: UPDATE oe_line_acks

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

Line 383: From Oe_Line_Acks

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

Line 979: Update Oe_Line_Acks

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