DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_HEADER_UTIL

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

1234:
1235: -- Convert header into cancel or delete
1236: OPEN ahl_is_header_deleteable_csr(p_oe_header_id);
1237: FETCH ahl_is_header_deleteable_csr INTO l_order_type_id;
1238: l_type := OE_Header_Util.Get_ord_seq_type(l_order_type_id);
1239:
1240: -- If deleteable and not gapless type
1241: IF (ahl_is_header_deleteable_csr%FOUND
1242: AND l_type <> 'G') THEN

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

1239:
1240: -- If deleteable and not gapless type
1241: IF (ahl_is_header_deleteable_csr%FOUND
1242: AND l_type <> 'G') THEN
1243: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1244: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1245: ELSE
1246: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1247: l_header_rec.cancelled_flag := 'Y';

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

1242: AND l_type <> 'G') THEN
1243: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1244: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1245: ELSE
1246: l_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_oe_header_id);
1247: l_header_rec.cancelled_flag := 'Y';
1248: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1249: END IF;
1250:

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

1675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1676: END IF;
1677:
1678: IF (p_header_rec.operation = 'D') THEN
1679: x_header_rec := OE_HEADER_UTIL.QUERY_ROW(p_header_id => p_header_rec.header_id);
1680: x_header_val_rec := OE_ORDER_PUB.G_MISS_HEADER_VAL_REC;
1681: x_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1682:
1683: ELSE