1405: l_error_message := FND_MESSAGE.GET;
1406:
1407: select count(*)
1408: into l_cnt
1409: from wsh_delivery_details dd,
1410: oe_order_lines l
1411: where l.header_id = p_header_id
1412: and dd.source_line_id = l.line_id
1413: AND dd.org_id = l.org_id
3826: l_error_message := FND_MESSAGE.GET;
3827:
3828: SELECT count(*)
3829: INTO l_cnt
3830: FROM wsh_delivery_details dd,
3831: oe_order_lines l
3832: WHERE l.header_id = p_header_id
3833: AND dd.source_line_id = l.line_id
3834: AND dd.org_id = l.org_id