DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_HEADER_UTIL

Line 1203: l_type := OE_Header_Util.Get_ord_seq_type(l_order_type_id);

1199:
1200: -- Convert header into cancel or delete
1201: OPEN ahl_is_header_deleteable_csr(p_oe_header_id);
1202: FETCH ahl_is_header_deleteable_csr INTO l_order_type_id;
1203: l_type := OE_Header_Util.Get_ord_seq_type(l_order_type_id);
1204:
1205: -- If deleteable and not gapless type
1206: IF (ahl_is_header_deleteable_csr%FOUND
1207: AND l_type <> 'G') THEN

Line 1208: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);

1204:
1205: -- If deleteable and not gapless type
1206: IF (ahl_is_header_deleteable_csr%FOUND
1207: AND l_type <> 'G') THEN
1208: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1209: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1210: ELSE
1211: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1212: l_header_rec.cancelled_flag := 'Y';

Line 1211: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);

1207: AND l_type <> 'G') THEN
1208: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1209: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1210: ELSE
1211: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1212: l_header_rec.cancelled_flag := 'Y';
1213: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1214: END IF;
1215:

Line 1644: x_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_header_rec.header_id);

1640: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1641: END IF;
1642:
1643: IF (p_header_rec.operation = 'D') THEN
1644: x_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_header_rec.header_id);
1645: x_header_val_rec := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1646: x_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1647:
1648: ELSE