APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_LINE_ACKS

Line 824: Insert Into OE_LINE_ACKS (header_id, line_id,

820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;
822: END IF;
823:
824: Insert Into OE_LINE_ACKS (header_id, line_id,
825: acknowledgment_type, last_ack_code, request_id,
826: sold_to_org_id, change_sequence)
827: Values (p_line_rec.header_id, p_line_rec.line_id,
828: p_ack_type, p_line_status,

Line 1130: From oe_line_acks

1126: l_msg_data VARCHAR2(2000);
1127:
1128: Cursor Line_Ack_Cur Is
1129: Select Line_Id
1130: From oe_line_acks
1131: Where header_id = l_header_id
1132: And acknowledgment_type = l_acknowledgment_type
1133: And decode(l_customer_key_profile, 'Y',
1134: nvl(sold_to_org_id, -999), 1)

Line 1150: From oe_line_acks

1146: nvl(p_sold_to_org_id, -999), 1);
1147:
1148: Cursor SSO_Line_Ack_Cur Is
1149: Select Line_Id, Last_Ack_Code
1150: From oe_line_acks
1151: Where header_id = l_header_id
1152: And acknowledgment_type = l_acknowledgment_type
1153: And request_id = l_request_id
1154: And decode(l_customer_key_profile, 'Y',