APPS.OE_UPDATE_ACK_UTIL dependencies on OE_HEADER_ACKS

Line 30: From oe_header_acks

26: END IF;
27:
28: Select order_source_id, orig_sys_document_ref, request_id
29: into l_order_source_id, l_orig_sys_document_ref, l_request_id
30: From oe_header_acks
31: Where header_id = p_header_id
32: And first_ack_date is null
33: And rownum = 1;
34:

Line 67: UPDATE oe_header_acks

63: , lock_control = lock_control + 1
64: , xml_message_id = l_em_message_id
65: WHERE header_id = p_header_id;
66:
67: UPDATE oe_header_acks
68: SET acknowledgment_flag = 'Y'
69: , first_ack_date = sysdate
70: WHERE header_id = p_header_id
71: AND first_ack_date is null;

Line 100: from oe_header_acks

96: END IF;
97:
98: select last_ack_code
99: into l_ack_code
100: from oe_header_acks
101: where header_id = p_header_id
102: and first_ack_date is not null
103: and last_ack_code is null
104: and rownum = 1;

Line 124: UPDATE oe_header_acks

120: , lock_control = lock_control + 1
121: , xml_message_id = l_em_message_id
122: WHERE header_id = p_header_id;
123:
124: UPDATE oe_header_acks
125: SET acknowledgment_flag = 'Y'
126: , last_ack_date = sysdate
127: WHERE header_id = p_header_id
128: AND first_ack_date is not null

Line 287: From Oe_Header_Acks

283: End_Customer_Id,
284: End_Customer_Contact_Id,
285: End_Customer_Site_Use_Id
286:
287: From Oe_Header_Acks
288: Where Header_Id = p_header_id
289: And Acknowledgment_Flag Is Null
290: For Update;
291: --Added end customer fields for bug 4034441

Line 399: l_header_acks_rec Oe_Header_Acks%ROWTYPE;

395: l_ship_from_address_4 Varchar2(20);
396: l_ship_from_state Varchar2(20);
397: l_ship_from_org_id Number;
398:
399: l_header_acks_rec Oe_Header_Acks%ROWTYPE;
400: l_line_acks_rec OE_Update_Ack_Util.Line_Rec_Type;
401: l_sold_to_org_id Number;
402: l_header_end_customer_location Varchar2(40);
403: l_line_end_customer_location Varchar2(40);

Line 1019: Update Oe_Header_Acks

1015:
1016: End If;
1017:
1018: -- Update data in Acks table
1019: Update Oe_Header_Acks
1020: Set sold_to_address1 = l_header_acks_rec.sold_to_address1,
1021: sold_to_address2 = l_header_acks_rec.sold_to_address2,
1022: sold_to_address3 = l_header_acks_rec.sold_to_address3,
1023: sold_to_address4 = l_header_acks_rec.sold_to_address4,