APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_LINE_ACKS

Line 819: Insert Into OE_LINE_ACKS (header_id, line_id,

815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;
817: END IF;
818:
819: Insert Into OE_LINE_ACKS (header_id, line_id,
820: acknowledgment_type, last_ack_code, request_id,
821: sold_to_org_id, change_sequence)
822: Values (p_line_rec.header_id, p_line_rec.line_id,
823: p_ack_type, p_line_status,

Line 1125: From oe_line_acks

1121: l_msg_data VARCHAR2(2000);
1122:
1123: Cursor Line_Ack_Cur Is
1124: Select Line_Id
1125: From oe_line_acks
1126: Where header_id = l_header_id
1127: And acknowledgment_type = l_acknowledgment_type
1128: And decode(l_customer_key_profile, 'Y',
1129: nvl(sold_to_org_id, -999), 1)

Line 1145: From oe_line_acks

1141: nvl(p_sold_to_org_id, -999), 1);
1142:
1143: Cursor SSO_Line_Ack_Cur Is
1144: Select Line_Id, Last_Ack_Code
1145: From oe_line_acks
1146: Where header_id = l_header_id
1147: And acknowledgment_type = l_acknowledgment_type
1148: And request_id = l_request_id
1149: And decode(l_customer_key_profile, 'Y',