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 66: UPDATE oe_header_acks

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

Line 99: from oe_header_acks

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

Line 123: UPDATE oe_header_acks

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

Line 286: From Oe_Header_Acks

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

Line 398: l_header_acks_rec Oe_Header_Acks%ROWTYPE;

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

Line 1018: Update Oe_Header_Acks

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